Last seen: May 22, 2025
I'd make your data source into a table, called say SourceData, then use a formula like: =IF(SUMPRODUCT(SUMIFS(SourceData[Grad_Proj],SourceData...
For Requirement and Graduates, you only want the numeric cells so you can use COUNT: =OFFSET(Visuals!$D$6,0,0,COUNT(Visuals!$D$6:$D$31),1) =OFFS...
You could use a small tweak: =COUNT(SEARCH($J$1,$H$2:$H$7)*SEARCH(M5,$H$2:$H$7)/($I$2:$I$7=1)) Note: may need array entering depending on your v...
FYI, cross-posted here:
Here's one way. It creates a query for just the null date rows, groups by the Custom field and then converts the Explanation data into a comma separat...
A Word document isn't particularly helpful for testing purposes - any chance of an Excel workbook?
I amended the code you had in the Worksheet_Deactivate event to simply refresh the pivot.
The attachment didn't make it. Also, which version of Excel are you using?
Make it a connection only query, then use that as the source (choose external data) for the pivot table. Something like the attached (you have...
Do you actually need the table on a worksheet?
You're welcome! 🙂
I'm not seeing what you are seeing. In what way are the values incorrect?
Do you want it to do every table on the sheet? If so, something like: sub AddCommentsToOperations() application.screenupdating = false d...
Which version of Excel do you have?
Your workbook isn't particularly helpful (to me anyway) as none of the source data is available to have a look at. Could you at least provide an anony...