Checking if minimums belong to the same record

Question

Hey there.

I have a specific problem that I managed to solve but my approach isn't scalable if more data with additional rounds (laps) was captured.

I was unable to come up with a tool that reaches a solution in a simple but efficient way.

I want to check if the minimum finish time in each round and in the complete contest belongs to the same person, keeping in mind that I want this workflow to function even when more rounds are added in future data collection.

test.xlsx

test.yxmd

RobertOdera · Answer

Hi, @Dennis229

Please see the below.

All your fields, e.g., winner ID, round ID, #wins, and #rounds, should autogenerate, tally, and give you a status update as you add rounds.

Please mark it as an acceptable solution if it works for you.

Cheers!

testForDennis229.yxzp

binu_acs · Answer

@Dennis229 I tried to make it dynamic, but can you test it with a few more rounds?

Test_011523.yxmd