Hi all
First post here
Is there a way to exclude more than one date in a list using an array
01/01/1985 01/01/1985
29/05/2002 01/01/2002
01/01/2002
16/09/2002
05/04/2010
01/05/2009
01/05/2012
I can do it using one number =MIN(IF(A1:A7<>B1,A1:A7))
This returns 01/01/2002 (01/01/1985 is excluded)
But when I tried to do it using "And" to find the exclude both 01/01/1985 (B1) and 01/01/2002 (B2) it did not work
=MIN(IF(A1:A7<>AND(B1,B2),A1:A7))
it just returns 01/01/1985
Would be grateful for any sugesstions
Many thanks
asdf@12
Bookmarks