Hi, I am trying to get these functions working but having problems.

From a different thread we have:

If you have the unique items listed somewhere on the same sheet or in another sheet, then you can use Min(if()), Max(if()) and Mode(If()) array formulas...

e.g.

if you database is in Sheet1, A1:B100 where A1:A100 lists the items, B1:B100 lists the prices then:

=MIN(IF($A$1:$A$100=X1,$B$1:$B$100)) will give the miimum from column B of the item in column A that matches the entry in X1

after entering the formula, confirm it with CTRL+SHIFT+ENTER not just ENTER and copy down.

replace Min for Max and Mode to get those relevant results.

but I have a list of indentifiers is column A and a unique identifier in X1 and a numerical data item in column B. This returns a NUM!! error. I am using CTRL+SHIFT+ENTER.

Thanks