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 Sheets - returning Nth result with multiple matching criteria
- Save Google sheet data onEdit in other sheet update duplicate data
- IF Status Formula Google Sheet Approval
- Google apps script: autoResizeColumn works incorrectly not works as expected
- How to find common words in two columns in Google Sheets
- Unable to open Google xlsx spreadsheet / Also Google Drive permission Blocked
- Turn a list of dates into Fridays Only
- Calculate difference of values in specific range of time in Excel
- Select from series of columns without blanks and then where Google Sheets query
- Allow user with edit privileges to run scripts on a spreadsheet owned by me
- Delete last row with value then find
- How can I save the URL(s), after making a copy (event) of a Google Sheets spreadsheet?
- How to make previous dates data from one tab appear in another tab
- Is it possible to generate a summary table of another table?
- Replace form response email address with name from master list
- How do I show data from a spreadsheet? it shows "undefined"
- Extract multiple sparsely packed responses to yes/no identifiers while preserving row information
- getLastRow() in Apps Script returns error: "This operation is not allowed on cells in typed columns."
- I can't convert 46809654.36 into a date and time value in Google Sheets
- Google Spreadsheet Last X Rows
- Select rows that contain a specific dropdown value
- How to negate 'isblank' function
- Is it possible get Image from Google Sheets to Google Docs Template when creating
- Byrow formula with reference to last row and last column
- Dynamically update variable in Spreadsheet popup UI element from google Apps Script
- Save timestamp time in a cell and then the timestamp edit time in another cell
- find a column where specific rows contain specific values
- How can I ensure my Google Apps Script merges cells in the final rows as expected?
- Inserting images into a Sheet as BlobSource using Google Apps Script
- Slack to Google Sheets integration "dispatch failed" error from slash command