Forum

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...

Hello, Pictures are better than nothing, but better yet is to have a sample file with data (dummy data is good enough). If you can upload such samp...

Hello, There are good articles in this site about date and time in Excel, how to work with them and so forth. Have a look here. Excel Date and Time...

Hi, I am not sure why you have two different table sources, when comparing the ticket ID's between Created and Closed tables it is the same creatio...

Hello, Sorry, no picture attached. Better if you can upload a sample file with some dummy data, so we can see layout and what kind of data is in th...

Hello, Have you tried using value filters in the PT so the table only shows the top ten? Br, Anders

Hello David, Check if this formula gives what you want. If you want the 8 as text, just wrap quotation marks around it. =IF(OR(ISNUMBER(B4),C4="...