how to identify top 25 territory

sachin483
2StarLounger
Posts: 101
Joined: 03 Feb 2018, 04:20

how to identify top 25 territory

Post by sachin483 »

i want to identify top 25 territory then next 25 next1 25 and bottom 25 territory ie:- total territory count divide with 4 based on column "A" example attached
You do not have the required permissions to view the files attached to this post.

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: how to identify top 25 territory

Post by HansV »

What do you want the result to look like?
Best wishes,
Hans

sachin483
2StarLounger
Posts: 101
Joined: 03 Feb 2018, 04:20

Re: how to identify top 25 territory

Post by sachin483 »

The result should be like in column no "E" or as below

Top 25%
Next 25%
Next1 25%
Bottom 25%

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: how to identify top 25 territory

Post by HansV »

See the attached version. Column E contains formulas and conditional formatting.

top terr.xlsx
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans

sachin483
2StarLounger
Posts: 101
Joined: 03 Feb 2018, 04:20

how to identify top 25 territory

Post by sachin483 »

thanks for formula ,error reflecting at row number 54
You do not have the required permissions to view the files attached to this post.

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: how to identify top 25 territory

Post by HansV »

Is this better?

top terr (2).xlsx
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans

sachin483
2StarLounger
Posts: 101
Joined: 03 Feb 2018, 04:20

Re: how to identify top 25 territory

Post by sachin483 »

Thanks a lot working fine