Extract/copy data from a table

[razaas]

With thanks and appreciations to all contributors for providing great help here, I want solution to my problem. I need to extract/copy (to another sheet) data of all 4 columns in a row for each first entry and last exit (for each person) from the attached file.

thanks in advance

[Domski]

Did you forget to attach the file?

Dom

[somesoldiers]

nothing attached....scroll down- manage attachments

thanks

[razaas]

File has been attached, any help is highly appreciated.

thanks to all.

[Domski]

I only have Excel 2003 at work. Can you save it as an earlier version.

Dom

[razaas]

Domski,
Thanks for your effort, file in Excel 2003 attached.

Happy New Year & best wishes for the Year 2010

Regards,

[Domski]

So do you literally want the first and last date/time for each person?

Take Randy for example the earliest date/time is 08/01/2009 08:49:00 and the latest 08/05/2009 18:00:00. Are these the values that you want to extract?

Dom

[razaas]

Need to extract the info of complete row (When, Who, What, Where), first entry and last exit:

Take Randy for example the earliest date/time is 08/01/2009 08:49:00 and the latest 08/05/2009 18:00:00. Are these the values that you want to extract?

Randy's first entry and last exit on each day. Hope it makes sense.

Thanks a lot

[Domski]

The attached shows how this can be achieved.

I basically started off by extracting just the date into another column. I then copied the Who and Date columns to the Summary sheet and used Advanced Filter to create a unique list of these entries.

I then used formula to extract the information that you have asked for. All the formula that I have used are array formula and need to be confirmed initially with Ctrl+Shift+Enter, don't enter the {} yourself.

Hope it helps,

Dom

[razaas]

Domski Happy New Year,

Thanks for solution, it is almost as i wanted, the only thing need to consider is as per your solution it is showing entry records in both section EARLIEST and LATEST. I need only 1 entry reocord and 1 exit record. I think if make 2 sheets (Histact_enrty & Histact_exit) and filter data it can be achieved i guess. I am trying with my limited knowledge to fix this but would very much appreciate if you can help with it.

Thanks for this great help and appreciate very much.

[Domski]

What if someone doesn't have an entry/exit record on a particular day?

Dom