Help

O

only1joal

Hi,
I have a row of data that I need to find a minimum value and a maximum
value. That's done. Now, I have to delete both the minimum and maximum
values from the row. Can you tell me how to easily do this? I have a
larg :confused: e worksheet with many rows, so Edit+Find really won't
help.
 
M

Max

Assume data is in Sheet1, in row1 down

In Sheet2:

Put in A1:

=IF(OR(Sheet1!A1=MAX(Sheet1!1:1),Sheet1!A1=MIN(Sheet1!1:1)),"",Sheet1!A1)

Copy A1 across as many columns, then fill down as far as needed to cover the
source range in Sheet1

Sheet2 will return the desired results

To freeze the values , do an entire sheet copy > paste special > values > ok
to kill all the formulas in Sheet2
 
M

Max

Note that the formula will "remove" all instances of cells with values equal
to either the max or the min values in the row. There could be more than 1
cell for the max and min (ties).
 
Top