sksanjeev786
Well-known Member
- Joined
- Aug 5, 2020
- Messages
- 1,010
- Office Version
- 365
- 2016
- Platform
- Windows
Hi Team,
I need a ranking Based on NET first and the within the group
for example : I have done the NET ranking Row no 3,10,16,21,25 and 29 in column B and then rank within the group row 4-9, 12-15
we will always have NET wording in data file
i have done manually Output F to G column.
I need a ranking Based on NET first and the within the group
for example : I have done the NET ranking Row no 3,10,16,21,25 and 29 in column B and then rank within the group row 4-9, 12-15
we will always have NET wording in data file
i have done manually Output F to G column.
| book2 | ||||||||
|---|---|---|---|---|---|---|---|---|
| B | C | D | E | F | G | |||
| 1 | Input | Ouput | ||||||
| 2 | ||||||||
| 3 | (NET) IN/AROUND STORE | 87% | (NET) IN/AROUND STORE | 87% | ||||
| 4 | Featured prominently on the shelf at a store | 63% | Saw product inside of a store | 66% | ||||
| 5 | Saw signs or ads inside or outside of a store | 53% | Featured prominently on the shelf at a store | 63% | ||||
| 6 | Saw product inside of a store | 66% | Saw signs or ads inside or outside of a store | 53% | ||||
| 7 | Heard about it from a store clerk | 34% | Visited a brand shop / pop-up store | 43% | ||||
| 8 | Heard about it from a representative of the brand at a store | 33% | Heard about it from a store clerk | 34% | ||||
| 9 | Visited a brand shop / pop-up store | 43% | Heard about it from a representative of the brand at a store | 33% | ||||
| 10 | (NET) ADVERTISEMENT | 66% | (NET) WOM / OVERHEARD | 80% | ||||
| 11 | Saw an ad on TV or video streaming service | 36% | Saw an adult tobacco/nicotine consumer using it | 56% | ||||
| 12 | Saw an ad in a magazine | 40% | Recommended by friends or family | 53% | ||||
| 13 | Saw an ad online (banner, pop-up) | 40% | Heard about it from an adult tobacco/nicotine consumer | 45% | ||||
| 14 | Saw the brand advertised at an event/concert | 31% | Saw in news article or clip | 32% | ||||
| 15 | Heard an ad when listening to the radio, streaming music, or a podcast | 35% | (NET) ONLINE / SOCIAL MEDIA | 72% | ||||
| 16 | (NET) WOM / OVERHEARD | 80% | Saw it on an online tobacco retailer website | 44% | ||||
| 17 | Recommended by friends or family | 53% | Went to a brand's website | 44% | ||||
| 18 | Heard about it from an adult tobacco/nicotine consumer | 45% | Saw a brand's social media post or went to their social media page | 40% | ||||
| 19 | Saw an adult tobacco/nicotine consumer using it | 56% | Read about it when doing an online search | 39% | ||||
| 20 | Saw in news article or clip | 32% | Saw an adult tobacco/nicotine consumer post about it on social media | 38% | ||||
| 21 | (NET) BRAND MARKETING | 60% | (NET) ADVERTISEMENT | 66% | ||||
| 22 | Received something in the mail from the brand (flyer, leaflet, etc.) | 35% | Saw an ad in a magazine | 40% | ||||
| 23 | Received an email from the brand | 42% | Saw an ad online (banner, pop-up) | 40% | ||||
| 24 | Received a text message from the brand | 33% | Saw an ad on TV or video streaming service | 36% | ||||
| 25 | (NET) PROMOTIONAL | 54% | Heard an ad when listening to the radio, streaming music, or a podcast | 35% | ||||
| 26 | Used paper coupon for the brand | 23% | Saw the brand advertised at an event/concert | 31% | ||||
| 27 | Used mobile coupon for the brand | 36% | (NET) BRAND MARKETING | 60% | ||||
| 28 | Participated in the brand's loyalty or subscription program | 35% | Received an email from the brand | 42% | ||||
| 29 | (NET) ONLINE / SOCIAL MEDIA | 72% | Received something in the mail from the brand (flyer, leaflet, etc.) | 35% | ||||
| 30 | Saw it on an online tobacco retailer website | 44% | Received a text message from the brand | 33% | ||||
| 31 | Read about it when doing an online search | 39% | (NET) PROMOTIONAL | 54% | ||||
| 32 | Went to a brand's website | 44% | Used mobile coupon for the brand | 36% | ||||
| 33 | Saw a brand's social media post or went to their social media page | 40% | Participated in the brand's loyalty or subscription program | 35% | ||||
| 34 | Saw an adult tobacco/nicotine consumer post about it on social media | 38% | Used paper coupon for the brand | 23% | ||||
Sheet1 | ||||||||
| Cells with Conditional Formatting | ||||
|---|---|---|---|---|
| Cell | Condition | Cell Format | Stop If True | |
| B3:B34 | Cell Value | contains "(NET)" | text | NO |
| F3:F34 | Cell Value | contains "(NET)" | text | NO |
