Another play to try ...
Assuming source table in cols A to C*, data from row2 down
*ie Pool, Part #, Final Discrepancies
Put in D2:
=IF(C2="","",COUNTIF(C$2:C2,C2))
Put in E2, array-entered (press CTRL+SHIFT+ENTER to confirm the formula):
=IF(D2="","",IF(ISNUMBER(MATCH(-C2&"_"&D2&"_"&B2,C$2:C2&"_"&D$2:D2&"_"&B$2:B2,0)), "Move
"&C2&" to
"&INDEX(A$2:A2,MATCH(-C2&"_"&D2&"_"&B2,C$2:C2&"_"&D$2:D2&"_"&B$2:B2,0)), ""))
Select D2:E2, fill down as far as required. Hide away col D. Col E should
return the required "action" indications (resembling what you're after)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---