# next date in list greater than cell value

#### tpowell1986

##### New Member
hi,

we have a list of products has have been reported lost, i want to look at the list of transactions on another sheet to see if there is any further transactions after the date it was reported lost?

i.e.
 Vessel Lost Date Further Transactions Vessel date_out 7285165 08/04/2015 20/06/2021 7285165 01/01/2014 7759616 08/03/2018 7759616 02/01/2014 7759645 08/12/2015 7759645 03/01/2014 7759723 08/01/2018 7285165 20/06/2021 7759789 08/08/2016 7285165 23/06/2021

### Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

#### Fluff

##### MrExcel MVP, Moderator
+Fluff 1.xlsm
ABCDEF
1VesselLost DateFurther TransactionsVesseldate_out
2728516508/04/201523/06/2021728516501/01/2014
3775961608/03/2018 775961602/01/2014
4775964508/12/2015 775964503/01/2014
5775972308/01/2018 728516520/06/2021
6775978908/08/2016 728516523/06/2021
Lists
Cell Formulas
RangeFormula
C2:C6C2=LET(Mx,MAXIFS(F:F,E:E,A2),IF(Mx>B2,Mx,""))

#### tpowell1986

##### New Member
thank you, it needs ideally to show the next date in the list so in this case cell f5 not the max date

#### Fluff

##### MrExcel MVP, Moderator
Excel Formula:
``=IFERROR(AGGREGATE(15,6,\$F\$2:\$F\$6/(\$E\$2:\$E\$6=A2)/(\$F\$2:\$F\$6>B2),1),"")``

#### tpowell1986

##### New Member
Excel Formula:
``=IFERROR(AGGREGATE(15,6,\$F\$2:\$F\$6/(\$E\$2:\$E\$6=A2)/(\$F\$2:\$F\$6>B2),1),"")``
thank you, much appreciated!

#### Fluff

##### MrExcel MVP, Moderator
You're welcome & thanks for the feedback.

Replies
3
Views
49
Replies
1
Views
94
Replies
3
Views
237
Replies
4
Views
98
Replies
11
Views
300

1,141,063
Messages
5,704,064
Members
421,326
Latest member
pfaustino

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back