Recording Daily numerical entries by largest

**pajo60** · 09-10-2009, 09:48 AM

Newbie here. Hello!

Hope the thread title is ok.
I attached an example excel sheet to make this a lot easier to explain.

I will be entering figures daily in a new column (yesterdays are in column G).

The order that these daily figures appear is important (by highest number).
(Yesterday (Column G), the entry was 8,5,7,6,1,3,4,2. Here the highest figure was 1st. The highest-1 was 3rd, highest-2 was 4th. )

I have manually entered the data in the table show for the example. (The 4 in the top right corner of the table indicates that the highest entry was 1st 4 times).
I would like the table to update itself automatically. Any help please?
Thanks!!

**zbor** · 09-10-2009, 10:01 AM

Can you add helping columns:

excelexample(1).xls

Just extend formula in Q column to the right as much as you need and in B29 extend formula to catch up all that values (here are up to BW column)