I have a table of attendance which look like this,
Name | Date | Time |
abc | 12/3/2018 | 12:36:11 PM |
abc | 12/3/2018 | 08:30:11 PM |
EFG | 13/3/2018 | 09:35:11 PM |
EFG | 13/3/2018 | 06:23:11 PM |
EFG | 13/3/2018 | 9:36:11 PM |
abc | 14/3/2018 | 11:36:11 PM |
GHT | 14/3/2018 | 3:36:11 PM |
GHT | 14/3/2018 | 01:36:11 PM |
abc | 15/3/2018 | 10:36:11 PM |
What I am trying to do is something like this: get the name and the date (if both duplicates) and, if the name and the date same, need to get the different time to a new cell.
Name | Date | Time | new cell | new cell |
abc | 12/3/2018 | 12:36:11 PM | 08:30:11 PM |
EFG | 13/3/2018 | 09:35:11 PM | 06:23:11 PM | 9:36:11 PM |
abc | 14/3/2018 | 11:36:11 PM |
GHT | 14/3/2018 | 3:36:11 PM | 01:36:11 PM |
abc | 15/3/2018 | 10:36:11 PM |
So far I tried merge two rows in excel worksheet where one cell has same content but other cells have different content have different content which is the only solution I came close.
and also tried to export it to Access and write a SQL query to get the above result. How can I achieve this?
D2=IF(A3=A2,C3,"")
E2=IF(AND(A4=A2,D2<>""),C4,"")
F2=IF(AND(A5=A2,E2<>""),C5,"")
and so on...