Automatically Add Numbers

Occasional Visitor

I use Excel on a daily basis to count the number of court files per year. I have been adding them in manually and was wondering if there's a way to automatically have them added in columns. I have attached a copy of what I do incase my description doesn't make sense. example.JPG

 

2 Replies

@ADuncan2210 

="2021-"&ROW()

="2021-"&ROW(C2900)

 

Is this what you are looking for? The results of the formulas are shown in the attached file.

 

@ADuncan2210 

As variant you may use formula like here

image.png

which is

=LEFT(D2,5)&(RIGHT( D2, LEN(D2)-5)+1)

and drag it down.