sksanjeev786
Well-known Member
- Joined
- Aug 5, 2020
- Messages
- 884
- Office Version
- 365
- 2016
- Platform
- Windows
Hi Team,
I have letters in rows 7 to 10 and I need to convert all the letters from Row 2 to Row 5 in (Row 7 to 10) and remove all unwanted letters
I have letters in rows 7 to 10 and I need to convert all the letters from Row 2 to Row 5 in (Row 7 to 10) and remove all unwanted letters
book2 | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | |||
1 | LinkedIn : Total - Q2 FY2022 | LinkedIn : Total - Q3 FY2022 | LinkedIn : Total - Q4 FY2022 | Indeed : Total - Q2 FY2022 | Indeed : Total - Q3 FY2022 | Indeed : Total - Q4 FY2022 | Facebook : Total - Q2 FY2022 | Facebook : Total - Q3 FY2022 | Facebook : Total - Q4 FY2022 | LinkedIn : Infreqent members - Q2 FY2022 | LinkedIn : Infreqent members - Q3 FY2022 | LinkedIn : Infreqent members - Q4 FY2022 | LinkedIn : Frequent members - Q2 FY2022 | LinkedIn : Frequent members - Q3 FY2022 | LinkedIn : Frequent members - Q4 FY2022 | LinkedIn : Budding careerist - Q2 FY2022 | LinkedIn : Budding careerist - Q3 FY2022 | LinkedIn : Budding careerist - Q4 FY2022 | LinkedIn : Balancing idealist - Q2 FY2022 | LinkedIn : Balancing idealist - Q3 FY2022 | LinkedIn : Balancing idealist - Q4 FY2022 | |||||||||
2 | A | B | C | D | E | F | G | H | I | M | N | O | J | K | L | P | Q | R | S | T | U | |||||||||
3 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 15 | 16 | 17 | 12 | 13 | 14 | 18 | 19 | 20 | 21 | 22 | 23 | |||||||||
4 | ||||||||||||||||||||||||||||||
5 | A | B | C | A | B | C | A | B | C | A | B | C | A | B | C | A | B | C | A | B | C | |||||||||
6 | ||||||||||||||||||||||||||||||
7 | Career Related | 30% BEGHI | 29% GHI | 31% BDEGHI | 30% GHI | 29% GHI | 30% BEGHI | 4% | 5% GI | 4% | 36% | 36% | 37% | 38% N | 40% MNO | 45% JKMNO | 14% | 26% P | 29% P | - | 43% PQR | 48% PQRT | ||||||||
8 | Professional Networking | 38% BDEFGHI | 36% DEFGHI | 37% BDEFGHI | 9% | 10% | 10% | 12% DEFI | 13% DEFI | 12% DEF | 43% | 43% | 45% KN | 43% | 42% | 46% JKMN | 17% | 30% P | 31% P | - | 53% PQR | 58% PQRT | ||||||||
9 | Job Search | 26% BGHI | 25% GHI | 26% BGHI | 46% ABCGHI | 46% ABCGHI | 49% ABCDEGHI | 6% I | 6% I | 5% | 31% | 30% | 32% | 38% MNO | 40% MNO | 42% JMNO | 11% | 27% P | 29% P | - | 36% PQR | 40% PQR | ||||||||
10 | Professional Info | 15% DEFGHI | 15% DEFGHI | 15% DEFGHI | 7% | 7% | 8% DE | 11% DEFI | 11% DEFI | 10% DEF | 19% | 19% | 19% | 25% MNO | 27% MNO | 28% JMNO | 7% | 15% P | 15% P | - | 26% PQR | 25% PQR | ||||||||
Sheet1 |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
I4 | Cell Value | contains "F" | text | NO |
J4 | Cell Value | contains "E" | text | NO |