sksanjeev786
Well-known Member
- Joined
- Aug 5, 2020
- Messages
- 884
- Office Version
- 365
- 2016
- Platform
- Windows
Hi Team,
I have a statement with NETs and Subnet statement with Data so I need Top Net data from Column A (solution is i.e D,E) and from NET i need top 3 subnet (solution in GH)
can any one check for the logical solution.
Thanks
Sanjeev
I have a statement with NETs and Subnet statement with Data so I need Top Net data from Column A (solution is i.e D,E) and from NET i need top 3 subnet (solution in GH)
book2 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
1 | ||||||||||
2 | VEHICLE APPEAL (NET) | 40% | ||||||||
3 | For anyone/everyone | 10% | ||||||||
4 | For me/meets my needs | 1% | NET | VEHICLE APPEAL (NET) | 40% | |||||
5 | Good for family/family oriented/for families | 0% | VEHICLE APPEAL (NET) | 40% | Subnet | For young people/teenagers | 12% | |||
6 | For young people/teenagers | 12% | LED light/matrix (NET) | 22% | Subnet | For anyone/everyone | 10% | |||
7 | For successful people | 0% | VEHICLE APPEARANCE/STYLE (NET) | 10% | Subnet | Appeals to different type of people | 9% | |||
8 | Appeals to different type of people | 9% | ||||||||
9 | For businesses/business people | 0% | ||||||||
10 | Suits/matches the owner/reflects owner's image | 2% | ||||||||
11 | For active/sporty people | 0% | ||||||||
12 | For brave/courageous people/drivers | 3% | ||||||||
13 | MODERN/INNOVATIVE (NET) | 2% | ||||||||
14 | Modern/up to date/innovative | 1% | ||||||||
15 | Up to date | 0% | ||||||||
16 | Innovative | 1% | ||||||||
17 | VEHICLE APPEARANCE/STYLE (NET) | 10% | ||||||||
18 | Good/like style/stylish | 0% | ||||||||
19 | New/advanced technology | 2% | ||||||||
20 | Technology (no detail) | 2% | ||||||||
21 | Good/high technology | 2% | ||||||||
22 | Good/great performance | 1% | ||||||||
23 | SAFETY (NET) | 3% | ||||||||
24 | Auto brake/self braking system | 0% | ||||||||
25 | Safe/safety/protection | 2% | ||||||||
26 | Safety features | 0% | ||||||||
27 | LED light/matrix (NET) | 22% | ||||||||
28 | It's complete/with everything you need | 2% | ||||||||
29 | Visibility in the blind spot/blind spot detector | 4% | ||||||||
30 | Lights (no detail) | 5% | ||||||||
31 | Can connect 7 devices | 1% | ||||||||
Sheet1 |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
A2:A31,G5:G7 | Cell Value | contains "net" | text | NO |
can any one check for the logical solution.
Thanks
Sanjeev