Can lookup do this?

[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!

 

[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

 

[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.