mart_mrexcel
Active Member
- Joined
- Aug 23, 2008
- Messages
- 296
- Office Version
- 365
- Platform
- Windows
How can i get the large number in column A where nationality is equal to India (in below, return value should be 1005
A | B | |
1 | Unique Code | Nationality |
2 | 1001 | Australian |
3 | 1002 | India |
4 | 1003 | Australian |
5 | 1004 | Canadian |
6 | 1005 | India |
7 | 1006 | Canadian |