วีดีโอ

very helpful, thanks!

Can you do this in Excel some of the functions are named differently but I cannot get the same result. When I use TEXTSPLIT it does not split into separate columns.

Nice video! As an alternative: =LET( values,B4:B13, groups,D4:D6, HSTACK(TOCOL(IF(SEQUENCE(,ROWS(groups)),values)),TOCOL(IF(SEQUENCE(,ROWS(values)),groups),,TRUE)))

good one👍❤️

Butt fall 🎉🎉🎉🎉🎉

Good 👍

❤❤❤❤❤❤❤🎉

brother how we can create pairs for 5 years...lets suppose in the video country pairs is for 2022 year and for the next year again we create pairs ..so by formula how we create please help me

I subscribed your channel.🎉

Hey Thank you so much for this video... I want to do the same thing. But i have an additional condition here. I want to find the possible pairs from the single coloumn which belong to the same group. Lets say in the same excel you havs another coloumn called group. And lets say you have 10 countries. First 3 countries belong to group 1 And next 3 belong to group 2 Remaining 4 belong to group 3. I just want to find possible pairs for each group. I really need it urgent. It will be very helpful for me.. Thanks in advance brother

Good content. Thank you.

Cant find the options in version of excel I am using(vary colour by points,other data value labelling) options

its awesome master . i have one doubt if we need to see the achievement percentage against the sales can you show to us how to make there % together with the actual sales.

Thanks.

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