I have a database of names with a number associated to them, is there a way to run a query to look at all the numbers and show all the entries with duplicate numbers?
Got a tip for us?
Let us know
Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.
AppleWorks Database Question
- Thread starter Benjamindaines
- Start date
- Sort by reaction score
One way is to export the records to a spreadsheet, Sort by "the number" and write a simple calculation in a blank column (lets say "the number" is in col A): IF(A2=A1,"Yes", "No")
or something similar. This will flag your duplicates
Just remember, the results of this calc will change if you re-sort, so you want to either copy and paste the values only into a new column, or just scan down the list manually and mark them.
or something similar. This will flag your duplicates
Just remember, the results of this calc will change if you re-sort, so you want to either copy and paste the values only into a new column, or just scan down the list manually and mark them.