Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

How to show the column index in Google Spreadsheet?

Tags:

google-sheets

formula

Here's this spreadsheet screenshot below

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?

like image 322
Abel Callejo Avatar asked Feb 20 '17 01:02

Abel Callejo

1 Answers

=COLUMN(H1)-1

may be entered in H1 to return the desired result.

like image 57
AdamL Avatar answered Oct 11 '22 08:10

AdamL
Sign in to Comment

Related questions

Is there a way to retrieve Google Map Longitude & Latitude from Addresses in Spreadsheet?
Execution failed: You do not have permission to call getProjectTriggers
Why are there two different URL formats for Google spreadsheet documents?
Google spreadsheet cell reference from value of another cell
Reading Data from Firebase...with Google Apps Script
How to Post Google Forms Data via jQuery and Ajax to Spreadsheets
Google Scripts For Loop
Sum function returns zero [closed]
Clear cell google sheet script
How to get font color of cell in Google Sheets?
Cannot Read Bigquery table sourced from Google Sheet (Oath / Scope Error)
Is there a Google Sheets or MS Excel formula to convert a column with JSON array to multiple rows
How to create HTML Data entry form using Google spreadsheet as backend
Why can't I call a server function from the sidebar in Google AppScript for Sheets? [duplicate]
Mark Duplicate Entries in Google Spreadsheet
Form and file upload with htmlService and app script not working
Custom Functions and Recalculation
Google App Script - allowing access for anonymous users
Closing window after running a Google Script web app?
How to filter one list of items from another list of items?

Donate For Us

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