I need find determined cell position based in yout position of range cells total.

Example:

In this table, i have 15 cells,"x" is 8th in these 15 cells and your position is B3. I need find B3 knowing only "x" is 8th cell in this range using a formula.

How to make a formula to find cell this way?

CodePudding user response：

Assuming a 3 column wide area:

=ADDRESS(INT((F1-1)/3) 1,MOD(F1-1,3) 1)

Where F1 has the 8 and the 3s represent the number of columns in the area.