I not long ago had Great Info Provided By Max similar to what I'm
requesting here, but hopefully a bit simpler.

Now that I have a way to ID duplicate Phone numbers accross multiple
sheets, I want only the name and number of these dupes applied to a
summary or dupe sheet... I am flaging the dupes with counts, I need a
formula to find any counts (Specifying a Duplicate), and in return print
the Name and Phone of that dupe on a Summary or Duplicate sheet.

Thanks In Advance for any help here.

e.g. If column A6:A35 is Greater than 1 then Print the Name (Column B)
and Phone (Column C) to Summary or Dupe Sheet.


--
Mhz
------------------------------------------------------------------------
Mhz's Profile: http://www.excelforum.com/member.php...o&userid=35980
View this thread: http://www.excelforum.com/showthread...hreadid=561041