I have an inventory spreadsheet with data like this:
Description Count
Hammer 1
Anvil 5
Pliers 2
I want to create two new sheets.
One with the data in order by the Count
and one with the data in order by the Description.
Like this:
Anvil 5
Pliers 2
Hammer 1
and the other:
Anvil 5
Hammer 1
Pliers 2
I think I know how I can get the Count values into the
correct order by using functions Large and Row/Rows.
And I can do the same thing with the description.
But how do I keep the two columns together?
I think I need to have the Description cell and the
Count cell managed as a pair. But I only want to
evaluate one of the columns at a time.
Well, thanks for any advice!
Bookmarks