Forum

Could you upload a file as you download it from the web site? Difficult to help otherwise.

Perhaps not the most elegant solution but you could simply use COUNTIF as demonstrated in the attached example.

It's difficult to visualise your data and suggest a solution with a file to play with. Can you please upload a file (without confidential information)...

Haha. Glad I could help!

Difficult to explain, but perhaps it helps if you just think about Data (tData) and Annotated Data (tData_2). Forget about the other tables in your fi...

You may click on your own profile and then in the bottom right-had corner you find your stats including two buttons that take you to your posts.

There is no attachment. Please try again and don't forget to press "Start upload" before you submit your reply.

I added a pivot table to your file (the green tab at the far end), believing that it does what you ask for. If not, please come back and clarify your ...

Thanks for the file. I created a self referencing query, but before I could do that I simulated a 'first data set' based on the first four columns of ...

I believe you need to use a self-refencing query. The very first time, you connect to the data, do the basic transformations (if needed) and load the ...

The file didn't attach. Please try again and this time, don't forget to press the 'Start upload' button (and wait until it's finished) before you subm...

Can't help you if you don't show me what exactly you are doing.

See if you can adapt the attached file.

You could use Power Query to connect to a location (Folder) on your system with the following script: let Source = Folder.Files("C:xxxxxxx"), #...

Thanks for the files but I don't really follow. The graph seems to be linked to data from a pivot table on your local system, so I can't see how you d...