Ascending order sort..

C

ChrisB

my spreadsheet consists of about 7 columns of data, each row has
relevant data that corresponds to each column in that row. For example,
in Row 1, I have A which is product, B which is description, C which is
price, D which is stock, and so on. I had to sort column A in ascending
order for me to be able to perform a VLOOKUP. Now that ive sorted A in
ascending order, that has completely screwed up my spreadsheet, it
threw off all my product IDs so now they dont correspond with the
descriptions or price anymore! is there anyway that when I sort by
ascending order the column I want, it will take everything else in that
row with that perticular column ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA- Excel Programming:- 0
In a sales quote sheet - sum totals by license type 1
Excel How To Create A Min Formulas That Will Take The 4 Min Value In Ascending Order 4
Data/Sort by ROW not column 3
Sort 2
Sort ascending, make changes, restore previous order 1
Data Connection with Text Import Problem 8
Cannot sort blanks to bottom of table 2

Top