Hi. Why if the rows are not the same in all the sheets? Meaning, one sheet might have 90 rows, another 100, and so on. Would Consolidation still work in that case?
Awesome video and explanation. I have a doubt in this video Location of John is changing, understandable. But the other values are different in different sheets like Mike7, Mike3 and Mike1 missing in respective sheets. So how did it consolidate the values for them?
Hi Sir, I've been following your excel videos, your explanation is good and easy to understand. Can you please explain how to consolidate only the data from multiple workbooks into one workbook? I mean not calculating formulas.
www.coursera.org/learn/excel-intermediate-1/lecture/rCZ3p/practice-video-consolidating-by-position Hope this link helps (you don't have to buy the course, this video is available even if you just 'audit' it)
How will this formula work if there is no uniform column or row heading? Eg I have 5 students marks in sheet 1, in sheet 6 students . How such cases can be consolidated ?
To Get Certification, Click Here: bit.ly/38Jyu3p
Use coupon "CZcams12" to get ‘’FLAT 12%’’ OFF at Checkout.
sir i have no words for u....tommorow is my practical and i have not studied anything....but just because of u now i am onfident
Do you know that our school it teache suggest your's video 😮 good keep it up 😂😂
BEST IN THE WORLD 🌍
Hi. Why if the rows are not the same in all the sheets? Meaning, one sheet might have 90 rows, another 100, and so on. Would Consolidation still work in that case?
sir your way of explanation is awesome
Thank you. May I request you to share one vdo on sum of odd and even column/row.
Excellent explanation, Thank you
Awesome video and explanation.
I have a doubt in this video
Location of John is changing, understandable. But the other values are different in different sheets like
Mike7, Mike3 and Mike1 missing in respective sheets. So how did it consolidate the values for them?
their values is considered 0 . see in sum sheet ,there are 8 rows , where as in reference data there were 7 rows
thank you very much
Hi Sir, I've been following your excel videos, your explanation is good and easy to understand. Can you please explain how to consolidate only the data from multiple workbooks into one workbook? I mean not calculating formulas.
See just above video
hello sir your videos are very useful to most of the real people .
i am unable to get conslidate function not working how can i resolve it
www.coursera.org/learn/excel-intermediate-1/lecture/rCZ3p/practice-video-consolidating-by-position
Hope this link helps (you don't have to buy the course, this video is available even if you just 'audit' it)
Very helpful and owe some presentation
Thank you😊😊😊😊😊
It's like magic
I just want to know, is it possible with name means one column with name and row with number, if anyone just mention formula name....
How will this formula work if there is no uniform column or row heading? Eg I have 5 students marks in sheet 1, in sheet 6 students . How such cases can be consolidated ?
26/12/23
hi please show us productivity dash board on excel
Please sir GST ka class lijiye aap🙏🙏🙏🙏🙏🙏