View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Paul Paul is offline
external usenet poster
 
Posts: 661
Default Comparing Data Across Cell Ranges

I am trying to compare data across multiple cell ranges to see if there are
any variances in the data. And the data in the cells can have various
formats, text, numbers, dates, etc. For example:

Cell(s) - Native Information
A1 - ABC
B1 - 123
C1 - 10/14/08

Cell(s) - Comparison Data
G1 - CDF
H1 - 123
I1 - 10/24/08

I am not really interested in knowing the exact cell that changed, just if
there was a change in comparison of the like ranges.