Hi,

I have attendence data of all the employees in sequence of swipes done on
the machine.
Eg.
Employee Number Date Time
1 - 11/29/2009 - 08:32:20
3 - 11/29/2009 - 08:37:59
9 - 11/29/2009 - 08:46:21
5 - 11/29/2009 - 08:57:59
9 - 11/29/2009 - 08:59:21
3 - 11/29/2009 - 18:37:59
9 - 11/29/2009 - 18:46:21
5 - 11/29/2009 - 18:57:59

This continues for all the days. I wish to reorganize this data in following
format for all the employees:-

Dates
Employee Number 11/29/2009 11/30/2009 12/01/2009
(all employees listed) In Out In Out In
Out
1
2
3
4
5
6

Important conditions:-

1) If there are more than two swipes on a day it should consider first swipe
for in and last for Out.
2) If there is just one swipe per day it should show as In swipe and out
must be shown as "-".

Pls. guide on this preferably using VLOOK/ MAtch.. or any other way more
suitable.

Regards,
Vaibhav

Perhaps you should FIRST check your post YESTERDAY in the .public forum
where you got answers.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"Vai_Maha" <(E-Mail Removed)> wrote in message
news:17C33B10-4B95-4FF7-98ED-(E-Mail Removed)...
> Hi,
>
> I have attendence data of all the employees in sequence of swipes done on
> the machine.
> Eg.
> Employee Number Date Time
> 1 - 11/29/2009 - 08:32:20
> 3 - 11/29/2009 - 08:37:59
> 9 - 11/29/2009 - 08:46:21
> 5 - 11/29/2009 - 08:57:59
> 9 - 11/29/2009 - 08:59:21
> 3 - 11/29/2009 - 18:37:59
> 9 - 11/29/2009 - 18:46:21
> 5 - 11/29/2009 - 18:57:59
>
> This continues for all the days. I wish to reorganize this data in
> following
> format for all the employees:-
>
> Dates
> Employee Number 11/29/2009 11/30/2009 12/01/2009
> (all employees listed) In Out In Out In
> Out
> 1
> 2
> 3
> 4
> 5
> 6
>
> Important conditions:-
>
> 1) If there are more than two swipes on a day it should consider first
> swipe
> for in and last for Out.
> 2) If there is just one swipe per day it should show as In swipe and out
> must be shown as "-".
>
> Pls. guide on this preferably using VLOOK/ MAtch.. or any other way more
> suitable.
>
> Regards,
> Vaibhav
>
>
>

Dear Don,

Thanks for your response, however I am new to these forums and not able to
trace it. Can you pls. forward me the link to the forum.

Regards,



"Don Guillett" wrote:

> Perhaps you should FIRST check your post YESTERDAY in the .public forum
> where you got answers.
>
>
> --
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> (E-Mail Removed)
> "Vai_Maha" <(E-Mail Removed)> wrote in message
> news:17C33B10-4B95-4FF7-98ED-(E-Mail Removed)...
> > Hi,
> >
> > I have attendence data of all the employees in sequence of swipes done on
> > the machine.
> > Eg.
> > Employee Number Date Time
> > 1 - 11/29/2009 - 08:32:20
> > 3 - 11/29/2009 - 08:37:59
> > 9 - 11/29/2009 - 08:46:21
> > 5 - 11/29/2009 - 08:57:59
> > 9 - 11/29/2009 - 08:59:21
> > 3 - 11/29/2009 - 18:37:59
> > 9 - 11/29/2009 - 18:46:21
> > 5 - 11/29/2009 - 18:57:59
> >
> > This continues for all the days. I wish to reorganize this data in
> > following
> > format for all the employees:-
> >
> > Dates
> > Employee Number 11/29/2009 11/30/2009 12/01/2009
> > (all employees listed) In Out In Out In
> > Out
> > 1
> > 2
> > 3
> > 4
> > 5
> > 6
> >
> > Important conditions:-
> >
> > 1) If there are more than two swipes on a day it should consider first
> > swipe
> > for in and last for Out.
> > 2) If there is just one swipe per day it should show as In swipe and out
> > must be shown as "-".
> >
> > Pls. guide on this preferably using VLOOK/ MAtch.. or any other way more
> > suitable.
> >
> > Regards,
> > Vaibhav
> >
> >
> >
>
> .
>

I sent OP original ans in .public

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"Vai_Maha" <(E-Mail Removed)> wrote in message
news:215B4398-D83B-4001-87F7-(E-Mail Removed)...
> Dear Don,
>
> Thanks for your response, however I am new to these forums and not able to
> trace it. Can you pls. forward me the link to the forum.
>
> Regards,
>
>
>
> "Don Guillett" wrote:
>
>> Perhaps you should FIRST check your post YESTERDAY in the .public forum
>> where you got answers.
>>
>>
>> --
>> Don Guillett
>> Microsoft MVP Excel
>> SalesAid Software
>> (E-Mail Removed)
>> "Vai_Maha" <(E-Mail Removed)> wrote in message
>> news:17C33B10-4B95-4FF7-98ED-(E-Mail Removed)...
>> > Hi,
>> >
>> > I have attendence data of all the employees in sequence of swipes done
>> > on
>> > the machine.
>> > Eg.
>> > Employee Number Date Time
>> > 1 - 11/29/2009 - 08:32:20
>> > 3 - 11/29/2009 - 08:37:59
>> > 9 - 11/29/2009 - 08:46:21
>> > 5 - 11/29/2009 - 08:57:59
>> > 9 - 11/29/2009 - 08:59:21
>> > 3 - 11/29/2009 - 18:37:59
>> > 9 - 11/29/2009 - 18:46:21
>> > 5 - 11/29/2009 - 18:57:59
>> >
>> > This continues for all the days. I wish to reorganize this data in
>> > following
>> > format for all the employees:-
>> >
>> > Dates
>> > Employee Number 11/29/2009 11/30/2009 12/01/2009
>> > (all employees listed) In Out In Out In
>> > Out
>> > 1
>> > 2
>> > 3
>> > 4
>> > 5
>> > 6
>> >
>> > Important conditions:-
>> >
>> > 1) If there are more than two swipes on a day it should consider first
>> > swipe
>> > for in and last for Out.
>> > 2) If there is just one swipe per day it should show as In swipe and
>> > out
>> > must be shown as "-".
>> >
>> > Pls. guide on this preferably using VLOOK/ MAtch.. or any other way
>> > more
>> > suitable.
>> >
>> > Regards,
>> > Vaibhav
>> >
>> >
>> >
>>
>> .
>>