Hi,

I have two columns - 'Key' (text, col A) and 'Forecast' (number, col B).

I have several rows for each 'Key' value, but the number of rows *varies*.

How do I (in one function in col C) calculate the maximum value for each
'Key'?

i.e If I have 16 rows all with the 'Key' value LC05XGE - what is the
maximum 'Forecast' value in the corresponding 16 'Forecast' values?

Any help greatly appreciated......Many thanks,

Jason