Numeration increasing by year

**pgft** · 05-03-2013, 03:54 AM

Good morning everyone.
First of all, I apologize for my imperfect English. I'm an Italian doctor and unfortunately I don't speak English well.
I am using Excel 2010. With the internal functions I'm able to derive the year from a date. I need to number the rows making reference to the year, so that the numbering recommences from 1 to each change of the year. Is there a way to do it?

Thanks for your attention.

**:) Sixthsense :)** · 05-03-2013, 04:00 AM

May be this...

For Row

Formula:

Please Login or Register  to view this content.

For Column

Formula:

Please Login or Register  to view this content.

**FDibbins** · 05-03-2013, 04:03 AM

Im not sure I understand what you are trying to do? maybe if you uploaded a sample, showing what you have and what you want?
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

**pgft** · 05-03-2013, 04:16 AM

First of all, thank you for your reply. I wil try to post the example.

In the column "Number" I would like to find automatically 1/2013, 2/2013, or 1/2012, 2/2012 if the year is 2013 or 2012.

**benishiryo** · 05-03-2013, 04:23 AM

hi pgft. you mean like this in A2?
=COUNTIF(B$2:B2,B2)&"/"&B2

what you could show in your file next time is to manually key in what you want to see in column A. that will help us understand much better
=)

if required, change all my commas to semi-colons as according to your region settings

**Pepe Le Mokko** · 05-03-2013, 04:25 AM

Perhaps

Please Login or Register  to view this content.

in A2 - Pull down as needed

**Fotis1991** · 05-03-2013, 04:28 AM

I understand the requst quite different..

=IF(OR(B2=2012;B2=2013);MONTH(C2)&" "&B2;"")

=IF(OR(B2=2012,B2=2013),MONTH(C2)&" "&B2,"")

**pgft** · 05-03-2013, 04:31 AM

Originally Posted by benishiryo

hi pgft. you mean like this in A2?
=COUNTIF(B$2:B2,B2)&"/"&B2

what you could show in your file next time is to manually key in what you want to see in column A. that will help us understand much better
=)

if required, change all my commas to semi-colons as according to your region settings

The definition under your nickname is really appropriate. Your formula is just what I needed.

Thank you very much.