Il 31/10/2012 07:03, Mfreit ha scritto:
Hi all,

I'm trying to find a minimum value in one column (A) for all records in
which columns B or C are equal to a cell reference in a separate
worksheet. I've tried something like: =MIN(IF(OR(COLUMN B option, Column
C option),Column A range)). But it's only giving me zeros which I know
are not correct.

Any ideas?

Thanks in advance.

M





You must only confirm that formula pressing CONTROL+SHIFT+ENTER.

E.