This is how I see a solution to your problem, using a very small sample.
In cells A2 to A8 I have the numbers of which some may appear more than once.
In cell B2 I have =row(A2) and that is copied to the range B2:B8.
In cell C2 I have =SUMPRODUCT(--(A2=$A2:$A$8)) which is copied to the range
C2:C8.
Sheet 2:
Column A contains the unique numbers which you want to find.
Cells B1 to G1 contain the numbers 1 to 6.
Cell B2 contains
=SUMPRODUCT(Sheet1!$B$2:$B$8,--(Sheet1!$A$2:$A$8=Sheet2!$A2),--(B$1=Sheet1!$C$2:$C$8)) which is copied.
There will be zeroes which indicate that there are no further rows
containing the value. You could create a formula to give you a blank instead
of a zero.

"gordo" wrote:

Can someone please help
I have the following workbook with a selection of the data below:


INUMBR ILONGD WHHAND WHCOMM WHPEND WHSLOT01
175552 WHIRLPOOL AWM1404/4 1400RPM WASHER (AAB,5KG) 154 18
0 R4015
247294 BOSCH WFL2067 1000RPM WM(CLASIXX,A+AC,6) 111 2
0 R2023
247294 BOSCH WFL2067 1000RPM WM(CLASIXX,A+AC,6) 111 2
0 R4007
247294 BOSCH WFL2067 1000RPM WM(CLASIXX,A+AC,6) 111 2
0 R4018
247308 BOSCH WFO2467 1200RPM WM (CLASIXX,A+AB,6) 128 29
0 B1043
What i am trying to do is for example:
Inumber 247294 appears above 3 times with different locations , the
inumber being in A1-A1000 (Some Inumber appear more than once) and the
Locations in h1-h1000.
I have a seperate workbook with a list of Inumbr which is only
displayed once. What i want to do is bring back all the locations for
the Inumber.
For example : 247294 has three locations R2023,r4007,r4018. Using
vlookup only brings back the first location (r2023)and dosent allow the

second value and third respectively.
Is there any way of displaying these.
Note =cell is not an option (workbook changes)

cAN SOMEONE PLEASE EMAIL ME AT AND I WILL
SEND THE DOC IF REQUIRED
Many thanks


Gordon