Find the Square section where Value A at (Gary is in 8 in this case), and get the name " Ocho" from list underneath
then find where is Value B, Put Ocho at highlight place in value B section
Then list the rest clockwise
Sample Image:
I tried to put value clockwise by using
=INDEX(D22:D29,,XMATCH(D22:D29,MOD(SEQUENCE(8,,E29-1),8)+1))
0 comments:
Post a Comment
Thanks