Data Analysis in Excel 3 - Filter Large Data Sets to Display Only Specific Information

[rosn73]

Hi, it is hard to explain but I will try my best with my English.I have a in the first column numbers starting with 416XXXXX (41614295, 41694522..etc) and second column numbers starting with 216XXXXX (21642584, 21659980 ... etc)

Each 416XXXXX has it own group numbers of 216XXXXX. I can filter 416XXXXX numbers to give me 216 numbers with no problem. BUT some 416 numbers have other 416 numbers as nested. How can I find 216 numbers from the nested once, it goes for 3 levels sometimes.

[DueSpring]

This is very time consuming when the data is large. 10,000 rows of data is really small - just to give you an example - not that you are using 10,000 rows. When we work with really large data - for example 500,000 rows (and yes in Excel 2007 there is not the 65K limit on total rows) then doing this will either take a long time or your PC will crash..This is not good for large data. But overall a good video for the Filter novice in Excel.

[vikyyyyyyyy]

excellent video! Thank you mister

[mishadhingra86]

Hi! Thanks for these videos! Big help!

I cant seem to find the workbook on teach excel though... any way you could give us the link ?

Thanks!

[37no37]

Hi, good video, please tell me how can I get from a large file of numbers, filter one number for example and check the next line, and know also the average how many times one name or number come after the name or number I plug in. thank you.

[ExcelisHell]

@37no37 This depends on how your data is setup and how you want it to look. Private message me with your details.

[mmilos11]

good video,tumbs up