sksanjeev786
Well-known Member
- Joined
- Aug 5, 2020
- Messages
- 1,004
- Office Version
- 365
- 2016
- Platform
- Windows
Hi Team
I have similar name in Column A and I need Column B data based on Column A
Below is the example E, F is my output
Regards
Sanjeev
I have similar name in Column A and I need Column B data based on Column A
Below is the example E, F is my output
Book3 | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
2 | Sanjeev | A | ||||||
3 | Sanjeev | B | Sanjeev | A | ||||
4 | Vijay | E | Sanjeev | B | ||||
5 | Sanjeev | D | Sanjeev | D | ||||
6 | Sanjeev | E | Sanjeev | E | ||||
7 | Sanjeev | F | Sanjeev | F | ||||
8 | Vijay | G | Sanjeev | M | ||||
9 | Rahul | H | ||||||
10 | Vijay | I | ||||||
11 | Vijay | J | ||||||
12 | Rahul | K | ||||||
13 | Vijay | L | ||||||
14 | Sanjeev | M | ||||||
Sheet1 |
Regards
Sanjeev