Forum Discussion
Extracting Data
Hello, I am hoping someone might be able to help me, I have data on sheet one that is in a table with headings. The first column contains a Cost Code, the fifth column contains a DFA number, I ...
=TEXTJOIN(", ",,FILTER(reconciliation!$A$2:$A$22,reconciliation!$E$2:$E$22='second reconciliation sheet'!E2))If you work with Office365 or 2021 the above formula could do what you are looking for.