OMG Brilliant, thank you!! Trying to sort dates here and none of the other videos work because it only gives me the option A to Z in the filter box. Adding an extra numbered column and sorting that is the way to go!
Thank you! I copied and pasted a transcribed Hebrew manuscript and used Text To Columns to get each word in its own cell. However, the word order is in reverse .... I knew someone could help me out! Thank you so much, I just subbed to your channel
Thanks Rushabh u have explained so nicely about Row & Coloum specialy by giving example of movie theatre was v easy way to understand....Thanks alot God bless you 😊
Thank you for sharing the tip on how reverse a list. So, I just wanted to share as well that you can make it dynamic by using the SEQUENCE & COUNTA functions for the numbering, and then using the SORTBY function to sort using the dynamic numbering your created. Hope it helps. Thank you!
Good Explanation. What if all those last names are in a Jumbled format, How can we sort them in such scenarios using formula, Can you please me that video?
i have watched almost 10+ videos but didn't find the solution but this video made my whole life easier thank you soo much
you just saved my life with a list of 12870 items 50 years of Data. many thanks.
Exchange rate data?
@@lachlanhyde1924 something like that. 👍
I've a list of 2000 but I can't do this an error is occurring will u plz do mine?😪😪
@Soroush Akbari
After a lot of searching I found this video, it's really rare video Thank you so much
OMG Brilliant, thank you!! Trying to sort dates here and none of the other videos work because it only gives me the option A to Z in the filter box. Adding an extra numbered column and sorting that is the way to go!
This is the easiest way to invert a whole table of data upside down or vice-versa. Thank you so much.
Do subscribe to the channel for more such tips!
You can do it without adding extra column as well..
Just use formula =INDIRECT("A"&24-ROW())
😊
This was so freaking useful, thank you very much
Rook me a few tries but finally got it, thanks.
Thank you soooo much. I was sitting her for over 1 hour then gave in and found you. Subscribed. 😀👍😀
Wow, that's awesome! I'm so glad this helped
Omfg... When he added the list of numbers I felt like a dumb dumb xD
Let Me subscribe, you just saved me a whole lot of time. Thank you men !
Extremely helpful tutorial. Had a list of 1,095 items that I really didn't want to manually re-enter! Many thanks.
Mjsa ni hua will u plz do it for me?🥺🥺
Many thanks! Your video should be the first to appear, I've been for the right video for days!
Great little trick! Saved me a pile of manual rejigging. Thank you!
Thanks for this, you helped me figure out how to do this Numbers for mac.
Thank you so much for this guide. I have subscribed to your channel. God Bless and Stay safe.
Best video on this topic online
Thank you! I copied and pasted a transcribed Hebrew manuscript and used Text To Columns to get each word in its own cell. However, the word order is in reverse .... I knew someone could help me out! Thank you so much, I just subbed to your channel
Brilliant, easy to follow video that worked the first time. Thanks again!
Thanks for the video. I was searching for the way to this.you made my day happy.
Thankyouu so much man!
Really helped me, now I can start my assignment 😂😅
THANKS, SAVED A LOT OF TIME
FANTASTIC VIDEO !! Very well explained.
Thanks Rushabh u have explained so nicely about Row & Coloum specialy by giving example of movie theatre was v easy way to understand....Thanks alot God bless you 😊
Thank you! Do share the video with others!
wooww... simple and crazy easy technique.. thanks 🙂
Thanks a lot dear !
May God bless you
Thank you for the help :")
Always the homies in India with the best tech support videos on youtube
Super! and best info to solve the problem. Thanks
4 din se aatka tha problem solve ho gyi thanks a lot
this was the very hardest example you showed to explain really extraordinary trick
You can do it without adding extra column as well..
Just use formula =INDIRECT("A"&24-ROW())
😊
Best guide on youtube GJ
Thanks mate. Nicely explained
Thanks for the explanation. It helped!
Thank you so much! Your an angel
wow thank you... you helped me... I wish I could be as useful as you
Thank you for sharing the tip on how reverse a list. So, I just wanted to share as well that you can make it dynamic by using the SEQUENCE & COUNTA functions for the numbering, and then using the SORTBY function to sort using the dynamic numbering your created. Hope it helps. Thank you!
Many Thanks. Really helped me with my work. Thank you.
Do subscribe to the channel!
U r god for me now😂❤
wow you save my day. thank u
Very helpful video. Thank you
Thank you so much for the video
I really benefited a lot, thank you very much🥰🥰🥰
Bro you are awesome
Informative 👍
This is just what i needed
thx bro u saved my life
simple and superb.. good job
Thanks Brother!
you're a life saver
Thanks a million!! Dunno why I didn't think of this haha!
Excellent! really best video, thank you sir.
Fantastic explanation thank you!!!!
Thanks ton. It's helped me lot.
Thanks Excel Expert....
Saving too much time 😊helpful 👍
Oh my! You just saved me. I'm so grateful 😭🤗👏👏
You can do it without adding extra column as well..
Just use formula =INDIRECT("A"&24-ROW())
😊
Thankyou for the video!!!
Absolute legend. Subscribed :)
Thank you brother
thank you a lot sir!
Thanks for information
Thank you. it did work on Google Sheets as well
Do subscribe to the channel!
thank you so much. this was really helpful.
Thats called basic concept clarity
Thanks, video helped me a lot....
Рахмет. Спасибо. Than you.
Thank you!!!
Thank you so much sir
Thank u so much 🥰
Good Explanation. What if all those last names are in a Jumbled format, How can we sort them in such scenarios using formula, Can you please me that video?
Thank you sooooo much sir....
thank you!
THANK YOU SO MUCH! This was very very helpful!
You can do it without adding extra column as well..
Just use formula =INDIRECT("A"&24-ROW())
😊
Thank you this is really helpful.
You can do it without adding extra column as well..
Just use formula =INDIRECT("A"&24-ROW())
😊
awesome thank you
Thank you!!!!!!!!!!!!
It was helpful
tq u so much,, i m a new subscriber
Thank you, this really helped me.
you are a GENIOUS!
You can do it without adding extra column as well..
Just use formula =INDIRECT("A"&24-ROW())
😊
Its helpfull. thank u
Thank you very much. This was fucking amazing. I knew the answer was out there in TH-cam world somewhere.
Thank you for sharing. Sooooo helpful!
Thank you very much sir i really want to join but due to old edge I can not join so pl. excuse me.
Wow, you just saved me so much time. Thanks so much
Thanks for this valuable info
Its a jugaat but amazing 😉❤️
Thank you sir
An easy step.. thank you.
You can do it without adding extra column as well..
Just use formula =INDIRECT("A"&24-ROW())
😊
thank bhai aapne mera soluation bata diya
simple yet very useful. thanks
Thank you so much!!!!
Thanks bro ❤
very nice
awesome tip! Thanks ExcelRush :)
You can do it without adding extra column as well..
Just use formula =INDIRECT("A"&24-ROW())
😊
so helpful for my final year project, thank you so much!
You can do it without adding extra column as well..
Just use formula =INDIRECT("A"&24-ROW())
😊
very helpful , thx
thanks a lot man!
Thsnks bro
Thanks
Thanks a lot....
thankyou so muchhhhhh