I have a sheet in which I need to figure out which sets of values in column B do not have repeating numbers of Column A. For example column A lists Family ID's and Column B lists Grades. How many sets of grades have ALL unique ID's , I.E grades 5 and 6 have all unique Family ID's with no repetitions, as do grades 3,4. Two grades per unique set is all I need . If anyone can help it would be much appreciated. Example attached.
Please mock up some expected results manually and then attach the sample workbook again. It is not that much use as it stands - sorry.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
One option is to create a pivot table with FamilyID in ROWS, Grade in COLUMNS, and Count of Grage in VALUES.
Then you can insert a slicer using Grade and select the two grades that you would like to check.
If all of the rows in Grand Total show 1, you're good.
If any of the rows are > 1, you have duplicates.
Grades 3 and 4 do not have duplicate FamilyIDs, but grades 5 and 6 do (98 and 101).
See attached.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks