Insert row to EXACT function
 

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
 

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

"MicroDonna" wrote in message
...
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
 

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


"MicroDonna" wrote:

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
 

Yes, that does work! THANK YOU!

"Ron Coderre" wrote:

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


"MicroDonna" wrote:

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