I have odd number of columns and want to select value from the middle one, how?
Example:
1 2 3 4 5 6 7
A B C D E F G
How to select the cell "D"?
Super User is a question and answer site for computer enthusiasts and power users. It only takes a minute to sign up.
Sign up to join this communityI have odd number of columns and want to select value from the middle one, how?
Example:
1 2 3 4 5 6 7
A B C D E F G
How to select the cell "D"?
The following formula would return the value of the middle column of a range of cells. This formula assumes your data is in row 1 of the sheet (specified after "ADDRESS" in the formula). The range of cells to be assessed is shown after "COLUMNS" in the formula.
=INDIRECT(ADDRESS(1,ROUNDUP((COLUMNS(A1:G1)/2),0)))