| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
(Part 2) - Retrieve Numeric Label for Max Value by Specific Day & Month
Hi Domenic,
That's Brilliant! Thank you very much. Cheers, Sam How do I return the Maximum value from the same set of data rather than the Numeric Label? Domenic wrote: Try... =MAX(INDEX(C5:AO436,MATCH(1,IF(DAY(A5:A436)=DAY(A 2),IF(MONTH(B5:B436)=MON TH(B2),1)),0),0)) ...confirmed with CONTROL+SHIFT+ENTER. Hope this helps! -- Message posted via http://www.officekb.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Retrieve Numeric Label for Max Value by Specific Day & Month | Excel Worksheet Functions | |||
| Retrieve Numeric Label for Max Value by Specific Month | Excel Worksheet Functions | |||
| Find and Return Numeric Label based on (Numeric Value) Criterion | Excel Worksheet Functions | |||
| AVERAGE Row of Numbers and Return Corresponding Numeric Label | Excel Worksheet Functions | |||
| How to convert a label to numeric | Excel Discussion (Misc queries) | |||
Threaded Mode
