A Drop of Excel - 05 | How to create a Formula across Sheets and or Files in Excel
Many times you have data in multiple sheets instead of only 1 sheet.
You want to do some calculations based on data in these multiple sheets. This is where you will see the need to create formulas across sheets in Excel.
Sometimes you may also need to carry out calculations on data across multiple Excel files.
In this video, we will learn both of them, in a very simplified explanation.
* Example file link
drive.google.com/file/d/1prRr...
\ Previous video: • A Drop of Excel - 04 |...
/ Understanding of the data being used in the examples: • A Drop of Excel | Unde...
Related Videos/Posts
18 Most Useful Excel shortcuts -- • 18 Most Useful Excel S...
Пікірлер: 7
Thanks Rushabh, this is just amazing
very good ! very helpful!
@Excelrush
4 жыл бұрын
Thank you!
@Excelrush
4 жыл бұрын
Thank you!
Is it possible to enter changing values of single cell(suppose c1 is my 1st cell of my column)in next cell after every change in c1.if value in c1 change it should keep entering new values in c2 c3 c4 and so on..?plz help
@Excelrush
3 жыл бұрын
Can you tell me should be the values in C2 , c3? There are dynamic functions like =filter, =unique which can do such things, but depends on your use case.
@adityal3854
3 жыл бұрын
@@Excelrush suppose i linked live clock to excel, bcoz of changing time the value in particular cell(consider cell c1) will automatically change, Is there any way i can automatically record all the values of cell c1?.