'Team generator' category
How to build a Team Generator – different number of people per team
JD asks in this post:Â Dynamic team generator Hi, what if we have different number of people per team? So in […]
JD asks in this post:Â Dynamic team generator Hi, what if we have different number of people per team? So in […]
Dynamic team generator
Mark G asks: 1 - I see you could change the formula to have the experssion COUNTIF($C$1:C1, $E$2:$E$5)<5 changed so […]
Mark G asks: 1 - I see you could change the formula to have the experssion COUNTIF($C$1:C1, $E$2:$E$5)<5 changed so […]
Team Generator
This blog article describes how to create teams randomly. There are twenty names in column B and four teams in […]
This blog article describes how to create teams randomly. There are twenty names in column B and four teams in […]
Excel formula categories
AverageChooseCombine MergeCompareConcatenateConditional FormattingCountCount valuesDatesDuplicatesExtractFilterFilter recordsFiltered valuesFilterxmlHyperlinkIf cellIndex MatchLogicLookupsMatchMaxMinNumbers in sumOR logicOverlappingPartial matchRecordsSequenceSmallSort bySort valuesSumSumifsSumproductString manipulationTimeUnique distinct recordsUnique distinct valuesUnique recordsUnique valuesVlookupVlookup return values