Prev: An odd question about formatting
Next: Dynamic Charts - working across multiple Worksheets
From: trip_to_tokyo on 18 Jan 2010 13:41
I have just put up my example for you at:-

http://www.pierrefondes.com/

Item number 39 towards the top of the page.

Please hit Yes if my comments have helped.

Thanks.



"Darryl" wrote:

> I have 100 (100 rows) with different numbers all in one column. I have
> ranked them in another column by largest to smallest in the past. The 100
> numbers change from time to time. I would like the rankings to automatically
> update. I wish not to sort. Is there a formula?
>
> Thanks, Darryl
From: Bernd P on 18 Jan 2010 14:36
Hello,

I suggest not to use Rank but Countif:
http://sulprobil.com/html/rank.html

Regards,
Bernd
From: Darryl on 18 Jan 2010 14:37

Yes, there will be "ties". Thanks.
"Gary''s Student" wrote:

> Will there be "ties" in the data? That is, duplicate values?
> --
> Gary''s Student - gsnu200909
>
>
> "Darryl" wrote:
>
> > I have 100 (100 rows) with different numbers all in one column. I have
> > ranked them in another column by largest to smallest in the past. The 100
> > numbers change from time to time. I would like the rankings to automatically
> > update. I wish not to sort. Is there a formula?
> >
> > Thanks, Darryl
First  |  Prev  | 
Pages: 1 2
Prev: An odd question about formatting
Next: Dynamic Charts - working across multiple Worksheets