Comparing a Range of Values
 

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?


--
jpx
------------------------------------------------------------------------
jpx's Profile: http://www.excelforum.com/member.php...fo&userid=1013
View this thread: http://www.excelforum.com/showthread...hreadid=487378

Comparing a Range of Values
 

try the correl() function.
--
Anne Murray


"jpx" wrote:


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?


--
jpx
------------------------------------------------------------------------
jpx's Profile: http://www.excelforum.com/member.php...fo&userid=1013
View this thread: http://www.excelforum.com/showthread...hreadid=487378

Comparing a Range of Values
 

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





jpx wrote:

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?

--
jpx
------------------------------------------------------------------------
jpx's Profile: http://www.excelforum.com/member.php...fo&userid=1013
View this thread: http://www.excelforum.com/showthread...hreadid=487378

--

Dave Peterson

Comparing a Range of Values
 

Chip Pearson has a range of functions to compare values, which one you want
will depend on the data, number, text

try: http://www.cpearson.com/excel/duplic...CountingUnique

Regards
Peter

"jpx" wrote:


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?


--
jpx
------------------------------------------------------------------------
jpx's Profile: http://www.excelforum.com/member.php...fo&userid=1013
View this thread: http://www.excelforum.com/showthread...hreadid=487378

Comparing a Range of Values
 

jpx wrote:
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?


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