Posted to microsoft.public.excel.programming

external usenet poster

Posts: 570

How to compare two differnet cell ranges to see if they are the sa

I have two data charts on the same worksheet with each chart containing 14
columns and 79 rows. Is there a way to compare the two cell by cell and then
output a "same" or "different" if and cell in the a row is different between
the two data charts? Does this have to be done cell by cell or can it be done
by ranges?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
compare two or more ranges	tywlam	Excel Worksheet Functions	3	April 23rd 09 10:18 AM
Compare ranges	tywlam	Excel Worksheet Functions	0	April 23rd 09 04:07 AM
Using IF to compare ranges	[email protected]	Excel Worksheet Functions	5	April 8th 09 06:47 PM
Compare Ranges	ranswrt	Excel Programming	2	September 10th 08 11:38 PM
Compare ranges	Johnnyb	Excel Programming	0	August 11th 04 02:30 PM

All times are GMT +1. The time now is 03:51 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us