Re: $$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria

See attached to do as desired From: vickey Sent: Monday, September 26, 2011 10:14 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria Thanks, It worked, but there is one argument, if there are more then three

Re: $$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria

Thanks, It worked, but there is one argument, if there are more then three entries in a particular day i.e. on 1st of sept there are three diffrent times mentioned or more than that, then very first and very last time should reflects. (means in time of morning and out time of evening) I have

Re: $$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria

Dear Vicky, See attached sheet if it help to u.. Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Sun, Sep 25, 2011 at 4:03 PM, vickey wrote: > can I ge

Re: $$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria

: Deepak Pal Singh Sent: Sunday, September 25, 2011 11:09 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria Sure. :-) On Sun, Sep 25, 2011 at 9:35 PM, vickey wrote: Yes, great its working can I raise

Re: $$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria

Sure. :-) On Sun, Sep 25, 2011 at 9:35 PM, vickey wrote: > Yes, great its working can I raise more query/issues in case I face > during the operation... > > > > -- > > -- > Some important links for ex

Re: $$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria

Yes, great its working can I raise more query/issues in case I face during the operation... -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twit

Re: $$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria

5, 2011 10:32 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ vlookup for two same value in acceding > order with two Criteria > > Try this one... :-) > > On Sun, Sep 25, 2011 at 8:36 PM, dguillett1 wrote: > >> I sent a solution t

Re: $$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria

It appears that you properly understood the question. From: Deepak Pal Singh Sent: Sunday, September 25, 2011 10:32 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria Try this one... :-) On Sun, Sep 25, 2011 at 8

Re: $$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria

nday, September 25, 2011 9:40 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ vlookup for two same value in acceding > order with two Criteria > > Thanks a lot I got the idea but however I am trying somthing diffrent as > per attached forward, I have u

Re: $$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria

two same value in acceding order with two Criteria Thanks a lot I got the idea but however I am trying somthing diffrent as per attached forward, I have used your suggested code in the field, but there is problem of updation of values if I enter employee code highlited in yellow as per sample

Re: $$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria

Thanks a lot I got the idea but however I am trying somthing diffrent as per attached forward, I have used your suggested code in the field, but there is problem of updation of values if I enter employee code highlited in yellow as per sample file attached. Pleaes have a sample copy of the ide

Re: $$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria

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

Re: $$Excel-Macros$$ vlookup for two same value in acceding order with two Criteria

Just ask your vendor to publish data in your required format, he'll do it because your organization is paying him monthly maintenance... On Sun, Sep 25, 2011 at 4:03 PM, vickey wrote: > can I get values (time) of two same values in accedning order with two > Criteria. > for example I have emplo