Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using VLOOKUP to match similar text? | Excel Worksheet Functions | |||
index Match, or Vlookup Match.. | Excel Worksheet Functions | |||
vlookup, match, index: all some or one? | Excel Discussion (Misc queries) | |||
VLookup or Index Match or ??? | Excel Worksheet Functions | |||
VLookup or Index Match ? | Excel Worksheet Functions |