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)
With worksheet functions, GROUPBY is your best bet. The speed of calculation will likely depend on the strength of your filter.
For example:
=GROUPBY(DemoTbl[Model],DemoTbl[PN],ARRAYTOTEXT,,0,,DemoTbl[Model]<>"F")
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! :)
