Insert row to EXACT function

M

MicroDonna

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

Ron Coderre

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
 
M

MicroDonna

Yes, that does work! THANK YOU!

Ron Coderre said:
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
Click to expand...
 
Top