For eg if
name Add Phone ISCI Website Lenders
Manmeet smthin smthing 000000 x
Manmeet smthin smthing 000000 x
Manmeet smthin smthing 000000 x
How do i get manmeet and his full info in row like manmeet addresss phone and the 3 x x x in one row..I have to do this for multiple rows. Please help
http://www.4shared.com/account/dir/a...#dir=305641656
Hey thanks..! That helped. But still the task is not fully completed. If there are three duplicate rows and I want to commingle them into one by keeping maximum information, then how shall we go about it?
For example, in the attached file I want the output of 7th, 8th & 9th row to look like the one in the 13th row. Is that possible ?
So only Columns F, G & H should be merged into one row along with the rest of the information? And the duplicate rows deleted?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Yes. Also the cells containing maximum information from other columns should be considered while merging all into one single row.Originally Posted by arlu1201
Is there any other identifier to compare the rows? For e.g. It will be tough to match Manmeet B with Manmeet.
That is the problem which I am facing as suppose Manmeet B and manmeet is given in my data how would i combine it to get max results forit. As i have a data of more than 80,000+ or even if manmeet is given found after merging will the address section have more data in it.
How do we solve this? Atleast there should be one common field between the common rows, so we can merge the data.
for eg if we take the phone no. as a common field, can we get the best result??
But the phone number is not unique as well.
manmeets1
Is this what you are after?
yes i am looking for this..can you please tell me how did you perform this function
---------- Post added at 07:42 PM ---------- Previous post was at 07:40 PM ----------
But my friend if there is less info in one of the rows will it take the max information from other rows and perform the same function..Please help me as it will be of great help to me
Don't understand what you are asking.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks