Here's this spreadsheet screenshot below <img src="https://i.stack.imgur.com/aWEYY.png" alt="enter image description here"> What is the formula to be used for cell H1 such that this can be automated for the rest of row 1?

<pre class="prettyprint"><code>=COLUMN(H1)-1 </code></pre> may be entered in H1 to return the desired result.

How to show the column index in Google Spreadsheet?

=COLUMN(H1)-1

may be entered in H1 to return the desired result.

answered Oct 11 '22 08:10

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!