R
Robert Dieckmann
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
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