Hi JeteMC and all.
I've had a play.
This looked really good and is so almost there. I integrated this well and all seemed to work UNTIL you get beyond a few names in the list at which point it stops working and I cant work out why.
I think its a really interested challenge which works well as a list comparison tool.
I've attached an example using fake names.
I'd love the two columns to work properly all the way down.
One change I made was to make it >=4 rather than just =4.
One further thought I had was whether the "4" above could actually be a cell reference = ">=J2". J2 could then be the number 4 or 3 and this would change how many names were displayed. BUT I couldn't make that work at all.
Any ideas? Its a fun little challenge and I really really appreciate your input.
Bookmarks