Different numbers for the same name for different rows

[avinashraste]

Dear All,

I have a set of rows, grouped in 3 rows with the same name but different dates. I want to put the first name which is with current month's date with number "1" for eg. if the first row is "Nifty" then I want it "Nifty 1", if the second row which is also "Nifty" but with next month's date, I want to put it as "Nifty 2" and same with the third row.

Is this kind of thing possible ? please guide & help

Thanks & Regards
Avinash Raste

 

[Jonmo1]

If the names are in column A starting in Row2, try this in B2 and filled down.

=A2&" "&COUNTIF(A$2:A2,A2)

 

[avinashraste]

Hi,
Dear Jonmo1,
Thank you very much for your valuable & prompt reply friend. Its working but a small difficulty I'm facing. Actually the name I want to change is in column A and the dates are in column B.

Thanks & Regards

Avinash Raste

 

[avinashraste]

Hi,
Sorry for troubling you again.

1) I have the names in column A and the dates are in column B.
2) I want to have the first name as it is, with the current date, for eg. " NIfty " should be the " Nifty " which is current month. Nifty with next month's date will be " Nifty 1 " and " Nifty 2 " for next to next month's date.

Please guide & help

Thanks & Regards
Avinash Raste