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
Asked
Active
Viewed 74 times
2 Answers
0
use in C2:
=INDEX(IF(B2:B="";;COUNTIFS(B2:B; B2:B; ROW(B2:B); "<="&ROW(B2:B))
player0
- 124,011
- 12
- 67
- 124
-
i try this formula on googlesheet it say error .. anyway thanks – auto form Jan 07 '22 at 10:17
-
@autoform answer updated, try now – player0 Jan 07 '22 at 10:36
0
Your locale may require the use of semicolons instead of comma's. Using player0's formula, try
=INDEX(IF(B2:B="";;COUNTIFS(B2:B; B2:B; ROW(B2:B); "<="&ROW(B2:B))
and see if that works?
JPV
- 26,499
- 4
- 33
- 48
-
-
-
-
https://docs.google.com/spreadsheets/d/1zBnGttg_5HS9Dkosrw_U8fkJkfkW-c9rjxrsCjcubcE/edit?usp=sharing – auto form Jan 07 '22 at 11:01
-