| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Forumla works in all cells but 1
Thank you in advance for your help. I have this array formula in cells L2:L52
=COUNT(1/FREQUENCY(IF(LEFT('[Spares Quotes List V22 26Apr2007.xls]All'!$A$2:$A$5003,4)=RIGHT($A8,4),IF('[Spares Quotes List V22 26Apr2007.xls]All'!$P$2:$P$5003<"",MATCH('[Spares Quotes List V22 26Apr2007.xls]All'!$P$2:$P$5003,'[Spares Quotes List V22 26Apr2007.xls]All'!$P$2:$P$5003,0))),ROW('[Spares Quotes List V22 26Apr2007.xls]All'!$P$2:$P$5003)-ROW('[Spares Quotes List V22 26Apr2007.xls]All'!$P$2)+1)) What could be a reason that in cell L8 the formula does not work? It returns zero. I have copied the formula from differrent cells and nothing works. I changed the value in one of the cells (from 8225 to 8999) on "Spares Quotes List V22 26Apr2007.xls" and then put the same value on the spreadsheet with the formula and it worked. When I use 8225 as the value to lookup in cell A8 it does not work. I then put the value back to 8225 and again it did not work. I'm stumped. Thank you for your help. Joe |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with the forumla, whether it works with IF condition or Vlook | Excel Worksheet Functions | |||
| Please help - formula works in some cells but evaluates to #value in others | Excel Worksheet Functions | |||
| VLOOKUP works in some cells but not others. | Excel Worksheet Functions | |||
| why cut and insert cells only works randomly? | Excel Discussion (Misc queries) | |||
| Formula works in some cells, doesn't in other | New Users to Excel | |||
Threaded Mode
