Forum

@knutjdahl Check Mynda's blog article Use Excel Slicer Selection in Formulas. Br,Anders

@kcrett Where do you get stuck? I don't see any of those different options you mention. Below example is one way to sum per the criteria. There ar...

@solarheater It is not clear to me what it is you want and where you want it, also it is not stated what Excel version you work with. It differs bet...

Hello, Thanks for the file, it seems you just have an extra ending space at the end of Admin in B14. When removing that space I get a sum of 12. B...

Hello, Please share the .xlsx file instead as the .csv file is not of much help. Br,Anders

Hello, To me it seems that Power Automate is the tool for you, have you checked it out? Br,Anders

Hello, From your Data query, do a merge with the FilterList and use left anti join. Br,Anders

Hello, When I open an Excel file I have in OneDrive in Excel Online, via File - Share - Embed this workbook it works fine for me, the iframe code ha...

@shellp_55 Not a PQ solution, but perhaps usable regardless. Br,Anders

Hello, I can recommend the Excel Dashboards course, it gave me a good push into creating fun and somewhat interactive graphics + the time invested w...

@elsabchugmail-com Your issue is that the range of cells you want to sum contains text data type, i.e. the blank cells. Fill your blank cells in Da...

@elsabchugmail-com The data in a tabular format is to be able to easily work with the data, to present the data in a good way you of course need a ...

@riny, it seems the file didn't get uploaded.

Hello, I have no experience of this kind of export from PDF to Excel, but I know there are some tools for this. Have you for example tried exporting...

@elsabchugmail-com I would argue for a change of how you add your raw data, if you have the data in a tabular formatted table then it is easy to ge...