Ranking top 5 with taking NET and top 3 under NET

[sksanjeev786]

Hi Team

As per my previous solution, it is a bit similar but this time I need Top 3 NET and under NET top 3 statement with out (SN)

Just adding the same team, As the team has help and on my previous query @Fluff @KevCarter @jasonb75 .

Thank you in advance Team

Book1
	A	B	C	D	E
1	SITUATION VISUAL (NET)	0.5
2	People are more interested in the car than the driver or anyone/anything else	0.4
3	People notice/are captivated by the car	0.01		AD COPY (NET) 70%	70%
4	AD COPY (NET)	0.7		Reference to 'be yourself/whatever you want to be/be unique'	39%
5	References to 'Goat'	-		To find new roads (similar)	38%
6	Reference to enjoy/appreciate your life(SN)	0.33		Reference to 'Dream'	35%
7	Reference to 'be yourself/whatever you want to be/be unique'	0.39
8	Reference to 'You can achieve anything'	-
9	To find new roads (similar)	0.38
10	Reference to 'Dream'	0.35
11	OFFER/PRICE/VALUE (NET)	0.35
12	Good/affordable price	-
13	Offered a good/great deal/rebate/promotionife(SN)	0.32
14	It is easy to buy	0.33
15	Easy to get/no hassle good pricing/don't need a sale	-
16	Economy/economicalife(SN)	0.31
17	Buy the car/vehicle/ad says buy it	0
18	20 day sale	-
19	Offers discount(no detail)ife(SN)	0.29
20	Offers 20 day sale	-
21	VEHICLE FEATURES/TECHNOLOGY (NET)	0.3
22	Good features	0
23	Variety/different features	0.01
24	Has new functions	-
Sheet1

 

[sksanjeev786]

Hi Team

As per my previous solution, it is a bit similar but this time I need Top 3 NET and under NET top 3 statement with out (SN)

Just adding the same team, As the team has help and on my previous query @Fluff @KevCarter @jasonb75 .

Thank you in advance Team

Book1
	A	B	C	D	E
1	SITUATION VISUAL (NET)	0.5
2	People are more interested in the car than the driver or anyone/anything else	0.4
3	People notice/are captivated by the car	0.01		AD COPY (NET) 70%	70%
4	AD COPY (NET)	0.7		Reference to 'be yourself/whatever you want to be/be unique'	39%
5	References to 'Goat'	-		To find new roads (similar)	38%
6	Reference to enjoy/appreciate your life(SN)	0.33		Reference to 'Dream'	35%
7	Reference to 'be yourself/whatever you want to be/be unique'	0.39
8	Reference to 'You can achieve anything'	-
9	To find new roads (similar)	0.38
10	Reference to 'Dream'	0.35
11	OFFER/PRICE/VALUE (NET)	0.35
12	Good/affordable price	-
13	Offered a good/great deal/rebate/promotionife(SN)	0.32
14	It is easy to buy	0.33
15	Easy to get/no hassle good pricing/don't need a sale	-
16	Economy/economicalife(SN)	0.31
17	Buy the car/vehicle/ad says buy it	0
18	20 day sale	-
19	Offers discount(no detail)ife(SN)	0.29
20	Offers 20 day sale	-
21	VEHICLE FEATURES/TECHNOLOGY (NET)	0.3
22	Good features	0
23	Variety/different features	0.01
24	Has new functions	-
Sheet1

Hi Team,

Can anyone help me on above note

Thanks.
Sanjeev

 

[sksanjeev786]

Hi Team,

Can anyone help me on above formula condition

Thanks.
Sanjeev