79270510

Date: 2024-12-11 05:06:20
Score: 1.5
Natty:
Report link

I'm missing something here. For a 3x3 array, both formulas for column B work. But if I change it to a 4x6 array, the values found for column B start over after the first four values. The formula I'm using is:

=INDEX($B$1:$G$1,MOD((ROW()-5-QUOTIENT(ROW()-1,COUNTA($B$1:$G$1))*COUNTA($B$1:$G$1)),ROWS($A$2:$A$5))+1)

Formula example for both 3x3 and 4x6 arrays

Reasons:
  • Probably link only (1):
  • Has code block (-0.5):
  • Low reputation (1):
Posted by: Brian By