Dé hAoine, 19 2021 Márta
  1 Freagraí
  Cuairteanna 6.2K
0
Vótaí
Undo
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           

  • Go raibh maith agat
    Kim

Kimb 
blianta 3 shin
·
#2234
0
Vótaí
Undo
Dia duit,
Faraoir, níl a leithéid de ghné againn fós.
  • Page:
  • 1
Níl aon fhreagraí déanta don phost seo go fóill.