So here is my dilemma, I have two tables, in column A on both tables is the work order number. Working from Table 1, I need to find a match in table 2, and then in that row find the 5 greatest number values, and return the value and column header back to Table 1.
I thought TEXTJOIN might work?
I have a TEXTJOIN formula for a different column in Table 1 but not sure how to tweak it, this one is only checking one column:
=IF(A3="","",TEXTJOIN(", ", TRUE, IF(IFERROR(MATCH(KBDataTbl_for_Houston_Metrics[Machine], IF(A3=KBDataTbl_for_Houston_Metrics[Work Order.], KBDataTbl_for_Houston_Metrics[Machine], ""), 0),"")=MATCH(ROW(KBDataTbl_for_Houston_Metrics[Machine]), ROW(KBDataTbl_for_Houston_Metrics[Machine])), KBDataTbl_for_Houston_Metrics[Machine], "")))
The columns I need to check are B through BJ:
I thought TEXTJOIN might work?
I have a TEXTJOIN formula for a different column in Table 1 but not sure how to tweak it, this one is only checking one column:
=IF(A3="","",TEXTJOIN(", ", TRUE, IF(IFERROR(MATCH(KBDataTbl_for_Houston_Metrics[Machine], IF(A3=KBDataTbl_for_Houston_Metrics[Work Order.], KBDataTbl_for_Houston_Metrics[Machine], ""), 0),"")=MATCH(ROW(KBDataTbl_for_Houston_Metrics[Machine]), ROW(KBDataTbl_for_Houston_Metrics[Machine])), KBDataTbl_for_Houston_Metrics[Machine], "")))
The columns I need to check are B through BJ: