I created a daily budget spreadsheet in which I mention each daate spending and income. It automatically updates the cash flow and shows the remaining balance each time I fill in the data in the expense tracker according to the date. Now, I want to create an Area graph, so I first applied the UNIQUE formula to the date column so that common dates are not repeated. However, now I can't track the remaining balance for each date. What formula or method should I use to track the balance for each date? With the help of the date and the balance for that date, I can create an Area graph

Hi brother, can you please help me out for the google sheet, I want to track the historical values of eg. cell A1 each time a change is made to the cells in eg. B1:B5. So whenever data in column B changes, the corresponding value of A1 should be recorded in column C. If you are willing to help me I'll explain in detail about this for you it will be very easy for you beautiful you are expert in it

So helpful!

What if just two or just three combination not all ?

what if i just want 2 and 3 combination not all?

Master can you make same in excel target vs actual inside data label with actual and achivement %percentage in outside data label .

Excellent

Amazing Bro

sir, this is exactly what I was looking for! Thank you! however I got an error, when trying to use the Lambda and vstack formula. What are "A" and "R" in those 2 formulas? When I hit enter for the formula I got a #NUM! error. Thanks for any help!

Great

Great work bro!

Good one

Bro, you are awesome

i couldt understand what happened 1:39 , where did you press?

hi @DataDash Pro, is there any way to add those dropdown lists to multiple columns in the same sheet? I tried to copy paste and drag and drop but nothing works, do you have a formula for me or something else?

Definitely the best dropdow technique for GS

Thank you. I had a dropdown for income and expense codes and often chose an expense code where I needed an income code. If I may respectfully request, could you show the formulas again after entering them? I had a little difficulty pausing to copy them as I followed along.

Thank you!!

Great video , thanks. what is your opinion to use option control button directly instead . Thanks again

Fantastic and clever way 👌👌👍👍

Could you help me with the following issue? I apply a method with three levels: level 1 is Destination, level 2 is Start Date, and level 3 is End Date. The problem arises at level 3 because multiple destinations can share the same start dates but have different and similar end dates. As a result, I see end dates that are not possible for the specific destination and start date combination. How could I resolve this?

Elegant solution, but does not generate all possible permutations.

Thanks, this is very useful, but how do I make it work to also show results like B-A, D-A, etc. as this one seem to only work to the left, and not backwards.

docs.google.com/spreadsheets/d/1SMS9hbqIEOFaDuzrr_KmvVWFyXMmJvjnqTuaVNgWXUE/copy File link

Thank you so much for this video but where is the command to copy and paste it ?

omg u helped me a lot, thank you so much for this straightforward video!!

Wow bro

HoW do become 4 tables the repeat value

wow this is very impressive

Awesome

Anyway you can think of to do this, but still be able to sort and apply filters to your sheet?

Great bro

You are just Amazing

wow like this concept

thanks its worked perfectly

i have try but not working

i have excel 2010not working

Great Work, But it sum the number in cells, is it possible it only count the data cells number?, because when I entered any value in place of 1 it sum it in numbers

Wow super thank you great useful tip for my research writing ❤❤❤

Yes, finally with a good explanation how to do this. You have my thanks!!!! And my Like and a sub!

Thank you. your effort helped me!

This is great, thank you, but if I sort the table, validations break. Is there a solution for when you need to actively work with a table and sort it?

Also I'm trying to convert the data from Celsius to fahrenheit

It wont let me click on it

can't find the dashboard

Wow Bro

This video helped me , Thanks

Thank you so much for this video, I am already using it

Hey im trying to enable something like this. What are you using. What software or what is this

Thanks for making it much easier I