Hello,
I am trying to extract the latest date from a range of dates, with a unique identifier as the criteria. My data looks like:
Sheet1
<tbody>
</tbody>
<tbody>
</tbody>
And I would like my output (in a different sheet) to look like:
Sheet2
<tbody>
</tbody>
<tbody>
</tbody>
So far I have tried (as the input to Sheet2!B) :
to no avail. The closest I have got is:
- but that sums all the date ranges, so my answer will be 2/3/2676.
Any help would be appreciated!
Thanks
I am trying to extract the latest date from a range of dates, with a unique identifier as the criteria. My data looks like:
Sheet1
A | B |
<tbody>
</tbody>
Identifier | Dates |
12 | 1/2/1900 |
10 | 3/1/1901 |
12 | 1/5/1899 |
13 | 2/3/1900 |
19 | 7/4/1901 |
10 | 4/2/1901 |
12 | 1/5/1900 |
14 | 3/2/1901 |
10 | 6/5/1901 |
<tbody>
</tbody>
And I would like my output (in a different sheet) to look like:
Sheet2
A | B |
<tbody>
</tbody>
12 | 1/5/1901 |
10 | 6/5/1901 |
13 | 2/3/1900 |
<tbody>
</tbody>
So far I have tried (as the input to Sheet2!B) :
Code:
=if(sheet2!A1=Sheet1!A:A,max(sheet1!b:b),"")
Code:
=SUMPRODUCT((sheet2!A1=Sheet1!A:A)*1,(Sheet1!B)*1)
to no avail. The closest I have got is:
Code:
=SUMIFS(Sheet1!B,Sheet1!A:A,Sheet2!A1)
Any help would be appreciated!
Thanks