Can lookup do this?

I

ice S1

hi, I have a set of data as displayed below
A B
1 apple 8.1
2 orange 9.5
3 orange 10.3
4 apple 11.2
5 orange 90.5
6 apple 73.8


and I would like my end results to be
A B
1 apple 8.1
2 apple 11.2
3 apple 73.8
4 orange 9.5
5 orange 10.3
6 orange 90.5

please help! thank you very much!
 
D

Dave Peterson

Aren't you just sorting your data by column A in ascending order and column B in
ascending order?

In xl2003 menus:

Select A1:B###
Data|Sort
Sort by column A (ascending)
secondary sort by column B (ascending)
Make sure no header row is checked (if that matches your data)

And click ok
 
F

Fred Smith

You can use sort to do this. Simply leave column A out of the sort.
Highlight column B, then Data>Sort

Regards,
Fred.
 

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

Top