| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Max if statements
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "instereo911 via OfficeKB.com" <u27979@uwe wrote in message news:8c665037bb718@uwe... This is exactly what i was looking for. I have most of the data housed on another sheet so this perfect. Thanks to both for quick working responses. T. Valko wrote: Try it like this (array entered): =MAX(IF((A2:A65536=DATE(2008,10,2))*(B2:B65536=" ZZ")*(N2:N65536="Associate"),G2:G65536)) Better if you use cells to hold the criteria: A1 = 10/2/2008 B1 = ZZ C1 = Associate =MAX(IF((A2:A65536=A1)*(B2:B65536=B1)*(N2:N65536 =C1),G2:G65536)) Hi everyone, [quoted text clipped - 26 lines] Thanks everyone -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200810/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If Statements | Excel Discussion (Misc queries) | |||
| IF statements | New Users to Excel | |||
| IF Statements (Mutliple Statements) | Excel Worksheet Functions | |||
| If Statements | Excel Discussion (Misc queries) | |||
| How can I add IF statements | Excel Worksheet Functions | |||
Threaded Mode
