One way using non array formulas ..

Assume source data in Sheet1's cols A to D,
from row1 down, with key col A

In Sheet2,

Put in A1:
=IF(Sheet1!A1="","",IF(COUNTIF(Sheet1!A:A,Sheet1!A 1)1,ROW(),""))

Put in B1:
=IF(ROW()COUNT($A:$A),"",INDEX(Sheet1!A:A,SMALL($ A:$A,ROW())))
Copy B1 across to E1. Select A1:E1, copy down to cover the max expected
extemt of data in Sheet1's key col A. Hide away col A. Cols B to E will
return the required results, all neatly bunched at the top.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Mary" wrote:
My spreadsheet contains the following:
A B C D
1 123 xxxx x1x1 12345
2 101 yyyy y1y1 23456
3 123 zzzz z1z1 34567
4 215 aaaa a1a1 89100

In another spreadsheet, I want to get all data using column A as the
criteria including those with duplicate values and not just the first one. In
effect I want my other worksheet to show:
A B C D
1 123 xxxx x1x1 12345
2 123 zzzz z1z1 34567