Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
min & max values
I am trying to select the maximum and minimum values in an Excel 2000
spreadsheet. The guiding criteria is in column A and the selection values are in column B. For example (ColumnA - ColumnB) ID1220 - 5 ID1220 - 10 ID1624 - 8 ID1220 - 5 ID1624 - 16 ID1220 - 11 The output I would like is the minimum & maximum values for the ID1220 (which in this case are & 11) and the minimum & maximum values for the ID1624 (8 & 16). Values in columns A & B will not be in any type of sorted arrangement. I suspect I have to do an array, but am not quite sure how to go about it. Robert |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using two values to report multiple values | Excel Discussion (Misc queries) | |||
Return across Row Numeric Values Matching EXACT Month & Year for Criteria | Excel Worksheet Functions | |||
List of values | Excel Discussion (Misc queries) | |||
Referencing a specific number to more general values in a table. | Excel Worksheet Functions | |||
Keeping a cell value constant trhoughout a list of values | Excel Worksheet Functions |