Vishaal
Well-known Member
- Joined
- Mar 16, 2019
- Messages
- 533
- Office Version
- 2010
- 2007
- Platform
- Windows
- Web
Thanks in Advance,
we have the following sheet
Excel 2010 32 bit
We want to following result
Excel 2010 32 bit
in this result, we have checked
1. A3 value in B3 to last row
2. A6 value in B6 to last row
3. A10 value in B10 to last row
4. Any value (name or numerical) anywhere in column we put it start search in column B (same row) and highlight the cell
Pls provide any code or vba or formula
we have the following sheet
Excel 2010 32 bit
A | B | C | |
---|---|---|---|
1 | |||
2 | Emma | ||
3 | Olivia | ||
4 | Charlotte | ||
5 | Harper | ||
6 | Scarlet | ||
7 | Charlotte | ||
8 | Ava | ||
9 | Mia | ||
10 | Scarlet | ||
11 | Ava | ||
12 | Charlotte | ||
13 | Olivia | ||
14 |
Sheet: Sheet1 |
We want to following result
Excel 2010 32 bit
A | B | C | |
---|---|---|---|
1 | |||
2 | Emma | ||
3 | Harper, Isabella | Olivia | |
4 | Charlotte | ||
5 | Harper | ||
6 | Isabella, Mia | Scarlet | |
7 | Charlotte | ||
8 | Ava | ||
9 | Mia | ||
10 | Ava, Amelia | Scarlet | |
11 | Ava | ||
12 | Charlotte | ||
13 | Olivia | ||
14 |
Sheet: Sheet1 |
in this result, we have checked
1. A3 value in B3 to last row
2. A6 value in B6 to last row
3. A10 value in B10 to last row
4. Any value (name or numerical) anywhere in column we put it start search in column B (same row) and highlight the cell
Pls provide any code or vba or formula