hello experts
we got may time solution with this forum once again we face a problem and i came here for soultion. hope we also get this time
We have a very large road recrod in this record in colum D we have follwing type data
1
2
3(200)
3(200)
3(600)
4
5
6(100)
6(900)
.
.
.
we want convert this data in follwing type
1
2
3-1
3-2
3-3
4
5
6-1
6-2
actually where matter in between () those cell change () text to start no - 1 or 2 or 3
we attach sample file for ur kind perusal
thanks in advance
Bookmarks