| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using LARGE function with criteria
Perfect. Much appreciated
"yshridhar" wrote: d1=LARGE(IF((A1:A10=c1),B1:B10),n) text - column A numrics - column b c1 = text criteria n - nt figure it is an array formula. enter with ctrl+shift+enter best wishes sreedhar "TT" wrote: I have 2 columns of date. One with text and another with related numeric figures. I am trying to craft a formula which will extract the largest nth figures for a given text criteria. Any help would be appreciated. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help! How do I search for multiple criteria in a large spreadsheet | Excel Discussion (Misc queries) | |||
| Criteria governing "LARGE" function | Excel Discussion (Misc queries) | |||
| Large Based on Criteria | Excel Worksheet Functions | |||
| Large function with multiple criteria | Excel Discussion (Misc queries) | |||
| dsum returns 0 if criteria range too large | Excel Worksheet Functions | |||
Hybrid Mode
