blackberry
New Member
- Joined
- Feb 7, 2024
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
I am new in this website and i am stuck in a situation
I have two excel sheets (Sheet1 name is "student list"). Sheet1 column A has duplicate city pin codes, Column B has unique student list against each pin codes (sheet2 name is Master pin codes"). Sheet2 column A has duplicate pin code only. I want to extract 3 student name from sheet1 to sheet2 against each duplicate pin code excluding previously students name. I am attaching the screen shot with the answer what i want in master pin codes sheet.
I have two excel sheets (Sheet1 name is "student list"). Sheet1 column A has duplicate city pin codes, Column B has unique student list against each pin codes (sheet2 name is Master pin codes"). Sheet2 column A has duplicate pin code only. I want to extract 3 student name from sheet1 to sheet2 against each duplicate pin code excluding previously students name. I am attaching the screen shot with the answer what i want in master pin codes sheet.