Please can anyone help me with a micro that highlights rows in a range whereby most of the columns (i.e 5 of 8 columns ) or the entire row contains a duplicate entries for every column. See rows 1 & 2 of the example data below. Row 3 shouldn't be highlighted.
Example data:
A B C D E F G H
1 N/A N/A N/A N/A N/A N/A N/A N/A
2 NK NK NK NK NK NK NK NK
3 N/A N/A cif n/a cif dell Rbd Sbc
I really appreciate any help you can provide,
Mo
Please attach a sample workbook with enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
Note: Please don't attach documents containing confidential data like (address, telephone, ID#s, etc.).
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Thank you for the quick response Sixthsense.
I have attached an excel file (data), with before and after sheets.
What I would like to get is a micro that would highlight rows that
have a duplicate for each of the columns in the range, or highlight
rows that have a duplicate for >=50% of the columns,or rows that haveless than 4 different items.
Regards,
Mo
Last edited by MoHassan; 10-21-2013 at 10:26 AM.
Try this code…
Please Login or Register to view this content.
God bless and thank youSixthsense
Glad it helps you and thanks for the Wishes/Feedback and rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks