Try these *array* formulas:

=MAX(IF(A1:A7="ACC",B1:D7))

=MAX(IF(A1:A7="BCC",B1:D7))

--
Array formulas are entered using CSE, <Ctrl <Shift <Enter, instead of the
regular <Enter, which will *automatically* enclose the formula in curly
brackets, which *cannot* be done manually.

NOW, you said "insert".
As you insert an entire row, the formulas will revise *automatically* to
include the additional rows.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Paul A via OfficeKB.com" wrote in message
...
I think I have a complicated problem. Hope somebody can solve this for me

ACC 25 30 29
ACC 24 29 28
ACC 26 28 25
BCC 18 19 17
BCC 17 18 14
BCC 20 21 19

These are 6 rows. Now I would like to find the lowest value in ACC 3 rows
and lowest value in BCC 3 rows. Also a provise for incrementing the rows i
mean if one more ACC rows is insert it has to take that also into account.
Further a chart from low value to high value. I have been trying but with
no
luck. If somebody could help me, I would appreciate it. Thanks