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

What's your exact EXACT function look like?

************

Hope it helps!

Anne Troy

www.OfficeArticles.com

************

Hope it helps!

Anne Troy

www.OfficeArticles.com

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

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

1. run batch job from each row - how to insert run batch function per row?

2. Fix EXACT function so it always compares in the same row.

3. Use of Exact(or other) function for alternate rows?

4. HOWTO: FormView Insert Operation - Get Row ID of Inserted Row

5. I want to create a "Insert Row" button to insert a new row at the.

6. Multiple row insert only inserting one row?

7. Row Height Exact and Space Between Rows

8. SQL for comapre(exact match) returns more rows than the required rows

9. Macro to insert a row, copy info from another row and autosize the row

10. Inserting Blank rows after every row upto 2500 rows

11. How to insert rows after each row of data (800 rows)?

12. How to insert rows after each row of data (15,452 rows)?

13. If row exists update row, else insert row

14. Can't Insert New Row Between Row and Row While Existing DataTable Looping

15. Insert row with formatting from row below instead of row above?

4 post • Page:**1** of **1**