google-sheetsexcel-formulagoogle-sheets-formulaarray-formulasautonumber
change the serial number of letters by year
how to change the serial number of letters by year, I got the formula in microsoft excel but how to use the formula in googlesheet with the array method formula to those who understand please guide me, just an illustration of the formula I use in excel I include in the following picture
Solution
use in C2:
=INDEX(IF(B2:B="";;COUNTIFS(B2:B; B2:B; ROW(B2:B); "<="&ROW(B2:B))
- Google Script to return calendar guest names (only) into one cell separated by comma
- onEdit to run only on one cell in one sheet
- How to extract url from Google Sheet Cell with anchor text hyperlink
- Function onEdit(e) works only for single cell edit
- Cancel Script is a cell is RED
- Can we hide column in sheet using google apps script?
- JavaScript function in Google spreadsheets to send QR codes to emails
- Google Sheet Concatenate + Filter
- Google Sheets QUERY is returning with a no column found errors
- Get eventID for Google Calendar Event
- How can I find the number of concordant/discordant pairs for a given cell in Google Sheets?
- COUNTIF Statements: Range Across All Sheets + Cell Reference as Criterion
- Writing a googlefinance wrapper
- Getting a macro to run using checkbox in google sheets
- Auto expanding formula in google sheets to the length of a dynamic range
- Issue in Auto close Modal Dialog - Google App-Script
- CSV extracted automatically into a sheet. Need help for filtering
- How can I sum top 5 values from column in Google Sheets
- Remove duplicates based on one column and keep latest entry in Google sheets (while ignoring blank entries in that column)
- Find the list of different values in 2 tables by id key
- VAT Checker Apps Script
- Script to lock a different tab sheet everyday
- Trigger python code from Google spreadsheets?
- Function to convert Google Sheet Table into one row
- Google Sheet Script 2 on edit function #NUM! error
- Google Sheet SUMIF returning an error! statement
- Same code behaving differently inside and outside function
- How to use VLOOKUP() + QUERY() + IMPORTRANGE() with multiple conditions?
- How to find value vertically and horizontally, using formula in Sheets?
- Return SUM of all cells that fit TWO CRITERIA related by POSITION