Last seen: Apr 24, 2025
You're welcome.
Find a cell somewhere in your workbook, enter a 2 (todays weekday number) and give that cell a defined name "NxtMsgDay" (without the quotes). Then ...
Thanks Alan & Riny, Tried those solutions but text was not replaced. Finally got it to work with Table.ReplaceValue(#"Replaced Value3","N...
Good tip Hans, thanks. I was so pleased to get it working I did not think about 32 & 64 bit systems!
Try IF(B5<>"", "N/A", IF(B2<>"",WORKDAY(B2,15),""))
Thanks Catalin. I had done a load more research over the weekend and found that it is not necessary to even use a Chart Object, the image can be co...
Maybe =IF(AND(H5>=1, OR(A5="", A5="WIP")), 1, IF(AND(H5="", A5=""),0, ""))
I would do what you want with a Pivot Table. See attached file. I have changed some or you table headers a bit to allow the pivot table and slicers...
Neat use of MOD !
I do not fully understand your logic. Surely, if an Action is "Closed" then it cannot be "Open" or "Due", so should not be visible when filtering for ...
Go back to having Number and Street in different columns. Much better that way.
Riny is correct, the TEXTBEFORE should be wrapped in VALUE. Thanks for pointing that out, Riny.