TexasCHLforum.com

Okay, I guess I was being a little too cryptic. To renew your PSC Membership, one must watch a safety video and pass a related exam. All of this is automated and Members' scores are in a database. I export this data to Excel for analysis and to upload to a different database/website.

If a person fails the exam and then passes later, there are two entries for the Member making it impossible to quickly identify how many of our Members have yet to pass the safety exam. Some Members pass the exam but take it again, apparently trying to get a perfect score.

I solved the problem with a macro, but I was hoping to use one that was a bit more efficient.

Thanks,
Chas.

RogueUSMC wrote:If the duplicates you are truing to find are all on the same column, just select the column and use the conditional formatting to change the color, font, size, weight, etc for anything that has a duplicate. You can leave the conditional formatting intact, then as you enter data, it will highlight duplicates live.

Thanks, but I don't need to identify the duplicates, I need a count of the duplicates. This is so we can get a net figure for Members who have accomplished a specified task.

Chas.

Keith B wrote:See if this does what you need http://office.microsoft.com/en-us/excel ... 1&client=1" onclick="window.open(this.href);return false;

Thanks Keith, that gives me a quick way to check duplicate Members. I also created a macro copying the entire sheet to a new tab. Then duplicates are deleted and a count function is used to get me a number I can make available to our Membership Director.

In case anyone is wondering, no we don't have a membership records on an Excel spreadsheet. This is for something else within the Club.

Thanks again,
Chas.

I need to be able to count the total number of duplicate entries in a table. I know how to do this with a pivot table, but that won't work for our purpose. We need to be able to determine the total number of duplicate entries so we can get a net number and compare that to our Club database. We don't care who has a duplicate entry. The key field for determining duplicates would be a member number.

Thanks,
Chas.