Quote Originally Posted by TMS View Post
I have been playing with this, on and off, for a few days. To be fair, mostly for my own education

The attached workbook has grown, to some extent, and now has several sheets.

Stage 0 - Instructions. Self explanatory
Stage 1 - Where you input and split the raw data
Stage 2 - Don't touch. It is automatic
Stage 3 - Ditto
Stage 4 - Is where you can select a group and list its users
Stage 5 - A backup copy of the original test data

Hope this works for you. Please don't ask how (some of) the formulae work
I've gotten an issue with your solution. When I open up the file and let it calculate for a bit. I get an error in stage 3 and 4. On both pages it says #NAME? with a triangle that says the formula contains an unsupported function. Am I missing something in Excel or? I haven't put any new data in yet. (For the other person, yes your solution also works to satisfaction, thansk!)