Last seen: Jun 25, 2026
@marvo Wait a minute!! your test file doesn't have any real scores, so the cut-off points become -6 and that is not very meaningful. The origin...
@marvo Fair enough. I didn't consider blanking out the rows for those who didn't play as I'm not a fan of mixing numbers and texts in one column. B...
I don't see a "By Position" tab. I looked at the tab called "Sheet2". That's where I found your XLOOKUP formula. Am I missing something?
@dmdavala Not sure why the calculations didn't update, but in the attached file (with ranges transformed to structured tables) seems to work. Though...
@marvo You need to empty enough cells below the formula so that the dynamic array can spilled down in one go.
@marvo Hi again! Couldn't resist having another look at your schedule as I thought the approach taken was overly complicated when I realised that...
@marvo By using GoalSeek you'll discover that the value in BI2 must be 0.018667917. You need to be accurate to the 9th decimal. Your sequence that...
@cawalawan Great!
@cawalawan Assuming you are connecting to Files, From Folder you could consider to filter the files in that folder to keep only the two most recent ...
@jjmadness As an alternative, I would personally favour flattening the data with Power Query and then create a summary with a simple Pivot Table wh...
@jjmadness OK, then you need the FILTER function inside the LET. That allows you to 'pick-up' multiple rows. Then TAKE and DROP to narrow down the ...
@norman Well, then you create a pivot table that has all three elements in the row area. Something like this: Added it to your file. Are y...
@norman Any reason why the file is an "xls", rather than "xlsx"? That's an ancient format. I've saved it as an xlsx and used Power Query to flat...
@norman There is no file with your post. Please try again.
@jjmadness Oh yes! Now I see the file above your first post. Didn't notice that. Sorry. Please find a solution in the attached file. It's a bit c...