| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
find the second value if it is a tie
If I understand you correctly you want to return the latest date if you have
a tie, if so then try this array formula: assuming B1:B10 is your degrees and A1:A10 your dates =MAX(IF(B1:B10=23,A1:A10)) enter using Ctrl+Shift+Enter HTH Jean-Guy "cloud" wrote: suppose 23 degrees fall on 1st of jan and 31st of jan. how do i use match,index so tat the answer will show 31st jan instead of 23rd jan and i am not allowed to use sorting. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find and Replace | Excel Worksheet Functions | |||
| Code needed to find records from bottom up | Excel Discussion (Misc queries) | |||
| find a cells from a range of cell | Excel Worksheet Functions | |||
| How do I find a column entry closest to a particular value | Excel Worksheet Functions | |||
| Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) | |||
Threaded Mode
