LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Check the interval of a cell withni a range of values dakke Excel Discussion (Misc queries) 1 February 15th 08 04:00 AM
Check if text exists within a cell range and return logical vaule - possible? [email protected] Excel Discussion (Misc queries) 2 July 20th 07 02:29 AM
Check if rounded cell values fall within a range vertigo Excel Discussion (Misc queries) 2 April 24th 07 11:34 AM
Check if a cell contains text compared to a range of cells GD1226, Captain Ahab, manface Excel Discussion (Misc queries) 5 April 13th 07 01:00 AM
Check to see if cell data is within a range mwrfsu Excel Worksheet Functions 4 August 22nd 05 10:40 PM


All times are GMT +1. The time now is 02:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"