View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Neil Pearce Neil Pearce is offline
external usenet poster
 
Posts: 109
Default Check no cell is the same within a range

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