Consolidation in Excel (Hindi) | How to Consolidate Data in Excel

[@apuchowdhury580]

Jitendra Bhai - to the point, no frills & very practical. Do keep it up & continue the series. Thank you so much.

[@NidhiNikhilSethi]

My channel name is: IT Computer Capture

[@tvenkataramanarao5526]

Jitendra ji thank you for sharing this valuable information explained in an easy to understand manner

[@PowerExbyJitendra]

Thank you sir

[@NidhiNikhilSethi]

My channel name is: IT Computer Capture

[@MazharHussain-me8eq]

learned alot from this . Wao its great way to teach

[@thebesttechnical3608]

Really amazing and helpful video

[@PowerExbyJitendra]

Thanks a lot 🙏

[@biswajitkaran89]

Very very useful and informative Sir. Sir your every video is very attractive. ❤❤❤

[@PowerExbyJitendra]

Thank you so much 🌹thanks🙏

[@deepakaryan3298]

great thank sir

[@lakshmimn6820]

Thank u for sharing your knowledge in simple ways

[@SuvarrnaM]

very useful excellent sir, thank you very much

[@NidhiNikhilSethi]

My channel name is: IT Computer Capture

[@asmagadwale5541]

Amazing 😊😊😊

[@PowerExbyJitendra]

Thanks a lot

[@baharali7429]

Very informative video Sir

[@PowerExbyJitendra]

Thanks🙏

[@sanjaytiwari3810]

Super video 🙏🏻

[@PowerExbyJitendra]

Thanks a lot 🙏

[@Shantanu965]

❤❤ love you sir ji

[@PowerExbyJitendra]

Thanks a lot bro

[@sangeetabhatnagar738]

Excellent teaching

[@PowerExbyJitendra]

Thanks a lot

[@ComputingExpert]

Nice functions of excel

[@PowerExbyJitendra]

Thanks a lot 🙏

[@thyjeet]

Thank you Jitendra ji

[@PowerExbyJitendra]

Welcome sir

[@Narayan14.]

Superb 👍👌👌

[@PowerExbyJitendra]

Thanks a lot

[@hellokids1817]

Sir, now we can do table also in sheet 4, awesone❤🎉

[@NityaSupportTips]

nityasupporttips __ nyc video🎉❤

[@baharali7429]

Very nice and very helpful vedio sir, Sir aik vedio transport business management in excel py bhi Banao sir thanks ❤❤❤

[@PowerExbyJitendra]

OK thanks 🙏

[@wonderman521]

Very good information

[@PowerExbyJitendra]

Thanks 🙏

[@PowerExbyJitendra]

Thanks a lot

[@shreeofficialbjr]

Great job

[@PowerExbyJitendra]

Thanks

[@MR.DESIGNER.2]

Thanks 😊

[@PowerExbyJitendra]

Welcome

[@understandthewordsfeelthes3036]

Well Explain 👍👌

[@PowerExbyJitendra]

Thanks🙏

[@saleemmalik4490]

nice illustration

[@PowerExbyJitendra]

Thanks a lot

[@Couriosity]

Nice❤

[@PowerExbyJitendra]

Thanks 🔥

[@baigsufi321]

Very good

[@PowerExbyJitendra]

Thanks

[@jayanthamadasekera8248]

Please explain how to write vba code to unlock and lock for macro recording sheet in your debit credit balance sheet video.

[@PowerExbyJitendra]

Watch it : kzbin.info/www/bejne/p5nKhIlja9Bmfa8si=3tT5WnjiWezfCLX5

[@jayanthamadasekera8248]

Thank you so much for your quick responce. Explain very clearly. If you can insert caption in english it will very helpfull for every one out side India.

[@vitthalgaikwad1058]

Thank you sir

[@khazaraheemsyed3283]

The consolidate function will work with different range data in different sheets?

[@syedikramullah1114]

Superb sir

[@PowerExbyJitendra]

Thanks a lot

[@yashodak1909]

Is there a way to consolidate the data in one file if it is in different files instead of different sheets?

[@Amitrajpoot_23]

Yes

[@chandangowdachandu1348]

Use import range formula

[@ShafiUllah-z7v]

I need to learn medical coding

[@rpmasti.in0]

Sir data analysis par video banay

[@gasha2261]

Sir how to extract data values from other sheet if we have one thing in common

[@AbdulRehman-wp9xt]

Excellent

[@PowerExbyJitendra]

Thanks a lot

[@brightcomputertechnologych4872]

VERY GOOD

[@PowerExbyJitendra]

Thanks a lot

[@offcialsupervisor758]

thanks

[@PowerExbyJitendra]

You're welcome!

[@davidsonsunny2886]

Good info

[@PowerExbyJitendra]

Thanks

How to select combination of any 10 numbers from 20 numbers such that the product of select d 10 numbers maximum or minimum?

[@dj_gameshow8058]

Use Max or Min function in combination with Product function

[@rpmasti.in0]

Sir advance excel par video banaye jo office me use hota hai

[@PowerExbyJitendra]

I have so many videos please watch

[@md.tawheeduddin5805]

Sukhria

[@PowerExbyJitendra]

Thanks a lot

[@understandthewordsfeelthes3036]

Helpful information 👍👌

[@PowerExbyJitendra]

Thanks a lot

[@maheshnevase9650]

Make video on vlook up for large data

[@PowerExbyJitendra]

Okay 👍

[@ahp6131]

Hello, how do you calculate product cost ?

[@SkillEduserv]

Sir kawan sa software use karte hai video banane ke liye.

[@slamdalvi527]

Sir product name ek saath one time main kaise add kare. Jo aap ne one by one kiya hain

[@Deependra1991]

Product k sat qty n price hoto kese hoga har month ka subtotal consolidation m

[@abuzarshaikh4583]

Wo primary sheet m colum add kr lo na too final sheet m b wo colum add ho jayega (mtlb jo b krna h primary sheet m set kr lo)

[@babumosai549]

What if columns are not in proper order?? 🤔

[@NidhiNikhilSethi]

Channel kese monitor Hota h

[@shubhamrathore3703]

Yes I need help I have a data like this 👇 Arun 49/100 Arun 10/4030 Arun 39/29 Bala 29/29 Bala 20/10 Rahul 10/29 Rahul 34/59 I want to convert this into this 👇 completely by formula, bcz I so many values like that Arun 49/100, 10/4030, 39/29 Bala 29/29, 20/10 Rahul 10/29, 34/59

[@yourvikram]

Hello bhaiya Mai Jharkhand se hu aur ek chhota sa cyber cafe chalata hu. Maine apki ek video ' Fully Automated Report Card' dekh k ek school ka report card banane ka order le liya hu but uski requirement ke anusar bana nhi pa raha hu. Kya aap help kr sakte ho.

[@PowerExbyJitendra]

I will contact you please share your mobile no on my Facebook page

[@sonusarraf5193]

Hello sir compound interest par video banae

[@PowerExbyJitendra]

Zaroor

[@CEMEERUT-II]

3579 rows

[@mahammadsamsuddin7606]

Sir, ropa 2019 ka ek automatic salary calculator jismay pay matrix vi hoga eisa ek video banay. Please.

[@shoebaghadi1236]

I have 4 file city wise , Mumbai, pune, vadodara & surat a vendor supply consumables to all locations but their requirements are not same , i have to compare prices of products he providing to all locations.. please help me out for this ...

[@PRINCEKUMAR-r4g]

😮😮😮😮😅😅😅😅😅😅😅😅😅

[@jagameher3999]

Use vlookup formula

[@ayeshagulzar92]

Mujy aik city k samne walay colum main auto fill amount chahye. Ho skta hai? Like lahore k jb b type ho us k samne kud amount ay​@@jagameher3999

[@vivekm7971]

Nice question

[@RaviKumar-n8w1p]

एक शीट में A to Z कॉलम में डेटा है , उस डेटा को मुझे रोज अपडेट करने पड़ता है । मेरा प्रॉब्लम ये है कि आ सेल का डेटा B में , Z का Y में,..पेस्ट हो जाता है । ऐसा कोई condition लगा करते है ,A कॉलम में एक सेल का वैल्यू को फिक्स कर के डेटा पेस्ट कर दे तो डेटा चेंज नही होगा ।

[@picnicpoint9129]

Mary pas online sheet hai jis mai dropdown lagy hovy hai wo sheet agar mai waha sy dosri sheet mai paste karta hon to dropdown show nhi hoty ..ye kaisy hoga

[@PowerExbyJitendra]

Nahi hoga apko dobara create karna hoga

[@divms_23]

Importrange formula try kariya

[@NidhiNikhilSethi]

Agr apko next sheet par bhi list icon lage hue tabular format m data chahiye to aap paste special b to try kr skte ho. My channel name is : IT Computer Capture

[@rahulsarangal8123]

Nice bt sir agar sheets 50 se jyada ho tab kya kate

[@PowerExbyJitendra]

No issue process will be same but you can do it quickly using Power Query. .

[@muhammdliyaqatali7352]

Answer please

[@rahulsarangal8123]

@@PowerExbyJitendra make relevant video if possible

[@PowerExbyJitendra]

In this case we use Power Query you check out our playlist of Power Query

[@PritamPaul717]

🙂🙂🙂🙂❤❤❤❤❤👍👍👍👍

[@PowerExbyJitendra]

Thanks a lot

[@podamaire]

SLect karenge

[@anshukumar4252]

Nahi hua

[@sonusarraf5193]

Jisme time 2.5year ho

[@NidhiNikhilSethi]

My channel name is: IT Computer Capture

[@PowerExbyJitendra]

Best wishes for your channel.

[@understandthewordsfeelthes3036]

Helpful information 👍👌

[@PowerExbyJitendra]

Thanks a lot

[@TheMharrissiddiqui]

Excellent

[@adityabhandari9259]

thanks

[@PowerExbyJitendra]

Welcome