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: 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.
 
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
Comparing two ranges of data and identify the common/like informat debra Excel Discussion (Misc queries) 2 April 1st 08 09:04 PM
Comparing 2 ranges? calberto22 Excel Discussion (Misc queries) 3 October 13th 07 03:19 AM
Comparing two Excel data ranges for chnages... NWO Excel Discussion (Misc queries) 2 May 2nd 07 08:01 PM
Comparing two data ranges for differences. jason.r.swinehart Excel Discussion (Misc queries) 0 January 12th 06 07:50 PM
How to : Comparing Two Ranges lockwood7 Excel Worksheet Functions 3 August 3rd 05 01:43 PM


All times are GMT +1. The time now is 06:41 AM.

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

About Us

"It's about Microsoft Excel"