View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MicroDonna
 
Posts: n/a
Default 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!!