I have data in two different columns in sheet 1. The data should contain the same number strings as each other. I have been unsuccessful creating a code that could verify that the numbers in each column are the same. The order by rows is not important, only that one column doesn't have extra or less rows of these number strings as the other. I have attached a workbook that will further explain this. Help would be greatly appreciated. Thank you.
Data validation question.xlsx
Last edited by RaydenUK; 02-26-2015 at 08:07 AM.
Does this help?
Please Login or Register to view this content.
Thank you for the code! I tried it and it works great. But would it be possible to incorporate a message box that notify the user if one column has more or less rows with the number strings? In the example in the workbook, there are 10 patient numbers in both columns. However, if one of the columns had an extra patient number compare to the other, then a message box would popup and say "Error! Patient entries do not match." But if they do match, as with the workbook example, then have a message box to say "Success! All entries match.". Thank you for your help. Also there may be more than 10 patient entries, essentially up to 100. Can the code be adjusted to recognize the amount of data in each column?
Last edited by RaydenUK; 02-26-2015 at 10:33 AM.
In your sample data Column A how do you determine what is a Patient Number and what is not? I may be confused. Does this help?
Please Login or Register to view this content.
Sorry for the confusion, but I should have clarified that the patient numbers are those in each column that contains 9 numbers or so, like 350502945 which corresponds to "Allen". The column on the left contains a few extra rows of info that are considered Quality Control measures. These should be ignored when validating patient numbers in each column. In other words, it just needs to match up the patient numbers that are highlighted in yellow. If those are the exact same and there are the same amount of patients between the columns then its a "success", otherwise if a number is different or one column has more patients then the other then its an "error". I hope this clears it up a bit.
Try:
Please Login or Register to view this content.
That almost does what I need it to. This data may range from 1 patient to 100 patients so can it be coded to just recognize the amount present instead of a set limit? Also, If the right column (G) has an extra patient entry then it doesn't get detected and it still says success. If it does give "Error", could it highlight the numbers that don't match in red fill? Again thank you so much for taking the time to do all this.
Try:
Please Login or Register to view this content.
Last edited by JOHN H. DAVIS; 02-26-2015 at 12:37 PM.
WOW!!! You are amazing! I cannot thank you enough. This is PERFECT! Thank you again!
You're welcome. Glad to help out and thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks