Find next date in list based on multiple critera

tpowell1986

New Member
Joined
Jun 23, 2021
Messages
14
Office Version
  1. 365
Platform
  1. Windows
I have a list of transactions containing product and sold dates, the same product may appear multiple times in the list with different sold dates. i would like to know how i can find the next time that product was sold after the date on the current line? thanks

VesselSold DateNext Transaction Date
728516508/04/201508/01/2018
775961608/03/2018
775964508/12/2015
728516508/01/2018
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
Hi & welcome to MrExcel.
How about
+Fluff 1.xlsm
ABC
1VesselSold DateNext Transaction Date
2728516504/08/201501/08/2018
3775961603/08/201801/05/2021
4775964512/08/2015 
5728516501/08/2018 
6775961601/05/2021 
Lists
Cell Formulas
RangeFormula
C2:C6C2=XLOOKUP(A2,A3:A6,B3:B6,"",0)
 
Upvote 0
Solution
yes thats great, thanks for the help!

sorry one more of the back of this, i can put in a new threat if required.

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.
VesselLost DateFurther TransactionsVesseldate_out
728516508/04/201520/06/20217285165
01/01/2014​
775961608/03/20187759616
02/01/2014​
775964508/12/20157759645
03/01/2014​
775972308/01/20187285165
20/06/2021​
775978908/08/20167285165
23/06/2021​
 
Upvote 0
As that is a totally different question, it needs a new thread. Thanks
 
Upvote 0

Forum statistics

Threads
1,213,510
Messages
6,114,040
Members
448,543
Latest member
MartinLarkin

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top