Insert row to EXACT function

Insert row to EXACT function

Post by TWljcm9Eb2 » Mon, 16 Jan 2006 02:58:02


When comparing two columns of numbers with an EXACT function, when I come
across a "FALSE" where a row is off by 1 space, I insert a row into the
column to re-align the data, but the EXACT function does not remain in-tact
and I have to recopy the EXACT formula down the list again - this is annoying
when comparing 30,000 rows of data. Hints? Thank you in advance!!
 
 
 

Insert row to EXACT function

Post by Anne Tro » Mon, 16 Jan 2006 03:15:58

What's your exact EXACT function look like?
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

 
 
 

Insert row to EXACT function

Post by Um9uIENvZG » Mon, 16 Jan 2006 04:22:01

Try this:

Example, comparing A1 vs B1, A2 vs B2, etc.
C1: =EXACT(OFFSET(C1,0,-2),OFFSET(C1,0,-1))
Copy that formula down as far as you need.

With a formula like that, if you insert cells to realign the data, the
formulas will still reference the intended cells.


Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
 
 

Insert row to EXACT function

Post by TWljcm9Eb2 » Mon, 16 Jan 2006 19:21:02

Yes, that does work! THANK YOU!