Last seen: Mar 17, 2025
Hi Marta, Any reason for a VBA solution only? It's much easier to do that in Power Query, see attached solution that returns the RowsOnlyInSource ma...
Hi Sharad, You should use the Workbook_Change event, with a condition to monitor columns A,B,C, but make sure you disable events, otherwise clearing ...
You can make a measure with the same formula, but Funding Method field should be added to pivot table to provide context for calculation. Cheers, Ca...
Hi Mourad, You have to analyze the web page and get the html element that stores that info, here is an article that explains the process:
NOT returns the opposite of a logical condition. Simply put, if your condition evaluates to TRUE, NOT TRUE will convert true to false. Assuming that...
you have an array formula somewhere where the results are spilled over multiple cells, one of the pivots are trying to expand over those cells. Make s...
Hi Cristina, This looks more like a calculated column, rather than a measure: =IF([Funding Method]="PA", [Attendance Hours] / [Scheduled Hours], ([F...
I guess you did not discovered yet the Refresh button? After you paste your data in Transactions sheet, go to Data tab in ribbon and press the Refres...
In this formula: =VLOOKUP([@[Sub-category]],TblDV,2) , 2 represents the second column - Category Replace with 3 to get the third column - Category T...
You're welcome, glad to hear you managed to solve it! Cu placere 🙂 Catalin
Hi Amberly, The IFrame is a standard html object, all the options are described here: You can also inspect the object using browser developer tool...
Hi Sammie, Manually type the table name: it should be TBLDV, my guess is that instead of lower case "L" you have upper case "i"
Hi Dana, "I am uploading screenshots of the query and the steps. When I manually filter the sheet to "Nov22" it works. But when I use the parameter C...
Hi Sammie, In Data Validation sheet, the tblDV table is the source for Transaction categories, there should be no dropdown here. Remove the dropdowns...
Check again the article please, there may be multiple scenarios, all described here: