Grouping cells using multiple criteria

[tazz]

Hello all,
This is for a punch clock in excel.
Using cmdIN I am able to insert a personal code ( col A ) and next to him computer’s time (col B)
Using cmdOUT I am able to insert the same things in col F(personal code) and G(computer’s time)
It is possible to bring time out next to time in (in col C) having this criteria:
1. - Identical personal code ?
2. - Last time out next to last time in ?
3. -Use only empty cell and don’t change cells for previous days.
Thank you for your help.

 

[SirJB7]

Hi, tazz!
Consider uploading a sample file (including manual examples of desired output if applicable), it'd be very useful for those who read this and might be able to help you. Thank you. Give a look at the green sticky posts at this forums main page for uploading guidelines.
Regards!

 

[tazz]

Thanks. I will upload an example file.

 

[tazz]

hello,
This is an example file for what I would like to achieve.
Thanks.

 

[Faseeh]

Hi tazz,

If i have understood correctly, please try this in Col C

=SMALL(IF(A2=$F$2:$F$7,$G$2:$G$7,FALSE),COUNTIF($A$2:A2,A2))

...Press Ctrl+Shift+Enter to execute and drag down.

Regards,

 

[tazz]

Thank you Faseeh,
This is working nice.

 

[Faseeh]

you are welcome!

 

[tazz]

This is working really nice , but I saw that this formula takes a lot of computer resources for very long columns.
Is there another way to solve this(perhaps a VBA code)?
Thank you again for your reply.

 

[Faseeh]

....but I saw that this formula takes a lot of computer resources for very long columns.
Is there another way to solve this(perhaps a VBA code)?

:D Me don't know the black magic of vba. BTW how many rows do you have?

 

[tazz]

It will be as column length.
Thanks