On Sun, 10 Jan 2010 15:45:16 -0800, anthony alvarez wrote:
I am doing a vlookup with regard to time keeping
A B C D
ID Date Time Status
0001 01/01/2010 7:25AM IN
0002 01/01/2010 8:12AM IN
0001 01/01/2010 5:15PM OUT
0002 01/01/2010 6:45PM OUT
I want to have an out put like
Date Time IN Time OUT
01/01/2010 7:25AM 5:15PM
Can anybody help me please.. Best regards,Anthony
http://office.microsoft.com/search/r... 101172771033