Assuming data in columns b:d and requests in cols f&g, This is an ARRAY
formula that must be entered using ctrl+shift+enter
=DAY(G2) & "
("&TEXT(MIN(IF(($B$2:$B$22=F2),($C$2:$C$22=G2)),$D$2:$D$22),"hh:mm:ss")& " | "
&TEXT(MAX(IF(($B$2:$B$22=F2),($C$2:$C$22=G2)),$D$2:$D$22),"hh:mm:ss")&")"
From: vickey
Sent: Sunday, September 25, 2011 5:33 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ vlookup for two same value in acceding order with two
Criteria
can I get values (time) of two same values in accedning order with two
Criteria. for example I have employee code / date & time
now employee code repeates two or more times in a day with diffrent times. now
what I want if I select parcticular date with particular empoyee ID then time
of that particuar date or day should reflect in acceding order in single cell.
EMPCode Date Time
5 25/09/11 09:15:30
5 25/09/11 12:30:00
5 25/09/11 18:30:45
taking above table as an example I want result in following format.
EmpCode - 5
Date - 25/09/11
25 (09:15:30 | 18:30:45)
means start time and end time for the day or date should reflect.
the idea behind is to creat a caleder for attendence with time for employee, on
the basis of data which is imported from biomatix system.
kindly help me out
vikas daiya
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
