Good morning.
How can i write formula to count number of top spend company that made up to 50% total spend in one country ? and then calculate the percentage of spend under these supplier over total spend from all country. How to make the formula more flexible because in reality the spend will not be sorted in order and more than 2 countries in the list.
Data file and expected result is in the link Percentage V1.xlsx
thank you
How can i write formula to count number of top spend company that made up to 50% total spend in one country ? and then calculate the percentage of spend under these supplier over total spend from all country. How to make the formula more flexible because in reality the spend will not be sorted in order and more than 2 countries in the list.
Data file and expected result is in the link Percentage V1.xlsx
thank you
