CODEWITHSUNDEEP
google-sheetsexcel-formulagoogle-sheets-formulaarray-formulasautonumber
auto form
auto form

Reputation: 23

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

excel formula into arrayformula on googlesheet

Upvotes: 1

Views: 118

Answers (2)

player0
player0

Reputation: 1

use in C2:

=INDEX(IF(B2:B="";;COUNTIFS(B2:B; B2:B; ROW(B2:B); "<="&ROW(B2:B))

enter image description here

Upvotes: 0

JPV
JPV

Reputation: 27302

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?

Upvotes: 0

Related Questions