Forum

Hi Pete, With the data structure you have the formula needs to be adjusted per month, examples below for employee Sam. For January, cell D18 =SU...

Hello, Catalin has provided an answer to your post, do check if that works as you want. Br, Anders

Hi Pete, Sorry, no file attached. But I assume the problem is solved as by Mynda’s suggestion. Br, Anders

Hello Pete, Can you upload a sample file showing us the data structure and what you want to achieve? Br, Anders

Hello, Is this list useful for you? It uses hexadecimal id, not integers as you give examples of. Br, Anders

Hello, The problem you have is that your data source for the Pivot Tables only goes to row 285 in the Results worksheet. PT data source = Results!$...

Hello, Can you upload a sample file? Much easier to give good response. Do you need to compare between the pivot tables? Can’t you do the compar...

Hello, Do the tables have the same structure or are they each individual? If they all have same structure you can use Power Query, where you loa...

Hi, Yes, with this Power Query course offered in this site you will get very good practice files, along with a very good teacher that in the course...

Hello Ken, Check out this blog article on how to import files from a folder with Power Query, I think that is the approach you are looking for. ...

Hello, You need to right click and export to Excel. In SAP the administrators can define that certain data is not allowed to be copied, most likely...

Hello, As Andrew mentions, providing a sample file makes it easier for everyone. Based on your topic label, this blog post gives a good description...

Hello Carlos, There is no file attached. Try to upload it again. Br, Anders

Hello, As mentioned in an earlier post. ”Be sure to select a cell in the column labels area before right clicking > Field Settings (not 'Value F...

Hello, So you intend not to have column F as shown in your sample file Sheet2? Do you intend to have Sheet2 at all? In order to keep the formula...