CODEWITHSUNDEEP
excelexcel-formula
rauf741
rauf741

Reputation: 35

Formula in Excel to match a value in two columns with an occurence date of 24 hours difference

I am trying to match products in two different tables by their product name and date/time. I'm looking to find a match between column A & K if the date in column C occurred 24 hours BEFORE column L.

I have attached a picture of the matches I'm looking for & highlighted the ones that should result in a match.

picture here

thank you in advance for your help - this is far more advance than my knowledge of excel unfortunately, so I really appreciate the assistance.

Upvotes: 2

Views: 110

Answers (1)

BigBen
BigBen

Reputation: 50008

This can be accomplished with COUNTIFS.

=IF(COUNTIFS($K$2:$K$8,A2,$L$2:$L$8,">="&C2,$L$2:$L$8,"<="&C2+1)>0,A2,"")

enter image description here

Upvotes: 3

Related Questions