Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Retrieve Numeric Label for Max Value by Specific Month
Hi All,
I would like a flexible Formula to find the Maximum value for a specific Month (criteria will vary) and retrieve its corresponding Numeric Label from Column "A". Row1 Col "C" - "N" = Full Date formatted with Custom Month Format "mmm": Jan - Dec. Row2:Row31 Col "C" - "N" = Numeric Values 0 - 200 Row2:Row31 Col "A" Numeric Labels = 1 - 30 Sample Data Layout: Row1 Labels Misc Jan Feb Mar Apr May Jun Row2 1 0 101 102 123 143 136 128 Row3 2 0 120 130 103 87 143 130 Row4 3 0 120 90 60 200 102 88 Row5 4 0 170 88 79 67 141 110 NB. The zero (0) values should be under the column heading Misc. Expected Results: Looking at January, the maximum value is 170 and I would expect Numeric Label 4 to be returned as the correct answer. Looking at February, the maximum value is 130 and I would expect Numeric Label 2 to be returned as the correct answer. Thanks Sam -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200702/1 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find and Return Numeric Label based on (Numeric Value) Criterion | Excel Worksheet Functions | |||
Search Multiple columns for criterion asterisk (*) and Return Numeric Label | Excel Worksheet Functions | |||
Return SEARCHED Column Number of Numeric Label and Value | 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) |