Formula became #NAME?
Hello,
I have an Excel that was working with date formula in hundred plus row on 2 different column, then I don't know what I did, but the results on those formula cells certainly showed "#NAME?" instead of the returned date that was working before. I could not figure out, I check and the formula are correct. Help Please. =(WORKDAY($E182,-5,Holiday!$A$2:$A$109)) |
Formula became #NAME?
You will probably need to re-install the Analysis Tool-pack add-in.
Hope this helps. Pete On Oct 1, 3:08*pm, Cam wrote: Hello, I have an Excel that was working with date formula in hundred plus row on 2 different column, then I don't know what I did, but the results on those formula cells certainly showed "#NAME?" instead of the returned date that was working before. I could not figure out, I check and the formula are correct. Help Please. =(WORKDAY($E182,-5,Holiday!$A$2:$A$109)) |
Formula became #NAME?
Try
Tools|Addins Select the analysis toolpak Mike "Cam" wrote: Hello, I have an Excel that was working with date formula in hundred plus row on 2 different column, then I don't know what I did, but the results on those formula cells certainly showed "#NAME?" instead of the returned date that was working before. I could not figure out, I check and the formula are correct. Help Please. =(WORKDAY($E182,-5,Holiday!$A$2:$A$109)) |
Formula became #NAME?
Thanks guy. I reinstall tool pack and worked ok.
"Pete_UK" wrote: You will probably need to re-install the Analysis Tool-pack add-in. Hope this helps. Pete On Oct 1, 3:08 pm, Cam wrote: Hello, I have an Excel that was working with date formula in hundred plus row on 2 different column, then I don't know what I did, but the results on those formula cells certainly showed "#NAME?" instead of the returned date that was working before. I could not figure out, I check and the formula are correct. Help Please. =(WORKDAY($E182,-5,Holiday!$A$2:$A$109)) |
Formula became #NAME?
You're welcome - thanks for feeding back.
Pete On Oct 1, 3:29*pm, Cam wrote: Thanks guy. I reinstall tool pack and worked ok. "Pete_UK" wrote: You will probably need to re-install the Analysis Tool-pack add-in. Hope this helps. Pete On Oct 1, 3:08 pm, Cam wrote: Hello, I have an Excel that was working with date formula in hundred plus row on 2 different column, then I don't know what I did, but the results on those formula cells certainly showed "#NAME?" instead of the returned date that was working before. I could not figure out, I check and the formula are correct. Help Please. =(WORKDAY($E182,-5,Holiday!$A$2:$A$109))- Hide quoted text - - Show quoted text - |
All times are GMT +1. The time now is 08:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com