Hi,
I have an array in cell A1:A6 with integers. Some of the number have duplicates. How can I know the row number of the second largest number if the first largest number and the second largest number are the same?
for example, I have
A1: 2
A2: 5
A3: 5
A4: 2
A5: 1
if I use match and large,
= MATCH(LARGE(A1:A6,1),A1:A6,0) = 2
= MATCH(LARGE(A1:A6,2),A1:A6,0) = 2, this should return 3.
Thank you very much
I have an array in cell A1:A6 with integers. Some of the number have duplicates. How can I know the row number of the second largest number if the first largest number and the second largest number are the same?
for example, I have
A1: 2
A2: 5
A3: 5
A4: 2
A5: 1
if I use match and large,
= MATCH(LARGE(A1:A6,1),A1:A6,0) = 2
= MATCH(LARGE(A1:A6,2),A1:A6,0) = 2, this should return 3.
Thank you very much