Home |
Search |
Today's Posts |
#1
|
|||
|
|||
sumproduct for latest date
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
search for latest date | Excel Worksheet Functions | |||
Sumproduct with Date column | Excel Worksheet Functions | |||
Using sumproduct to count number by date | Excel Worksheet Functions | |||
SUMPRODUCT with date range question | Excel Discussion (Misc queries) |