Hey,
In Column A1:A200, I have a number in each cell, let's say from 1 - 16. I need to know on each cell the percentage of how many times that number exists in this column. For e.g. in A1 there is a "13" and there are another 9 '13's in this column. So after entering the appropriate formula in B1, I expect Excel to return "20%" and so on by dragging down the formula.
Thanking you in advance
In Column A1:A200, I have a number in each cell, let's say from 1 - 16. I need to know on each cell the percentage of how many times that number exists in this column. For e.g. in A1 there is a "13" and there are another 9 '13's in this column. So after entering the appropriate formula in B1, I expect Excel to return "20%" and so on by dragging down the formula.
Thanking you in advance