With Kutools for excel can I set up this formula.   

• Find all duplicates in Column E  (Convey).
  
• The matching duplicates in Column E be compared with the pass and fails in Column H. (Inspections)
  
• Return the in tables with include the Categories which I can most like find using merging tables.ConveryCategoryinspectionsDates 1237895Toms businessPass5/9/2021   Fail5/1/2014   Fail4/3/2021 ConveryBusiness nameinspectionsDates 1237815 Fail5/9/2021   Fail5/1/2014   pass4/3/2021           
  

Thank you
Kim

Kimb