Forum Discussion
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)
This works great. What do I do if I dont want to exclude a model? =GROUPBY(DemoTbl[Model],DemoTbl[PN],ARRAYTOTEXT,,0,,)?
Skip the filter_array argument with a comma or stop the formula at:
=GROUPBY(DemoTbl[Model],DemoTbl[PN],ARRAYTOTEXT,,0)
Thank you! :)
