how to identify top 25 territory
-
- 2StarLounger
- Posts: 101
- Joined: 03 Feb 2018, 04:20
how to identify top 25 territory
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.
-
- Administrator
- Posts: 78471
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
- 2StarLounger
- Posts: 101
- Joined: 03 Feb 2018, 04:20
Re: how to identify top 25 territory
The result should be like in column no "E" or as below
Top 25%
Next 25%
Next1 25%
Bottom 25%
Top 25%
Next 25%
Next1 25%
Bottom 25%
-
- Administrator
- Posts: 78471
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: how to identify top 25 territory
See the attached version. Column E contains formulas and conditional formatting.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- 2StarLounger
- Posts: 101
- Joined: 03 Feb 2018, 04:20
how to identify top 25 territory
thanks for formula ,error reflecting at row number 54
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78471
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: how to identify top 25 territory
Is this better?
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- 2StarLounger
- Posts: 101
- Joined: 03 Feb 2018, 04:20
Re: how to identify top 25 territory
Thanks a lot working fine