scenario: I have a excel sheet in below format
procode empname empno managername
1234 x 456 a
2345 y 789 b
1234 z 679 a
i want to filter the excel based on procode (let say this case 1234) and for 1234 procode i want to retrive the emp info ,and so on there are so many procodes in my excel input.for each procode i want the emp info .
Thanks and Regards,