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))
- Trying to Email Multiple PDF Blobs in Sheets Javascript
- HTTP Google Sheets API v4 how to access without OAuth 2.0?
- List All Workdays between Start and End Dates Displaying Associated Name and Details in Other Columns
- How do I edit the response of a form submission in Google Forms/Sheets?
- If var isnumber, for script
- How can I count repeats in a a column but reset count on non-repeats, in an array formula
- How do I stop Google AppScripts (Sheets) from creating two protected range entries
- Transfer Data from one sheet to another
- googlesheet get last non blank row from specific rows
- Send Mail after Form Submit to Google Sheet
- IFS with multiple conditions check in Google Sheet
- Can I find the value of a cell B49 that changes value according to the value of the cell F2 ( in Google sheet)
- Google Apps Script creates sheets version of excel file
- What is the GoogleJsonResponseException error when trying to get Drive.comments.list()?
- Google Sheets: extract text between two characters
- Google Sheets REGEXEXTRACT to extract text value for URL query-parameter
- How to access the cell next to the selected cell in Google sheet using script?
- How to make the cancel Button work in Google App Script Browser Input Box
- Dowload public Google Spreadsheet
- Index Match using Tables in Google Sheets not giving correct results
- How to extract url from Google Sheet Cell with anchor text hyperlink
- How do you deal with multiple values in a single cell separated by comma?
- How to send content as comment to a specific cell in google sheets
- Get Google Sheet by ID?
- Excel getting names from biggest values with Regextract
- How to create a formula that will repeat a range by splitting one column and joining with the other column?
- Google Sheets Splitting Text to Rows and Duplicate Surrounding Rows Entries
- How to transpose & split multiple columns and repeat specific cells in a column
- getBorderStyle() to setBorderStyle()
- Copy specific fields to another sheet