Ranking top 5 with out taking NET and SN

sksanjeev786

Well-known Member
Joined
Aug 5, 2020
Messages
961
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Hi Team,

I Need data without NET and (SN) top 5 statement

book1
ABCDE
1SITUATION VISUAL (NET)50%
2People are more interested in the car than the driver or anyone/anything else40%
3People notice/are captivated by the car1%People are more interested in the car than the driver or anyone/anything else40%
4AD COPY (NET)70%Reference to 'be yourself/whatever you want to be/be unique'39%
5References to 'Goat'-To find new roads (similar)38%
6Reference to enjoy/appreciate your life(SN)33%Reference to 'Dream'35%
7Reference to 'be yourself/whatever you want to be/be unique'39%
8Reference to 'You can achieve anything'-
9To find new roads (similar)38%
10Reference to 'Dream'35%
11OFFER/PRICE/VALUE (NET)35%
12Good/affordable price-
13Offered a good/great deal/rebate/promotionife(SN)32%
14It is easy to buy33%
15Easy to get/no hassle good pricing/don't need a sale-
16Economy/economicalife(SN)31%
17Buy the car/vehicle/ad says buy it0%
1820 day sale-
19Offers discount(no detail)ife(SN)29%
20Offers 20 day sale-
21VEHICLE FEATURES/TECHNOLOGY (NET)30%
22Good features0%
23Variety/different features1%
24Has new functions-
Sheet1


Thanks
 
Hi Team,

One more request got from my team.

It is possible to get Top 3 NET and under each NET i need stubs without SN. on above table.
AD COPY (NET) 70%
Reference to 'be yourself/whatever you want to be/be unique'
39%​
To find new roads (similar)
38%​

Same way for other top 2 NET but with out SN

Thanks in advance Team
Sanjeev





Thanks.
Regards,
Sanjeev
 
Upvote 0

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
As this is a totally different question, you will need to start a new thread.
 
Upvote 0

Forum statistics

Threads
1,223,228
Messages
6,170,871
Members
452,363
Latest member
merico17

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top