Help

[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 e worksheet with many rows, so Edit+Find really won't help.

[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
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"only1joal" <[email protected]> wrote
in message news:[email protected]...
>
> 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 e worksheet with many rows, so Edit+Find really won't
> help.
>
>
> --
> only1joal
> ------------------------------------------------------------------------
> only1joal's Profile:
http://www.excelforum.com/member.php...o&userid=24589
> View this thread: http://www.excelforum.com/showthread...hreadid=381823
>

[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).
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----