Forum

Hi Eric, I believe Power Query (PQ) is ideal for this kind of task. Connect to the "blue table" that comes from the system. Then PQ can group all r...

Hi Mel, I don't think this it's possible with just a formula. But you could use Power Query to allocate each ticket to a specific time slots during...

I see. The individual files are just too inconsistent, I'm afraid. I believe you should put some effort into developing a template that can be used fo...

Strange. Must have done something wrong. Trying again.

Try this: =INDIRECT("'"&G4&"'!BE11") Note the single quote marks that surround the sheet name that is in G4. It's important that the ent...

Hi, I added a "regular" From Folder query to your file. It connects to a Folder called TEST in my own set-up. Change the source to make it point to...

Difficult to diagnose. I note that your files have mostly Italian column names, but some have English for the same type of data. That would be difficu...

Hi Hevin, The file did not come across. Please try again and don't forget to press "Start upload" before submitting your reply. Riny

You need a User Defined Function for this in VBA. I found a piece of code in a collection of old files that works provided that you color the cell wit...

You can add a custom column with the following code: = if [Age of Encounters] > 5 then 1 else null That adds a column with ones and n...

If you connect to Files From a Folder, you will see an overview of all files in the folder with the following columns (screenshot below): Note...

Hi Ricardo Not sure I follow everything, but when you connect to Files from a Folder, PQ creates some Helper Queries including a "Transform File" f...

Well, when you look at my formula you can workout the correct syntax. =INDEX(Sheet2!$C$2:$C$360,MATCH(Sheet3!A3,Sheet2!$B$2:$B$360,0)) or in words ...

Perhaps like in the attached workbook?

As a variant, please see the attached file. Same end result as Jessica. Different method. I thought is was easier to prepare the bucket list in Excel ...