Help on Sorting multiples with formulas

[sharon]

I need help with sorting by using functions. I don't want to use the
sort button because I need the data to stay the way it is. And I need
to graph it. To graph it, it has to be sorted so that I can pick the
series. And I don't want to have to re-type in the proper order just
to graph it. So, this is what I have so far:

A B C
sue 14 =IF($A2=bob,3, IF($A2=joe,2,1))
joe 21 =IF($A3=bob,3, IF($A2=joe,2,1))
bob 15
sue 10
sue 12
joe 9
D
=LARGE($C$2:$C$7,ROW()-ROW($D$2)+1)

E
=INDEX($A$2:$A$7,MATCH(D4,$C$2:$C$7,0))

F
=INDEX($B$2:$B$7,MATCH(D4,$C$2:$C$7,0))

It works if there were no duplicates. How do I get it to work with
duplicates. Any help would be appreciated.

 

[Paul B]

Sharon, how about adding a column and number it 1-?? and then sort your data
like you need it, then when you are finished with it just sort by the new
column to put it back like it was, would this work?
--
Paul B
Always backup your data before trying something new
Using Excel 97 & 2000
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **

 

[sharon]

Alan,

I tried it and it works great. Thank you so much for your help. I
really appreciate it.


Sharon