Thread: Return True/False to check duplicate items in a range with one for
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tetsuya Oguma Tetsuya Oguma is offline
external usenet poster
  
Posts: 19
Default Return True/False to check duplicate items in a range with one for
Hi all,

I have a range, say, A1:A10, and want to check if any duplicate entry exists
within this range.

What is the formula that returns True/False to do that?

Simple enough?

Tetsuya Oguma


Reply With QuoteReply With Quote