Extending the earlier set-up [ http://tinyurl.com/zo9nf ]
here's a non-array formulas play which delivers what you're after ..

Extended sample is available at:
http://www.savefile.com/files/5242623
Dyn data listing fr 31shts n Extr dupes n uniques.xls

Assume the names are listed in col B in each of the 31 daily sheets
(col A = tel#s)

In Summary,

Labels placed in G1:I1 : Dupes In sheet, Tel#, Name

In F2:
=IF(B2=0,"",IF(COUNTIF($B$2:B2,B2)1,ROW(),""))
(Leave F1 empty)

In G2:
=IF(ROW(A1)COUNT($F:$F),"",
INDEX(A:A,MATCH(SMALL($F:$F,ROW(A1)),$F:$F,0)))
Copy G2 to H2

In I2:
=IF(G2="","",
INDEX(INDIRECT("'"&G2&"'!B:B"),MATCH(H2,INDIRECT(" '"&G2&"'!A:A"),0)))

Select F2:I2, fill down to I31
(cover the same extent as the earlier set-up in cols A to E)

Cols G to I will return the required results, all neatly bunched at the top

Col G = Dupes In sheet, will tell you the sheets that the dupes are in
Col H = Tel#, will list the duplicated tel#s
Col I = Name, will extract the corresponding names from the particular sheets
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Mhz" wrote:
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