View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SNIsRetired SNIsRetired is offline
external usenet poster
 
Posts: 1
Default formula not working

I'm using Excel 2003 and am trying to compare columns to find out which of
the items are missing. I'm using the formula:

-ISNA(MATCH(D2,$I$2:$I$6035,FALSE))

Instead of returning true or false entries (or a formula error), it leaves
the formula in the cell. I've tried everything I could to make it work and
it won't. I built a test spreadsheet to try it and it works, but with the
real data it doesn't. Can someone tell me what I'm doing wrong?

Thanks.