hi all i need help on this.
eg: i have to insert numbers in column a and the names in column b.
wht i require is :
andrew 1
andrew 2
chris 1
chris 2
daniel 1
daniel 2
daniel 3
anyone can help?
hi all i need help on this.
eg: i have to insert numbers in column a and the names in column b.
wht i require is :
andrew 1
andrew 2
chris 1
chris 2
daniel 1
daniel 2
daniel 3
anyone can help?
Hi leeaw,
If the names start at B2 and are sorted, put the following in cell A2 and fill down as required:
HTHPlease Login or Register to view this content.
Robert
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
Moved to correct Forum
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks