Hi All,

Here's a tricky formula that I can't even guess at. I need to return
false or something similar to identify any duplicate value in the
range C7:C799.

Usually the values are numbers, but there are many blanks and a few
XXXX values. The range C7:C799 is formatted as text.

There are 3 exceptions that are allowed (i.e. don't return false):

1 - XXXX values can be duplicated

2 - Blanks can be duplicated

3 - If Z7:Z799 in the same row as the C column numbers both (or all)
have the value 'Bank - Cheque' and date in A7:A799 is the same for
both (or all) duplicate numbers, that's okay too. Dates are formatted
as Date 17-Jan-10.

Thanks for any help and have a great day!

Michele