Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula not updating to new content.
This is the formula i have..
=IF(COUNTIF('[RP_FEB_2008.xls]FEB 08'!$C:$C,D10)=1,"X","") Which is a dublicate formula, but it looks in a different workbook. It worked fine when initially set up, but doesnt seem to update when its saved. How can i get this to update when a new duplicate is potentially added? Thanks in advance. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula not updating to new content.
Hummm, seems like it should update when data in the other workbook is
updated. Did you hit F9? Tools Options Calculation Automatic. Does that help? Regards, Ryan--- -- RyGuy " wrote: This is the formula i have.. =IF(COUNTIF('[RP_FEB_2008.xls]FEB 08'!$C:$C,D10)=1,"X","") Which is a dublicate formula, but it looks in a different workbook. It worked fine when initially set up, but doesnt seem to update when its saved. How can i get this to update when a new duplicate is potentially added? Thanks in advance. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula not updating to new content.
On Apr 1, 3:00*pm, ryguy7272
wrote: Hummm, seems like it should update when data in the other workbook is updated. *Did you hit F9? *Tools Options Calculation Automatic. *Does that help? Regards, Ryan--- -- RyGuy " wrote: This is the formula i have.. =IF(COUNTIF('[RP_FEB_2008.xls]FEB 08'!$C:$C,D10)=1,"X","") Which is a dublicate formula, but it looks in a different workbook. It worked fine when initially set up, but doesnt seem to update when its saved. How can i get this to update when a new duplicate is potentially added? Thanks in advance.- Hide quoted text - - Show quoted text - I found out my own problem, it was... =IF(COUNTIF('[RP_FEB_2008.xls]FEB 08'!$D$2:$D$2000,D10)=1,"X","") The formula wasnt supporting D:D.. so i set to the range from D2 to D2000, thanks for you looking at this though. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to transpose formulas from column content to row content. | Excel Worksheet Functions | |||
how to get formula content of a cell? | Excel Worksheet Functions | |||
Cell content / formula bar different | Excel Discussion (Misc queries) | |||
Formula reading formula instead of cell content | Excel Worksheet Functions | |||
how to evaluate the content of a string as if it was a formula | Excel Discussion (Misc queries) |