Comparing a Range of Values

[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

 

[Guest]

try the correl() function.

 

[Dave Peterson]

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

 

[Guest]

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/duplicat.htm#CountingUnique

Regards
Peter

 

[Alan Beban]

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