Help on Sorting multiples with formulas

  • Thread starter Thread starter sharon
  • Start date Start date
S

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

I'm a bit new to this myself, ( this is my first time on the giving info
side!), but here is my clumsy answer.

Column C
=IF(A2="","",A2)

Column D
=IF(B2="","",VLOOKUP(F2,B$2:C$14,2,FALSE))

Column F
=IF(B2="","",LARGE(B$2:B$7,G2))

Column G
should number 1, 2, 3, etc

After you have entered all the formulas, drag them down to fill the cells
under them.

This should give you the names in column D and the scores in F

If you drag them further down than the table it will give you blanks (Zero
length strings)

Alan
 
Alan,

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


Sharon
 
Back
Top