Excel all versions. The efficient use of Sort and Filter for all users

Understanding the use of sorting and filtering data in Excel spreadsheets is one of the most important parts of the program.
This video explains the basic use of the procedures.
The file used can be downloaded from www.unitedcomputerconsultants.com/excel and look for "large file". Free to download and great for practice.
Visit us at : unitedcomputerconsultants.com
Tweet us at: / geoffhudson7

[@MrMakeyourown]

This is so still relevant today, much appreciated for this, especially for the older generation, much appreciated again

[@unitedcomputers]

Thank you !!

[@sharondunn7512]

I have been completely frustrated for the last two days trying to incorporate a sort tab into the columns. I normally use Wordperfect Quattro and in this case, I am using Word. You solved my problem in about 5 minutes. I opened the document, left the video to run so I could hear your voice and followed your instructions. Thank you SO much!!

[@unitedcomputers]

Sharon, thank you so much for your kind comment. It is so much appreciated.

[@XS10SEALS]

You have single handedly helped me and my department sort through months worth of work with ease. Thank you so so much!

[@unitedcomputers]

Thank you ! It is a pleasure to help, Adrian.

[@1030warren]

Underrated tips! Hope these comments help the KZbin Algorithms

[@dougprovins7487]

Exactly what I was looking for. Simple, but I had never taken the time to figure this out. This was what I needed, and the added bonus of subtotals was also useful. Thank you.

[@unitedcomputers]

Thanks Doug !

[@antoniomaria2026]

I'm doing a catalogue in Excel of all the books in my parent's house, this is super useful. Thank you so much

[@unitedcomputers]

My pleasure

[@louiseb189]

God bless your soul! Thank you! Thank you! Thank you! Thank you! you! almost lost my mind searching for ways to include all rows in the filter

[@unitedcomputers]

You're welcome!

[@matts2581]

"Remove the blank Row/s" Brilliant. ;) :D TY :D !!!

[@unitedcomputers]

Thanks Matt !!

[@toyadventures4259]

people like myself only understand with the way you teach. Thank you so much for a helpful training.

[@unitedcomputers]

Thank you !

[@Kat-n-Ollie]

You just saved my butt for work I have to do this weekend. Thank you so much. You're great at explaining how things work.

[@unitedcomputers]

Thanks a million Kat..happy to help !

[@coltencoleman5513]

I know I am quite randomly asking but does anybody know a good website to stream new tv shows online ?

[@issackylo2019]

@Colten Coleman I would suggest Flixzone. You can find it on google =)

[@mathewzev1829]

@Issac Kylo definitely, I have been watching on flixzone for since march myself =)

[@coltencoleman5513]

@Issac Kylo Thanks, I went there and it seems like a nice service :) I really appreciate it !!

[@wanjadouglas3058]

Thank you for teaching something great...you changed my life

[@unitedcomputers]

You are so welcome

[@yourshma]

Thanks! You've helped me with my report!

[@unitedcomputers]

My pleasure !

[@lilybelle3dd39]

Thank you so much, really appreciate how easy it was to follow.

[@unitedcomputers]

Great to hear!

[@luisaviliamu582]

Thank you - great tutor!

[@unitedcomputers]

Thank you Luisa !

[@jenniferh189]

Kind sir: I was panicking because I could not figure out how to do this for a work report. You saved me today. THANKS from California!

[@unitedcomputers]

Thanks Jennifer..from Down Under

[@Girl-on-fire]

Thanks for this tutorial, quite helpful.

[@unitedcomputers]

Glad it was helpful!

[@adrianasilveira4561]

Very useful and easy to understand. Thank you

[@unitedcomputers]

You are welcome!

[@halimamohamed6132]

Thank you, this video is very useful!

[@unitedcomputers]

Glad it was helpful!

[@kongslark]

Very useful, unlike other excel videos

[@unitedcomputers]

Thank you Solomon.

[@demolitionman26]

Thank you.

[@unitedcomputers]

You are very welcome

[@PoliphiloShek]

That's very useful. Thanks.

[@unitedcomputers]

Glad it was helpful!

[@bretts1]

Thank you!

[@unitedcomputers]

Thanks Brett

[@magekenia]

exactly what i needed

[@unitedcomputers]

Great !

[@reignrelic]

Hi, How to I keep the first column still so when I sort it doesn’t move?

[@fightcancer]

Thanks!!

[@unitedcomputers]

Thank you

[@jessicarios2481]

Thank you!!!!!

[@unitedcomputers]

You're welcome!

[@ramezredarr]

THAAAAANKS SOOOOOOOOOO MUCHHHH

[@unitedcomputers]

My pleasure !

[@wdc7582]

For more clarity, I am trying to protect the formulas in the sheet whilst still allowing the user to using all the sorting functions. I hope this is clear.

[@unitedcomputers]

Hi William. Thank you for your comment and question There are quite a few possibilities re protection of worksheets, so rather than go into a long diatribe here, I refer you to the following link which willhelp. support.office.com/en-us/article/protect-a-worksheet-3179efdb-1285-4d49-a9c3-f4ca36276de6

[@sophiafeng9283]

helpful.

[@unitedcomputers]

Thank you

[@engr.sarwarhossain7713]

Can you plz leave the data sheet used in this tutorial so that we can practice this lesson in a better way . Thank you

[@unitedcomputers]

Please see the unitedcomputerconsultants link details in the description below the vide0 (The file used can be downloaded from www.unitedcomputerconsultants.com/excel and look for "large file". Free to download and great for practice. )

[@fring3]

@@unitedcomputers Thank you very much!

[@johneltonnonore2519]

How many country is in the data? Would you mind explaining it to me how to get the total number of country in the data? I am really interested.

[@unitedcomputers]

Go to the Data tab In the Advanced Filter dialog box, click Copy to another location. If the countries are in Column B... Set both List Range and Criteria Range to $b$2:$b$2156. Set Copy to to $m$2 Keep the Unique Records Only box checked. Click OK. This will filter all the duplicated countries out. Then use the "Rows" function to e.g.=rows(select the cells containing the filtered countries) You can now see the number of unique countries Repeat for the salespeople.

[@johneltonnonore2519]

Thank you, it works, really appreciated.

[@noun613]

I feel stupid because I don’t know how to sort and filter

[@unitedcomputers]

Remember to practice ! :-)

[@noun613]

@@unitedcomputers I was asked to sort data at work and I didn’t knew how to. 🤷🏽‍♀️