Forum Discussion

tommills's avatar
tommills
Copper Contributor
Jan 07, 2019

Excel Help large data in inconsistent quantities

I have a data set of over 200,000 rows. It consists of certain parties (column A) and each their products (column B), however each party has a different amount of products. I need to filter out the p...
excel
tommills's avatar
tommills
Copper Contributor
Jan 08, 2019
Hi,

Thanks for your help, just wondering what formula you used to achieve the combinations?

Thanks
Wyn Hopkins's avatar
Wyn Hopkins
MVP
Jan 08, 2019
Did you look at the attached file? I used & to join them
  • tommills's avatar
    tommills
    Copper Contributor
    Jan 08, 2019

    Oh yes I see, thank you very much

Resources