excel

W

wendy

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I have a list of numbers that I want to use to sort some prexsisting data...i need all of the information in each row to stay together too, i don't want to have to sort all 3000 values and the find will only do one number at a time and i need to sort about 300 values and their associated data.
 
B

Bob Greenblatt

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I have a list of numbers that I want to use to sort some prexsisting data...i
need all of the information in each row to stay together too, i don't want to
have to sort all 3000 values and the find will only do one number at a time
and i need to sort about 300 values and their associated data.
Click to expand...
I'm not at all sure from your description about what you want to do. You can
SORT all the data by highlighting all the rows and columns and then doing a
SORT. All the columns will stay with the appropriate rows. If you don't
really mean SORT, then maybe filter is what you want. Highlight the area and
use data-Filter. If this isn't what you mean either, then please try to
explain your needs again.
 
Top