| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Q on LARGE function
I have the formula below which returns the largest sales day, but what
if the largest day covered two days, say Monday & Friday, how could I build that in to my formula i.e. Result could be more than one value? =IF(R197=0,"","Biggest Sales Day = "&INDEX(M188:M194,MATCH(LARGE (S188:S194,ROW(A1)),S188:S194,0))) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| large function result as reference for offset function | Excel Discussion (Misc queries) | |||
| XL2002 - OFFSET function and LARGE function | Excel Worksheet Functions | |||
| max or large function | Excel Discussion (Misc queries) | |||
| Large Function | Excel Worksheet Functions | |||
| Large function | Excel Worksheet Functions | |||
Threaded Mode
