Percentile Function of excel

[dali1962]

I have a list of sales data.

I want to list the names which contribute to 75% of all total sales.

how do I do that? is it possible to do it with percentile function??

Or just rank the names which contribute up till 75% of sales. highest contributing SKU will be ranked as 1st and so on. the last 25% percent do not need to be ranked.

is it possible to do so only with formulas and not macros?

Please help

Name	Sales
A	3405
B	4893
C	7920
D	4682
E	3082
F	9283
G	1038
Total	XX

<tbody>
</tbody>

 

[alexk7384]

Possibly - I tried adding a blank line and got an error in the Rank column on that line, but the other ranks didn't change. Maybe try wrapping the rank.eq() with iferror() like this:

=IF(IFERROR(RANK.EQ($B2,$B$2:$B$9),0)<=COUNTIF($B$2:$B$9,">"&PERCENTILE.INC($B$2:$B$9,75%))+1,IFERROR(RANK.EQ($B2,$B$2:$B$9),""),"")

 

[dali1962]

Hey, So sorry to disturb you again, but i have understood the problem.

AS it takes value "0" as well, it shows more rank which contribute to 75% of sales.
Is it possible to avoid cells which have their value as 0?

1786865
7104557		7
124426.6
11346097	4	4
6863178		8
190439.6
3840394
246050.5
16563570	2	2
-5026.48
105562.4
17211116	1	1
5245846
15013136	3	3
6052145
3218168
10619321	5	5
8198171	6	6
0
0
0
0
0
0
0
0
0

<tbody>
</tbody>

Thank you so much for all the help and sorry for the trouble.