Comparing a Range of Values

J

jpx

I have named two ranges of cells and I want to compare one range t
another to see if they are identicle. I tried =exact(range1,range2
but get an error. Can this be done
 
D

Dave Peterson

Something like this:
=SUMPRODUCT(--(EXACT(rng1,rng2)=FALSE))
will count the number of different cells.
 
A

Alan Beban

jpx said:
I have named two ranges of cells and I want to compare one range to
another to see if they are identicle. I tried =exact(range1,range2)
but get an error. Can this be done?
Click to expand...
If the functions in the freely downloadable file at
http://home.pacbell.net/beban are available to your workbook,

=RowsEqual(range1,range2) will return True or False.

Alan Beban
 
Top