Forum

Hello, Welcome to this forum. As always it is always better to also provide a sample file showing the data and the structure, makes it easier to...

Hello, The file did not get uploaded. From what I notice on your video it seems your data in your drop down lists (some or all) are wider than your...

Hello, Attached is a simple way to do it by using a helper column to get a unique identifier per row. Then you can use VLOOKUP (or any other looku...

Hello, Sorry, but no file uploaded. Br, Anders

Hello, Search the blog section in this site and you will find some good articles, links below to two of them. Br, Anders

Hello, With six different Pivot Tables it is not possible to double click the grand total cell in one table and get a new sheet containing the filt...

Hello, You can simply use the EOMONTH function for this. Br, Anders

Hello, Seems to me that you have multiple Pivot Tables and not one, but that is a guess. Can you upload a sample file? Br, Anders

Hi Kevin, A bit off topic perhaps, but seeing you want financial data, have you checked out what Excel Data Types or STOCKHISTORY function can do? ...

Hello, I am no Google Sheets user so I don’t know how ImportHTML function works, but when reading about it I think it is similar to get data from w...

Hello, Have you tried using the SUBTOTAL function? Br, Anders

Hello, With the data you show us all you can get is average consumption. Is this the format you get the files? With new files, do you have same dat...

Still better to ensure you have correct data. See attached.

Hello, My advice, and that is what I think Catalin also means, is to put your data in a tabular format, structured in columns. That data is easy to...

Hello Waqas, The problem here is that all values in cells C3 to C21, except for the value in cell C16, are text. The values you check against are n...