Hi Experts,
I would like to get multiple values from multiple rows & multiple columns. I try to get multiple values from Vlookup but it will work only with one column. Even same with Hlookup, I can get multiple value from Hlookup but only with single row. I would like to get multiple values with multiple rows & multiple columns.
I have more than 1000 employees monthly data which gives "P" Present, "A" Absent, "L" Late, "H" Holiday against each date of month. All these data i have on one sheet. On another sheet i have all list of employees and three more column represent "Absent", "Late", "Holiday", now i would like to see on which date such employee was "Absent", "Late", "Holiday".
for example :
A B C D E F
EMP CODE NAME DESG ABSENT LATE HOLIDAY
100001 X OFFICER 2,8,19 17,22,29 15,30
100002 Y SUPERVISOR 6,24 10,15,17,20 26
100003 Z OFFICER 4 11,27 10,19
I try so many ways, but not success, please assist to solve this problem.
Bookmarks