I have start date , end date and session ,i want to get the start and end date for each session. Expected output session 1 - start date - endate .I need to find out out how long each session took to process. I haven't used the excel very much i tried with vlookup and other function combination and still couldn't figure out. Please help me if you know how to solve this issue.
Please Login or Register to view this content.
Last edited by va_san; 06-18-2010 at 01:48 PM. Reason: Solved
Assuming your data is A2:C12 and that your dates are in ascending order (at least for each session), and the dates are grouped by session as your sample implies, then try this:
Assuming you list your sessions in E2:E4 (e.g. 1, 2, 3), then in F2 enter:
=INDEX($A$2:$A$12,MATCH(E2,$C$2:$C$12,0)) copied down.
and in G2: =LOOKUP(2,1/($C$2:$C$12=E2),$B$2:$B$12) copied down.
See attached.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Thanks a lot. The solution provided works fine.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks