I have literally typed in
=sumproduct(--(B2:B366=name),--(E2:E366<""),E2:E366)
but I am getting #NAME? error. I want cells in column D to read the client
name in column B and go to column E and find the latest finish date for that
person. Where am I going wrong with the above formula? Clients name can
appear on up to 5 rows scattered intermittently down the spreadsheet but only
one entry will have the finish date for that client and the rest will have
defaulted to 0 due to post linking from another workbook. Can anyone please
help. I have just this problem to go.
Thanks Sue.
B D
E
Client Names where latest finish date to be inserted Finish
dates