| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
find date in Col A corresponding to min value in Col B
2 columns of data:
Column A has dates from 1/1/70 onward (in chronological order). Column B has a golf handicap as of the date in column A (in no order - varies up or down). I use the DMIN function to find the lowest handicap in Column B for each calendar year (based on range of dates in Column A). My question is, how do I find the date in Column A that corresponds to the lowest handicap in Column B for the given calendar year. (I want to exclude the dates from other years that had the same handicap.) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date issue between Windows and Macintosh version | Excel Discussion (Misc queries) | |||
| Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
| Need to find Min value based on date range entered | Excel Worksheet Functions | |||
| Need to find Min value based on date range entered | Excel Worksheet Functions | |||
Threaded Mode
