Forum Discussion
Categorization of a large, dynamic data set
I have a challenge which I can't solve. Already tried multiple ways - makearray, byrow, etc. Nothing worked so far. Here is the challenge: I have a large set of data (>20000 rows, dynamic). It holds...
I have created 2 columns with same result. one with Formulas and second with Power Query.
Please check the attached file.
Thanks a lot! Also this way it worked out quite nice! Thanks for your help!!
