Can lookup do this?
 

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!

Can lookup do this?
 

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

ice S1 wrote:

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

Can lookup do this?
 

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

Regards,
Fred.

"ice S1" wrote in message
...
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!