Hi,
I have a worksheet with multiple rows. there are some rows with similar values, i.e if we filter, values in row'x' matches with row 'y'. similarly values in row 'a' matches with row 'b'. I would like to have any formula or vba that can identify the similar rows and then assign a name for each matching row. I have attached a snap for reference.
Row comparison.PNG
Thank you.
Regards,
Rajeshkumar
Hi, welcome to the forum
1. does each column have to match, or just certain columns?
2. How do you define what name to use?
3. I have a feeling you are looking for something like ....
="name "&countifs(A:A,A1,B:B,B1...............)
4. If that doesnt help, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi,
Thank you.
I tried using the formula but didnt get the desired output.
I have a issue in attaching the file. Unable to use the attach file option.
Regards,
Rajesh
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"
Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.
Hi,
Thank you for your help. I have attached a file with the actual requirement.
Your support will be highly appreciated.
Thank you.
Hi, i have attached the file, kindly help me on this.
Regards,
Rajesh
This proposed partial solution identifies matching rows. The solution employs two helper columns which may be placed in an inconspicuous location, columns XFC:XFD in the attached file, and/or hidden for aesthetic purposes.
The formula that populates the first helper column is: =D16&E16&F16&G16
The formula that populates the second helper column is: =MATCH(XFC16,XFC$16:XFC16,0)
The formula that displays the 'Type' is: ="TYPE-"&XFD16
If you could further explain the rational behind your naming system then perhaps someone here will be able to modify this solution to match the names shown in post #1.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Hi JeteMC, Thanks for your reply. It gave me a sort of solution i'm looking for. The naming system is done based on the identical rows. As "MATCH" does by taking the first matching rows and assigning the numbers according, we do the same by manually. The only thing in MATCH is that the sequence. If that is solved it should solve my issue.
Thank you.
Regards,
Rajesh
At present I don't understand why the why S no 1 is assigned Type-3 and S no's 2 and 3 are assigned Type-1. To make an attempt at solving the issue of matching the sequence in post #1 I'd need to understand the rational behind the sequence. If you could explain the sequence, I (or one of the other volunteers) will try to write a solution.
Let us know if you have any questions.
Hi, sorry for giving minimum inputs.
I have assigned the type numbers as described below.
We have columns L1,L2, L3 & L4. First i disabled blanks in each column L1 to L4 , when i did this i was left with rows s.no 2, 4 & 7, so i gave them TYPE-1.
Then i enabled blank in column L4 and disabled 300 LR, so i was left with rows s.no 9 & 10, hence i gave them TYPE-2 & so on.
Hope this will give you some clue, kindly let me know if more details are required.
Regards,
Rajesh
If I understand this has more to do with blanks than the values in the cells that are not blank.
The proposed solution uses several helper columns, which may be moved and/or hidden, populated by two formulas.
The formula for the "None" helper column is:The formula for the "L4" through "L1" columns is:Formula:
Please Login or Register to view this content.Let us know if you have any questions.Formula:Please Login or Register to view this content.
Re: VBA/Formula to identify similar values in multiple rows and assign a name
Thanks JeteMc for your guidance.. This helped me a lot & forgive me for late reply.
Cheers!!!
Rajesh
You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks