With Kutools for excel can I set up this formula. <ul> <li>Find all duplicates in Column E (Convey). </li><li>The matching duplicates in Column E be compared with the pass and fails in Column H. (Inspections) </li><li>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 </li> Thank you Kim </ul> Kimb

New

Is it possible to get these returns with Kutools?

Friday, March 19, 2021

1 Replies

8.4K Visits

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

Kimb

3 years ago

Hello,
Sorry, we don't have such a feature yet.

There are no replies made for this post yet.