Forum Discussion
Solved
Table of Data: Is Countifs my best solution?
Hi, I have a very large table showing models and PNs. A model may have multiple PNs. What I need to have is a concise list of all model numbers with the PNs they have in the same row. For example: ...
Skip the filter_array argument with a comma or stop the formula at:
=GROUPBY(DemoTbl[Model],DemoTbl[PN],ARRAYTOTEXT,,0)
GROUPBY Function did not work in my Excel. So I had to settle for something more classical. Here's what I Did:
Model SL (Shortlist) =SORT(UNIQUE(DataTable[Model]))
All PNs =TEXTJOIN("; ",TRUE,FILTER(DataTable[PN],DataTable[Model]=E3))