Add different numbers to the same name

[avinashraste]

Dear all,

Hi, I have a set of companies names. ( 227 Companies, each having 3 rows ) Grouped in a three months data.
For eg. Column A contains company's name and column B contains date. Each company contains three rows for three months. for eg. NTPC for current month. NTPC for next month and NTPC for next to next month. Now I have NTPC in column A with the current date in column B in 2nd row ( First row is a header ). NTPC in column A with next month's date in column B in 3rd row and NTPC in column A with next to next month's date in column B in 4th row.
Now I want to put formula which will give me the result as :-

" NTPC " Current Date
" NTPC 1 " Next month's Date
" NTPC 2 " Next to next month's Date.

please guide & help.

Thanks & Regards
Avinash Raste
<!-- / message -->

 

[Joe4]

Duplicate: http://www.mrexcel.com/forum/showthread.php?t=540804

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).