วีดีโอ

This helped me. Thank you!!!

Thanks my friend ❤

gracias por la actualización! muy buena!

Thanks

Thanks - clear, to the point advice that works

thanks, it's helping even 9 years after you posted the solution

Fantastic, why this information is never included in all of the responses by the so-called experts on issues with sorting data is beyond me. Top marks for this solution.

thank you so much.. it works

Such a simple solution. Thank you!

You saved me so much time! I was pulling my hair out doing these budget forecast for work and the only thing my boss wanted fixed by Monday was the sorting issue. You're the goat!

OMFG years struggling with thouse items on my files. Thank you so much and god bless you.

Hi , Thanks You so much, it was very helpful.

Thank you very much for helping me out for my tax returns!

Thanks

You have saved my life, my dear friend ❤

thank you! very much for the quickest help 🤩

Hell ya! Thanks so much - huge help

Thank you 🙏🏾 for sharing

You are a saviour❤

just saved my job 😂

this is very nice. thanks a lot. kind of saved my job. 👍

Thanks very useful

nice. if doesn't work, you have to save spreadsheet for scrollbar to reset

Breaking my brain on this for days. Searched Reddit, stack overflow, Microsoft community. Hadn't seen this mentioned *anywhere* as a possible culprit. In a less than 2 minute video, you saved me so much headache

9 years old video helping me in 2024. THANKS BRO

this is my biggest pet peeve with excel

Amazing! Thank you very much.

thank you very much 👍👍👍👍👍👍👍

Thank you!😊

very helpful, thank you for the tutorial

Man you save my life

Super 😮😮

Great Job 👍

Thank you from September 2023

PICA

Now I try to remove these May and Jun with 0 values without filtering. is this possible?

Omg you have no ideia of how much you have helped me. I’ve trying to solve this issue for more than a month and I did what you said and not excel is sorting my table correctly! Thank you so much

THank you, But what if I am using multiple sheets for the formula?

Also check to see if your "numbers" have a hidden (not really hidden just hard to see) blank space...that will really mess things up...the type( ) will not work, you will get a #value error and the multiply by 1 or add 0 also wont work. I still would expect the format cells thing to work. F Microsuck, that format cells should detect the blank and still convert the text to a number. Idiots.

absolutely should not have to multiply by 1. MS has the format cells THAT DOES NOT WORK AS ADVERTISED.

Why in the F would Microsuck not allow a user to reformat cells from text to numbers while giving the appearance that it does exactly that but then DOESTN! INFURIATING.

Thank you for the excellent explanation. However, it does not fix my problem. Finally, I noticed that the comma "," was the problem maker in my case (it was currency in Indian system lakhs & thousands instead of standard 1000 separator). I replaced the "," with blanks using find and replace which solved my problem. Once again thanks for ISTEXT and TYPE functions.

This is excellent!! Thank you so much!👏I was highlighting different data sets to add filters to each set and I would do one set which would undo the other. Your solution was genius and saved me so much time because I was about to put a different data set on separate tabs, but your solution is easier and quicker. Thank you.

Thank you so much! The paste-multiply was the only solution for my issue and never would have thought of it! :) I was in some weird infinite loop trying to figure out why things weren't matching between two large sets of data. Excel is the best! Thank you for your service in making so many people better as a result!

How do you convert series of numbers into date? For example I have 1231206 and want to convert it to 12/06/23? So there is the 1 extra in front of yymmdd...is there a simple formula to convert that into a date? Thanks

I appreciate you getting me through Econ 262, Thank you sir

THANKS FOR SHARING ...I WASTED SO MUCH TIME TO LEARN THIS....BUT YOU DID IT WITHIN NO TIME.....THANK YOU

Thanks dude

Thanks for sharing this fantastic solution. This is very helpful.

How do you use SUMIf function based on filtered data, for example i am looking for a negative and positive values in same column but it will give me grand total, but i want a total of both negative and positive values based of a certain date. could you help ?