Forum Discussion
Solved
Excel formula Help
Hi all, I have a problems on my formula. I have two worksheet 1 and 2. for worksheet 1, the yellow highlighted contains all the country name but i have to use worksheet 2 as a data set (green...
So it wasn't really your desired result.
My solution requires Power Query.
The result from PQ is loaded into the pivot table.
doraymi , could you please clarify - you have 6 columns in Sheet1 with country names, for which one you need the frequency? Or you'd like calculate the frequency based on these columns?
SergeiBaklan yes, i'd like to calculate frequency for all six column, and then to list out all the most "high frequency" items (it might have more than 1 high frequent country in each row), so as to use those information and compare with company name (column C) in the pivot table. thanks!
