I am fairly adept at excel formulas and have dabbeld in VBA but I am stumped. I have search this forum for days and can't find an answer to this:
I need to be able to fill a column with a list of unique random 2-digit letters (AA, AB, AC, AD, AE, etc.). And I need the amount of letters to be selected from (1-26 or more...BA, BB, etc.) dependent on other qualifiers in that row (similar to a Countifs or Lookup formula).
E.G.:
Col A=list of names, Col B=room # they are in, Col C=group within that room (A, B, or C)
Let's say 10 people are in Room #1 & Group A, then
Col D=list of 10 unique random letters (AA-AJ) for people that are in Room #1 & Group A
But there are 11 people in Room #1 & Group B, so Col D for those people=11 unique random letters (AA-AK)?!?
I realize another sheet & VBA are probably needed for something this specialized. Any help would be much appreciate.
I need to be able to fill a column with a list of unique random 2-digit letters (AA, AB, AC, AD, AE, etc.). And I need the amount of letters to be selected from (1-26 or more...BA, BB, etc.) dependent on other qualifiers in that row (similar to a Countifs or Lookup formula).
E.G.:
Col A=list of names, Col B=room # they are in, Col C=group within that room (A, B, or C)
Let's say 10 people are in Room #1 & Group A, then
Col D=list of 10 unique random letters (AA-AJ) for people that are in Room #1 & Group A
But there are 11 people in Room #1 & Group B, so Col D for those people=11 unique random letters (AA-AK)?!?
I realize another sheet & VBA are probably needed for something this specialized. Any help would be much appreciate.
