Prev: autoscale stock chart
Next: Search and Replace, or Add New Row
From: Rob on 20 Apr 2010 22:17
a b c
Name Vault Rank
Blake, Jasmine 7.900 1
Fattouche, Chloe 7.600 3
Fattouche, Nicole 7.700 2
Pratt, Erika 6.100 5
Salem, Alexandra 6.300 4
Mills, Sara 7.700 2

Ranked compares each via
=SUMPRODUCT(--(C5<$C$5:$C$148),1/COUNTIF($C$5:$C$148,$C$5:$C$148&""))+1


This data is on one sheet and already calculated the rank. Need to pull the
top three and put on seprate work sheet. Including ties.


Name Vault Rank
Blake, Jasmine 7.900 1
Fattouche, Nicole 7.700 2
Mills,Sara 7.700 2
Fattouche, Chloe 7.600 3

list are really biggerjust a clip and have to do from 4 events.



From: ozgrid.com on 20 Apr 2010 22:35
Use a PivotTable and display the top x
http://www.ozgrid.com/Excel/excel-pivot-tables.htm



--
Regards
Dave Hawley
www.ozgrid.com
"Rob" <Rob(a)discussions.microsoft.com> wrote in message
news:8ABE4E60-6531-4B3B-B0AA-345699796CA5(a)microsoft.com...
>a b c
> Name Vault Rank
> Blake, Jasmine 7.900 1
> Fattouche, Chloe 7.600 3
> Fattouche, Nicole 7.700 2
> Pratt, Erika 6.100 5
> Salem, Alexandra 6.300 4
> Mills, Sara 7.700 2
>
> Ranked compares each via
> =SUMPRODUCT(--(C5<$C$5:$C$148),1/COUNTIF($C$5:$C$148,$C$5:$C$148&""))+1
>
>
> This data is on one sheet and already calculated the rank. Need to pull
> the
> top three and put on seprate work sheet. Including ties.
>
>
> Name Vault Rank
> Blake, Jasmine 7.900 1
> Fattouche, Nicole 7.700 2
> Mills,Sara 7.700 2
> Fattouche, Chloe 7.600 3
>
> list are really biggerjust a clip and have to do from 4 events.
>
>
>

From: Rob on 21 Apr 2010 09:24
Thanks for your Help...Great!! Stuff
Was able to use these , However when I refresh a table once the data has
changed it puts all the data and the rank and not just the first 3?

Thanks Rob


"ozgrid.com" wrote:

> Use a PivotTable and display the top x
> http://www.ozgrid.com/Excel/excel-pivot-tables.htm
>
>
>
> --
> Regards
> Dave Hawley
> www.ozgrid.com
> "Rob" <Rob(a)discussions.microsoft.com> wrote in message
> news:8ABE4E60-6531-4B3B-B0AA-345699796CA5(a)microsoft.com...
> >a b c
> > Name Vault Rank
> > Blake, Jasmine 7.900 1
> > Fattouche, Chloe 7.600 3
> > Fattouche, Nicole 7.700 2
> > Pratt, Erika 6.100 5
> > Salem, Alexandra 6.300 4
> > Mills, Sara 7.700 2
> >
> > Ranked compares each via
> > =SUMPRODUCT(--(C5<$C$5:$C$148),1/COUNTIF($C$5:$C$148,$C$5:$C$148&""))+1
> >
> >
> > This data is on one sheet and already calculated the rank. Need to pull
> > the
> > top three and put on seprate work sheet. Including ties.
> >
> >
> > Name Vault Rank
> > Blake, Jasmine 7.900 1
> > Fattouche, Nicole 7.700 2
> > Mills,Sara 7.700 2
> > Fattouche, Chloe 7.600 3
> >
> > list are really biggerjust a clip and have to do from 4 events.
> >
> >
> >
>
 | 
Pages: 1
Prev: autoscale stock chart
Next: Search and Replace, or Add New Row