@Gregg_Stebben , so there is next question
I made the scenario below, maybe it provides you some insights. I left the steps in separate columns in the hope it helps to get you up to speed:
First I make a list of the columns:
Second I create a list of all the values in the table and sort it:
thisTable.[TS per screwtype].ListCombine().Sort()
Third, I filter and slice it in max 2 (for my list is rather limited).
thisRow.filter(thisRow.[All TS over all screws].Slice(1,2).Contains(thisRow.[TS per screwtype]))
The result is that the first concerns a screw of 6, the second value one of 10mm, but of course if you have 100+ values, you have a more balanced outcome.
I hope it helps you out, Cheers, christiaan