Forum

"Your attachment is unreadable for me. It has appeared as all WingDings" Right-click on the file and select 'Save link as'. Now you can save the f...

See attached. It didn't work because the yyyy-mmm entries in columns D and E are texts, whereas the dates in row 2 are real (numerical dates). Went...

@Velouria Yes indeed. Sometimes I'm just overthinking 🙂

Hi Tom, I'm convinced that it's possible with old-style Excel, but I believe it's going to require quite a bit of complicated formula writing, cop...

Needed to think this through a bit and hope you have Excel 365 or 2021. Was wondering if you wanted to average the 10 smallest numbers including any d...

Oooops! Velouria was a bit quicker than me, but I'll give you my answer anyway. First you need to get rid of duplicates in the Allocations table, w...

Please have a look at the formula I entered in A15 (attached file). I added another IF in the beginning where it is checked if both cells are >0. I...

The workbook wasn't attached. Please try again and don't forget to press 'Start upload' before you submit your reply.

Just in case you are still interested in a solution that uses XLOOKUP, perhaps the example in the attached file is useful. You can enter the second...

Not sure if Alan's Power Query solution gives you the results asked for. Please find a different (formula based) solution in the attached file.

Glad I could help!

See attached. Would that work for you?

Thanks for the file but I can't refresh the queries. Table1 seem not to be what PQ wants and Table2 does not exist. Perhaps you can recreate a file...

OK but can you share a file? I find it hard to visualize what exactly you are doing.

Cahnge the formula to: =FILTER($C$2:$C$181,($A$2:$A$181=B184)*BYROW(SEARCH({"Assistant","Supervisor","Floor"},$B$2:$B$181),LAMBDA(a,COUNT(a)))) an...