| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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!! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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!! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to change the insert function key to always be an = sign | Excel Discussion (Misc queries) | |||
| How to insert Open File action in the IF Function? | Excel Discussion (Misc queries) | |||
| Need a ISWorkday Function -- Any Ideas | Excel Worksheet Functions | |||
| insert row within function | Excel Worksheet Functions | |||
| How do I insert a row when using an if function | Excel Worksheet Functions | |||
Hybrid Mode
