Location of the first greater than cell
 

I have a huge unsorted list of numbers (more than 100,000). I want to locate
the first instance of a number greater than the first number in this list.
any help will be greatly appreciated.

thank you,

Location of the first greater than cell
 

T Valko's answer in "locate first value greater than" solves the issue. His
answer is

"Another one:

=INDEX(B1:F1,MATCH(TRUE,INDEX(B2:F20,0),0))

Format as Date

--
Biff
Microsoft Excel MVP"


"crazyquasar" wrote:

I have a huge unsorted list of numbers (more than 100,000). I want to locate
the first instance of a number greater than the first number in this list.
any help will be greatly appreciated.

thank you,