Many thanks Max, looks like you cracked it, I've forwarded to what I hope is
a very happy chappy.
Scoz
"Max" wrote:
Since you indicated that you want to return the data in row1 if its unflagged,
Adjust it in B5 to:
=IF(SUMPRODUCT(--(B1:B3<""),1/COUNTIF(B1:B3,B1:B3&""))1,"X",B1)
Copy across as before
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---