Max Function

Hi all,


My question is I have a data which contains Item ID (Column A) and the Cost (Column B); PFA Attachement; I just need to find out what is Minimum cost and the maximum cost for the Individual ID's.

Any help would be appreciated.

Nasha.,For forum.xlsFor forum.xls

You can use this array* formula in G3:

=MIN(IF($B$3:$B$233=$F3,$C$3:$C$233))

and this array* formula in H3:

=MAX(IF($B$3:$B$233=$F3,$C$3:$C$233))

then if you have other unique IDs in F4 and down, you can just copy the formulae down as required.

*NOTE: an array formula needs to be committed using the key combination of Ctrl-Shift-Enter (CSE) instead of the usual <Enter>.

Hope this helps.

Pete

Thank you both,, My Problem Solved.

Glad to hear that.

Note that it is not a good idea to use full-column references for array formulae, as every element in the array will be evaluated.

Pete

I offer a version without an array formula.