In any available empty column, put this formula in a cell on row 1 and fill
it down to row 500:
=IF(COUNTIF($A$1:$A$500,A1)=1,"","MULTIPLE ENTRIES")
Rather than nag you with a bunch of "TRUE" entries when the item on a row
only appears once, this leaves it blank, making the MULTIPLE ENTRIES noted
stand out better. If you want a real TRUE/FALSE output, then use
=COUNTIF($A$1:$A$10,A1)=1

Either case, when you have an entry that is repeated, each instance of it
will be marked as either "MULTIPLE ENTRIES" (first formula) or FALSE (2nd
formula).

Hope this helps.

"Neil Pearce" wrote:

Dear all,

The range A1:A500 contains references.

What formula would I require to return a true of false answer to the
question: are all cells different?

i.e. are all references independent.


Thanking-you in advance. Kind regards,

Neil