Forum

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

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