Excel Random assign same value to same group

Question

Does anyone know the formula to solve this problem.

I want to randomly assign a value to RandomName from the values from Random list, if there are same values in the Group column, I want the random value to be same in RandomName col.

JvdV · Accepted Answer · 2021-11-03 10:59:05Z

1

You could try:

Formula in B2 in ms365;

=XLOOKUP(A2,A$1:A1,B$1:B1,INDEX(D$2:D$5,RANDBETWEEN(1,4)),0)

Or for older version of Excel;

=IFERROR(INDEX(B$1:B1,MATCH(A2,A$1:A1,0)),INDEX(D$2:D$5,RANDBETWEEN(1,4)))

edited Nov 3, 2021 at 10:59

answered Nov 3, 2021 at 10:27

JvdV

76.8k8 gold badges48 silver badges90 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Excel Random assign same value to same group

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related