count number between specific cells given certain conditions

[blgree8]

so i have a master list of data:

Number Date
4.1 6/2
4 6/3
5 6/4
4.5 6/5
4.2 6/6
4.8 6/7

and then i use formulas to get the largest two values and specific dates:

5 6/4
4.8 6/7

i need to know the number of cells between 5 and 4.8 after i've found that they are the two highest. I cannot use the dates as a counting method. I need to somehow use a count formula to tell me that there are 4 cells (including 5) from 5 to 4.8.

days between 2 highest numbers
???

any help would be greatly appreciated!

[protonLeah]

...and then i use formulas to get the largest two values...
Which are?...

[blgree8]

=large(A1:A6, 1)
=large(A1:A6, 2)

which gives me 5 and 4.8

so there are 4 cells between those numbers on my original list, i need a formula to tell me that

[ConneXionLost]

How about:

Please Login or Register  to view this content.

[blgree8]

Yeah!!!

thanks for the help!!