There could be different meanings to your question, so I need a
clarification.

1. Do you want a count of the duplicate IDs in column 1 counted a
independently of anything else...PLUS the count of duplicate names in
column 5 counted independently?

2. Do you want a count of when the ID and Name in a single row is
duplicated somewhere else, also paired together?


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=57718