index/match or vlookup or similar
 

I am looking for a formula that will tell me min and max in column B
and list the associated data from column A
A B
1 Year Amount
2 1929 2,000
3 1930 2,256
4 1931 2,357
5 1932 2,353
6 1933 2,423
7 1934 2,454
8 1935 2,000
9 1936 2,088
10 1937 2,454

I can do a min and max function for the Highs and Lows (2000 and 2454)
I can do a vlookup or index/match function to give me the first year
listed for each amount (1929 & 1934)

What I need is a function to continue to search for duplicated
amounts, and return the associated year. (in this case 1935 & 1937)

I want to use each entire column for my search as they will be as they
will be added to yearly.

Any Suggestions, or perhaps a macro that will get the job done.

Thanks
Kris

index/match or vlookup or similar
 

I woud recommned Data Filter AutoFilter.........

Vaya con Dios,
Chuck, CABGx3



" wrote:

I am looking for a formula that will tell me min and max in column B
and list the associated data from column A
A B
1 Year Amount
2 1929 2,000
3 1930 2,256
4 1931 2,357
5 1932 2,353
6 1933 2,423
7 1934 2,454
8 1935 2,000
9 1936 2,088
10 1937 2,454

I can do a min and max function for the Highs and Lows (2000 and 2454)
I can do a vlookup or index/match function to give me the first year
listed for each amount (1929 & 1934)

What I need is a function to continue to search for duplicated
amounts, and return the associated year. (in this case 1935 & 1937)

I want to use each entire column for my search as they will be as they
will be added to yearly.

Any Suggestions, or perhaps a macro that will get the job done.

Thanks
Kris