Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Working an If formula | Excel Worksheet Functions | |||
Formula Sometimes Working Sometimes Not | Excel Discussion (Misc queries) | |||
Formula not working | Excel Discussion (Misc queries) | |||
Formula is not working | Excel Discussion (Misc queries) | |||
Sum formula not working | Excel Worksheet Functions |