Insert row to EXACT function

[Guest]

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!!

 

[Anne Troy]

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

 

[Guest]

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

 

[Guest]

Yes, that does work! THANK YOU!

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