I have a sheet full of raw information that will be converted into sales leads. It contains about 1600 rows with columns of information from A-AR
I need to extract 500 rows of information based primarily on the data in two columns.
Column A contains numbers ranging from 0-400'ish whereas Column B contains numbers ranging from about 300-3500.
I want to neatly extract 500 rows of information where A is 2-400 and B is 2500-3500. This will need to be put in a separate excel sheet, leaving the remainding rows to be usable for someone else, who will extract the rest of them.
I've used Excel now and then but never made much use of the more powerful features. However as I've taken on more responsibility at the office I think it's time to unlock the power that is Excel and I hope bothering you chaps with questions can do that for me.
So far I've managed to format Column B into numbers and STILL not manage to sort it from highest to lowest (as for some damn reason it just sorts it based on the first digit).
If you need more information or if my language is in any way unclear, please do let me know.
Bookmarks