Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group
or >> bypassing any security >> >> > measure. >> >> > 4) Acknowledge the responses you receive, good or >> bad. >> >> > 5) Jobs posting is not allowed. >> >> > 6) Sharing copyrighted material and their links is not >> allowed. >> >> > >> >> > NOTE : Don't ever post confidential data in a >> workbook. Forum owners and >> >> > members are not responsible for any loss. >> >> > --- >> >> > You received this message because you are subscribed to >> the Google Groups >> >> > "MS EXCEL AND VBA MACROS" group. >> >> > To unsubscribe from this group and stop receiving >> emails from it, send an >> >> > email to excel-macros+unsubscribe@ >> googlegroups.com. >> >> > To post to this group, send email to excel-...@googlegroups.com. >> >> > Visit this group at https://groups.google.com/ >> group/excel-macros. >> >> > For more options, visit https://groups.google.com/d/ >> optout. >> >> > >> >> >> >> >> >> -- >> >> Thanks >> >> >> >> N.MADHAN >> >> >> >> -- >> >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you >> wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official >> Facebook page of this forum @ https://www.facebook.com/ >> discussexcel >> >> >> >> FORUM RULES >> >> >> >> 1) Use concise, accurate thread titles. Poor thread titles, >> like Please Help, Urgent, Need Help, Formula Problem, Code >> Problem, and Need Advice will not get quick attention or may >> not be answered. >> >> 2) Don't post a question in the thread of another >> member. >> >> 3) Don't post questions regarding breaking or bypassing >> any security measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Jobs posting is not allowed. >> >> 6) Sharing copyrighted material and their links is not >> allowed. >> >> >> >> NOTE : Don't ever post confidential data in a >> workbook. Forum owners and members are not responsible for >> any loss. >> >> --- >> >> You received this message because you are subscribed to the >> Google Groups "MS EXCEL AND VBA MACROS" group. >> >> To unsubscribe from this group and stop receiving emails >> from it, send an email to excel-macros+unsubscribe@ >> googlegroups.com. >> >> To post to this group, send email to excel-...@googlegroups.com. >> >> Visit this group at https://groups.google.com/ >> group/excel-macros. >> >> For more options, visit https://groups.google.com/d/ >> optout. >> >> >> >> >> >> >> -- >> >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you >> wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official >> Facebook page of this forum @ https://www.facebook.com/discussexcel >> >> >> >> FORUM RULES >> >> >> >> 1) Use concise, accurate thread titles. Poor thread titles, >> like Please Help, Urgent, Need Help, Formula Problem, Code >> Problem, and Need Advice will not get quick attention or may >> not be answered. >> >> 2) Don't post a question in the thread of another >> member. >> >> 3) Don't post questions regarding breaking or bypassing >> any security measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Jobs posting is not allowed. >> >> 6) Sharing copyrighted material and their links is not >> allowed. >> >> >> >> NOTE : Don't ever post confidential data in a workbook. >> Forum owners and members are not responsible for any >> loss. >> >> --- >> >> You received this message because you are subscribed to the >> Google Groups "MS EXCEL AND VBA MACROS" group. >> >> To unsubscribe from this group and stop receiving emails >> from it, send an email to excel-macros...@googlegroups.com. >> >> To post to this group, send email to excel-...@googlegroups.com. >> >> Visit this group at https://groups.google.com/group/excel-macros. >> >> For more options, visit https://groups.google.com/d/optout. >> ** Institutii feudale din tarile Romane. Dictionar coordonator Ovid >> Sachelarie
Re: $$Excel-Macros$$ Re: Need to Put Day / Interval wise Staffing
very bad On Tue, Mar 21, 2017 at 6:19 PM, Mohd Sadiq wrote: > not getting anything ... > > On Mon, Mar 20, 2017 at 8:51 PM, Mohd Sadiq > wrote: > >> Dear Pankaj - Pls help on the same >> >> On Fri, Mar 17, 2017 at 4:34 AM, Mohd Sadiq >> wrote: >> >>> Pls help .. >>> >>> Regards, >>> >>> Mohd Sadiq >>> >>> On Mar 14, 2017 6:30 PM, "Mohd Sadiq" wrote: >>> >>>> Dear All, >>>> >>>> >>>> >>>> I’ m not able to put Day / interval wise staffing off Night Shift, When >>>> I’m trying to put same formula which I used for Normal shift then I’m >>>> getting anything. >>>> >>>> >>>> >>>> Request you to please look into this and pls help on the same. >>>> >>>> >>>> >>>> >>>> >>>> >>>> Regards >>>> Mohd Sadiq >>>> 979223 >>>> >>> -- >>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>> https://www.facebook.com/discussexcel >>> >>> FORUM RULES >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> 2) Don't post a question in the thread of another member. >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> 4) Acknowledge the responses you receive, good or bad. >>> 5) Jobs posting is not allowed. >>> 6) Sharing copyrighted material and their links is not allowed. >>> >>> NOTE : Don't ever post confidential data in a workbook. Forum owners and >>> members are not responsible for any loss. >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "MS EXCEL AND VBA MACROS" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to excel-macros+unsubscr...@googlegroups.com. >>> To post to this group, send email to excel-macros@googlegroups.com. >>> Visit this group at https://groups.google.com/group/excel-macros. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> >> >> -- >> >> >> >> Regards >> Mohd Sadiq >> 979223 >> > > > > -- > > > > Regards > Mohd Sadiq > 979223 > -- Regards Mohd Sadiq 979223 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Re: Need to Put Day / Interval wise Staffing
not getting anything ... On Mon, Mar 20, 2017 at 8:51 PM, Mohd Sadiq wrote: > Dear Pankaj - Pls help on the same > > On Fri, Mar 17, 2017 at 4:34 AM, Mohd Sadiq > wrote: > >> Pls help .. >> >> Regards, >> >> Mohd Sadiq >> >> On Mar 14, 2017 6:30 PM, "Mohd Sadiq" wrote: >> >>> Dear All, >>> >>> >>> >>> I’ m not able to put Day / interval wise staffing off Night Shift, When >>> I’m trying to put same formula which I used for Normal shift then I’m >>> getting anything. >>> >>> >>> >>> Request you to please look into this and pls help on the same. >>> >>> >>> >>> >>> >>> >>> Regards >>> Mohd Sadiq >>> 979223 >>> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros+unsubscr...@googlegroups.com. >> To post to this group, send email to excel-macros@googlegroups.com. >> Visit this group at https://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/d/optout. >> > > > > -- > > > > Regards > Mohd Sadiq > 979223 > -- Regards Mohd Sadiq 979223 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Re: Need to Put Day / Interval wise Staffing
Dear Pankaj - Pls help on the same On Fri, Mar 17, 2017 at 4:34 AM, Mohd Sadiq wrote: > Pls help .. > > Regards, > > Mohd Sadiq > > On Mar 14, 2017 6:30 PM, "Mohd Sadiq" wrote: > >> Dear All, >> >> >> >> I’ m not able to put Day / interval wise staffing off Night Shift, When >> I’m trying to put same formula which I used for Normal shift then I’m >> getting anything. >> >> >> >> Request you to please look into this and pls help on the same. >> >> >> >> >> >> >> Regards >> Mohd Sadiq >> 979223 >> > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at https://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Regards Mohd Sadiq 979223 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Re: Need to Put Day / Interval wise Staffing
Pls help .. Regards, Mohd Sadiq On Mar 14, 2017 6:30 PM, "Mohd Sadiq" wrote: > Dear All, > > > > I’ m not able to put Day / interval wise staffing off Night Shift, When > I’m trying to put same formula which I used for Normal shift then I’m > getting anything. > > > > Request you to please look into this and pls help on the same. > > > > > > > Regards > Mohd Sadiq > 979223 > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Re: Fwd: Need your Help on Priority
Team , Pls try to help on this. On Fri, Mar 10, 2017 at 10:47 PM, Mohd Sadiq wrote: > Pls help team on the same > > Regards, > > Mohd Sadiq > > On Feb 28, 2017 9:22 PM, "Mohd Sadiq" wrote: > >> Hello Team , >> >> >> >> >> Hope you are doing well, >> >> >> >> Here is attached a file where I need Interval / Day wise staffing which >> is mentioned in “H” Column, I am trying it multiple times to fixed Night >> Shift issue but unfortunately I’m not getting resolution L >> >> >> >> Request you to Pls help on the same on priority. >> >> >> >> >> >> >> Regards >> Mohd Sadiq >> >> -- Regards Mohd Sadiq 979223 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Re: Fwd: Need your Help on Priority
Pls help team on the same Regards, Mohd Sadiq On Feb 28, 2017 9:22 PM, "Mohd Sadiq" wrote: > Hello Team , > > > > > Hope you are doing well, > > > > Here is attached a file where I need Interval / Day wise staffing which is > mentioned in “H” Column, I am trying it multiple times to fixed Night Shift > issue but unfortunately I’m not getting resolution L > > > > Request you to Pls help on the same on priority. > > > > > > > Regards > Mohd Sadiq > > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Fwd: Need your Help on Priority
Hello Pankaj , Pls response as I need to closed it asap. Regards, Sadiq 979223 On Wed, Mar 8, 2017 at 6:50 PM, Mohd Sadiq wrote: > Pls response ? > > On Tue, Mar 7, 2017 at 7:00 PM, Mohd Sadiq wrote: > >> Dear Pankaj , >> >> Sorry for delayed response as I was on leave. >> >> Here is attached one more resolution for the same but when I am trying to >> put same formula in another sheet then it does not working Specially when >> I'm putting in Night Shift. >> >> Pls look into this and let me know what should I do now. >> >> >> PN- Column highlighted in Yellow/Orange color. >> >> Thanks >> >> >> >> On Thu, Mar 2, 2017 at 7:46 AM, Pankaj Sharma >> wrote: >> >>> resolved >>> >>> >>> >>> *PJ * >>> >>> *MIS Analyst* >>> >>> >>> *Greater Kailash-1, New Delhi.* >>> >>> *Instagram* *pj_sharma_* >>> >>> *Tweeter* >>> *dude_sharma_pj**Facebook* >>> * www.facebook.com/pankajesica143p >>> <http://www.facebook.com/dude.pj>ankajesica143* >>> >>> >>> *We meet for a reason, either you're a blessing or a lesson...* >>> >>> On Tue, Feb 28, 2017 at 11:43 PM, Mohd Sadiq >>> wrote: >>> >>>> Here is the attached Sample Sheet, Hope u can understand when u will >>>> see it :) >>>> >>>> On Tue, Feb 28, 2017 at 11:37 PM, Mohd Sadiq >>>> wrote: >>>> >>>>> Firstly Unhide the sheet , and I need Shift wise Staffing / Present >>>>> basis of business shift which is mentioned in "A" column >>>>> >>>>> I had made Normal some / Split shift details in shared shift however I >>>>> m getting error in Night Shift when I m trying to used same formula . >>>>> >>>>> Regards, >>>>> Sadiq >>>>> 979223 <(979)%20222-2223> >>>>> >>>>> On Tue, Feb 28, 2017 at 9:52 PM, Pankaj Sharma >>>> > wrote: >>>>> >>>>>> Didn't get your query, what you want to do in this sheet, pls mention >>>>>> example with result. >>>>>> >>>>>> >>>>>> >>>>>> *PJ * >>>>>> >>>>>> *MIS Analyst* >>>>>> >>>>>> >>>>>> *Greater Kailash-1, New Delhi.* >>>>>> >>>>>> *Instagram* *pj_sharma_* >>>>>> >>>>>> *Tweeter* >>>>>> *dude_sharma_pj**Facebook** www.facebook.com/dude.pj >>>>>> <http://www.facebook.com/dude.pj>* >>>>>> >>>>>> >>>>>> *We meet for a reason, either you're a blessing or a lesson...* >>>>>> >>>>>> On Tue, Feb 28, 2017 at 9:22 PM, Mohd Sadiq >>>>>> wrote: >>>>>> >>>>>>> Hello Team , >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> Hope you are doing well, >>>>>>> >>>>>>> >>>>>>> >>>>>>> Here is attached a file where I need Interval / Day wise staffing >>>>>>> which is mentioned in “H” Column, I am trying it multiple times to fixed >>>>>>> Night Shift issue but unfortunately I’m not getting resolution L >>>>>>> >>>>>>> >>>>>>> >>>>>>> Request you to Pls help on the same on priority. >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> Regards >>>>>>> Mohd Sadiq >>>>>>> >>>>>>> -- >>>>>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>>>>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>>>>>> https://www.facebook.com/discussexcel >>>>>>> >>>>>>> FORUM RULES >>>>>>> >>>>>>> 1) Use concise, accurate thread titles. Poor thread
Re: $$Excel-Macros$$ Fwd: Need your Help on Priority
Pls response ? On Tue, Mar 7, 2017 at 7:00 PM, Mohd Sadiq wrote: > Dear Pankaj , > > Sorry for delayed response as I was on leave. > > Here is attached one more resolution for the same but when I am trying to > put same formula in another sheet then it does not working Specially when > I'm putting in Night Shift. > > Pls look into this and let me know what should I do now. > > > PN- Column highlighted in Yellow/Orange color. > > Thanks > > > > On Thu, Mar 2, 2017 at 7:46 AM, Pankaj Sharma > wrote: > >> resolved >> >> >> >> *PJ * >> >> *MIS Analyst* >> >> >> *Greater Kailash-1, New Delhi.* >> >> *Instagram* *pj_sharma_* >> >> *Tweeter* >> *dude_sharma_pj**Facebook* >> * www.facebook.com/pankajesica143p >> <http://www.facebook.com/dude.pj>ankajesica143* >> >> >> *We meet for a reason, either you're a blessing or a lesson...* >> >> On Tue, Feb 28, 2017 at 11:43 PM, Mohd Sadiq >> wrote: >> >>> Here is the attached Sample Sheet, Hope u can understand when u will >>> see it :) >>> >>> On Tue, Feb 28, 2017 at 11:37 PM, Mohd Sadiq >>> wrote: >>> >>>> Firstly Unhide the sheet , and I need Shift wise Staffing / Present >>>> basis of business shift which is mentioned in "A" column >>>> >>>> I had made Normal some / Split shift details in shared shift however I >>>> m getting error in Night Shift when I m trying to used same formula . >>>> >>>> Regards, >>>> Sadiq >>>> 979223 <(979)%20222-2223> >>>> >>>> On Tue, Feb 28, 2017 at 9:52 PM, Pankaj Sharma >>>> wrote: >>>> >>>>> Didn't get your query, what you want to do in this sheet, pls mention >>>>> example with result. >>>>> >>>>> >>>>> >>>>> *PJ * >>>>> >>>>> *MIS Analyst* >>>>> >>>>> >>>>> *Greater Kailash-1, New Delhi.* >>>>> >>>>> *Instagram* *pj_sharma_* >>>>> >>>>> *Tweeter* >>>>> *dude_sharma_pj**Facebook** www.facebook.com/dude.pj >>>>> <http://www.facebook.com/dude.pj>* >>>>> >>>>> >>>>> *We meet for a reason, either you're a blessing or a lesson...* >>>>> >>>>> On Tue, Feb 28, 2017 at 9:22 PM, Mohd Sadiq >>>>> wrote: >>>>> >>>>>> Hello Team , >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> Hope you are doing well, >>>>>> >>>>>> >>>>>> >>>>>> Here is attached a file where I need Interval / Day wise staffing >>>>>> which is mentioned in “H” Column, I am trying it multiple times to fixed >>>>>> Night Shift issue but unfortunately I’m not getting resolution L >>>>>> >>>>>> >>>>>> >>>>>> Request you to Pls help on the same on priority. >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> Regards >>>>>> Mohd Sadiq >>>>>> >>>>>> -- >>>>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>>>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>>>>> https://www.facebook.com/discussexcel >>>>>> >>>>>> FORUM RULES >>>>>> >>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like >>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need >>>>>> Advice will not get quick attention or may not be answered. >>>>>> 2) Don't post a question in the thread of another member. >>>>>> 3) Don't post questions regarding breaking or bypassing any security >>>>>> measure. >>>>>> 4) Acknowledge the responses you receive, good or bad. >>>>>> 5) Jobs posting is not allowed. >>>>>> 6) Sharing copyrighted material and their links is not
Re: $$Excel-Macros$$ Fwd: Need your Help on Priority
Firstly Unhide the sheet , and I need Shift wise Staffing / Present basis of business shift which is mentioned in "A" column I had made Normal some / Split shift details in shared shift however I m getting error in Night Shift when I m trying to used same formula . Regards, Sadiq 979223 On Tue, Feb 28, 2017 at 9:52 PM, Pankaj Sharma wrote: > Didn't get your query, what you want to do in this sheet, pls mention > example with result. > > > > *PJ * > > *MIS Analyst* > > > *Greater Kailash-1, New Delhi.* > > *Instagram* *pj_sharma_* > > *Tweeter* > *dude_sharma_pj**Facebook** www.facebook.com/dude.pj > <http://www.facebook.com/dude.pj>* > > > *We meet for a reason, either you're a blessing or a lesson...* > > On Tue, Feb 28, 2017 at 9:22 PM, Mohd Sadiq > wrote: > >> Hello Team , >> >> >> >> >> Hope you are doing well, >> >> >> >> Here is attached a file where I need Interval / Day wise staffing which >> is mentioned in “H” Column, I am trying it multiple times to fixed Night >> Shift issue but unfortunately I’m not getting resolution L >> >> >> >> Request you to Pls help on the same on priority. >> >> >> >> >> >> >> Regards >> Mohd Sadiq >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros+unsubscr...@googlegroups.com. >> To post to this group, send email to excel-macros@googlegroups.com. >> Visit this group at https://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/d/optout. >> > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at https://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Regards Mohd Sadiq 979223 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you
Re: $$Excel-Macros$$ Need help on Excel
Want to excel formula on this Regards, Mohd Sadiq On Nov 21, 2016 6:54 PM, "Paul Schreiner" wrote: > OK, I'd need a bit more information. > I can make LOTS of assumptions, but I'd rather not do this multiple times. > > So, for each row of data, you want to determine the FIRST column > containing WO and the LAST column containing WO. > > Are you wanting to use VBA or Excel functions? > > A simple function would be: > Public Function Vacation(iRange As Range, FirstFlag As Boolean) > Debug.Assert True > Dim Rng > For Each Rng In iRange > If (Rng.Value = "WO") Then > Vacation = Cells(1, Rng.Column).Value > If (FirstFlag) Then Exit For > End If > Next Rng > End Function > > To use it, you could use: > =vacation($B3:$H3,TRUE) for the first "WO" and > =vacation($B3:$H3,FALSE) for the last > > *Paul* > - > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > ----- > > > On Monday, November 21, 2016 7:43 AM, Mohd Sadiq > wrote: > > > Team , > > Pls update on this > > On Sat, Nov 19, 2016 at 2:00 AM, Mohd Sadiq > wrote: > > Team , I have data where I want to first date of "WO" and last date of > Week off in a week. > > attached is the excel sheet for your reference. > > Pls treat it on priority > > > > Regards > Mohd Sadiq > 979223 > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/ > discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscribe@ googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at https://groups.google.com/ group/excel-macros. > For more options, visit https://groups.google.com/d/ optout. > > > > > -- > > > > Regards > Mohd Sadiq > 979223 > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at https://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, For
Re: $$Excel-Macros$$ Need help on Excel
Team , Pls update on this On Sat, Nov 19, 2016 at 2:00 AM, Mohd Sadiq wrote: > Team , I have data where I want to first date of "WO" and last date of > Week off in a week. > > attached is the excel sheet for your reference. > > Pls treat it on priority > > > > Regards > Mohd Sadiq > 979223 > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at https://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Regards Mohd Sadiq 979223 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Need help on Excel
Team , I have data where I want to first date of "WO" and last date of Week off in a week. attached is the excel sheet for your reference. Pls treat it on priority Regards Mohd Sadiq 979223 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Me.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ Excel Need to Assign Weekly OFF by Formula
Dear Pankaj , Sorry for delayed response . Yet its not working. Please refer the attached mail for your reference. On Wed, Jan 13, 2016 at 7:06 PM, Pankaj Sharma wrote: > check this out !!! > > > > *PJ * > > *MIS Analyst* > > > *Greater Kailash-1, New Delhi.* > > *Instagram* *pj_sharma_* > > *Tweeter* > *dude_sharma_pj**Facebook** www.facebook.com/dude.pj > <http://www.facebook.com/dude.pj>* > > > *We meet for a reason, either you're a blessing or a lesson...* > > On Wed, Jan 13, 2016 at 6:04 PM, mohd sadiq > wrote: > >> Team , Please help to closed it on priority >> >> On Fri, Jan 8, 2016 at 2:03 PM, mohd sadiq >> wrote: >> >>> Opsss , sorry >>> >>> PFA the same. >>> >>> On Thu, Jan 7, 2016 at 7:16 PM, Pankaj Sharma >>> wrote: >>> >>>> where is the attachment. ??? >>>> >>>> >>>> >>>> *Pankaj Sharma * >>>> >>>> *MIS Analyst* >>>> >>>> *Greater Kailash-1, New Delhi* >>>> >>>> *Email * >>>> *p ankaj123...@gmail.com >>>> **Skype** pankaj.sharma_pj* >>>> >>>> >>>> >>>> >>>> On Thu, Jan 7, 2016 at 6:52 PM, mohd sadiq >>>> wrote: >>>> >>>>> Dear Pankaj , >>>>> >>>>> I have one more query on this . >>>>> >>>>> Request you to please refer the attached mail for your easy referece. >>>>> >>>>> >>>>> On Wed, Jan 6, 2016 at 9:08 PM, Pankaj Sharma >>>>> wrote: >>>>> >>>>>> it's already done i think.. pfa >>>>>> >>>>>> >>>>>> >>>>>> *Pankaj Sharma * >>>>>> >>>>>> *MIS Analyst* >>>>>> >>>>>> *Greater Kailash-1, New Delhi* >>>>>> >>>>>> *Email * >>>>>> *p ankaj123...@gmail.com >>>>>> **Skype** pankaj.sharma_pj* >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> On Wed, Jan 6, 2016 at 6:15 PM, mohd sadiq >>>>>> wrote: >>>>>> >>>>>>> Dera Team , >>>>>>> >>>>>>> Please help on the same >>>>>>> >>>>>>> On Mon, Jan 4, 2016 at 4:34 PM, mohd sadiq >>>>>>> wrote: >>>>>>> >>>>>>>> Hello Pankaj , >>>>>>>> >>>>>>>> Pls help on the same >>>>>>>> >>>>>>>> On Thu, Dec 10, 2015 at 7:01 PM, mohd sadiq >>>>>>> > wrote: >>>>>>>> >>>>>>>>> Hello , >>>>>>>>> >>>>>>>>> I need put Week OFF (WO) basis of attached excel (Day wise WO >>>>>>>>> count) (Excel attached with your reference.( if change day wise Week >>>>>>>>> OFF >>>>>>>>> count then it should be automatically changed in Roster sheet. >>>>>>>>> >>>>>>>>> Example- >>>>>>>>> >>>>>>>>> We have 20 agents in a Shift and we need to give Weekly OFF to >>>>>>>>> everyone basis of attached sheet but WO should not be repeat more >>>>>>>>> than one. >>>>>>>>> >>>>>>>>> *Sample- * >>>>>>>>> >>>>>>>>> Shift Timing-- 05:00-14:00 >>>>>>>>> Shift Count -- 20 >>>>>>>>> >>>>>>>>> We can give Weekly OFF basis of Following days count. >>>>>>>>> >>>>>>>>> Monday-3 >>>>>>>>> Tue- 3 >>>>>>>>> Wed-2 >>>>>>>>> Thu-2 >>>>>>>>> Fri-2 >>>>>>>>> Sat-3 >>>>>>>>> Sun-5 >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>
Re: $$Excel-Macros$$ Excel Need to Assign Weekly OFF by Formula
Team , Please help to closed it on priority On Fri, Jan 8, 2016 at 2:03 PM, mohd sadiq wrote: > Opsss , sorry > > PFA the same. > > On Thu, Jan 7, 2016 at 7:16 PM, Pankaj Sharma > wrote: > >> where is the attachment. ??? >> >> >> >> *Pankaj Sharma * >> >> *MIS Analyst* >> >> *Greater Kailash-1, New Delhi* >> >> *Email * >> *p ankaj123...@gmail.com >> **Skype** pankaj.sharma_pj* >> >> >> >> >> On Thu, Jan 7, 2016 at 6:52 PM, mohd sadiq >> wrote: >> >>> Dear Pankaj , >>> >>> I have one more query on this . >>> >>> Request you to please refer the attached mail for your easy referece. >>> >>> >>> On Wed, Jan 6, 2016 at 9:08 PM, Pankaj Sharma >>> wrote: >>> >>>> it's already done i think.. pfa >>>> >>>> >>>> >>>> *Pankaj Sharma * >>>> >>>> *MIS Analyst* >>>> >>>> *Greater Kailash-1, New Delhi* >>>> >>>> *Email * >>>> *p ankaj123...@gmail.com >>>> **Skype** pankaj.sharma_pj* >>>> >>>> >>>> >>>> >>>> On Wed, Jan 6, 2016 at 6:15 PM, mohd sadiq >>>> wrote: >>>> >>>>> Dera Team , >>>>> >>>>> Please help on the same >>>>> >>>>> On Mon, Jan 4, 2016 at 4:34 PM, mohd sadiq >>>>> wrote: >>>>> >>>>>> Hello Pankaj , >>>>>> >>>>>> Pls help on the same >>>>>> >>>>>> On Thu, Dec 10, 2015 at 7:01 PM, mohd sadiq >>>>>> wrote: >>>>>> >>>>>>> Hello , >>>>>>> >>>>>>> I need put Week OFF (WO) basis of attached excel (Day wise WO count) >>>>>>> (Excel attached with your reference.( if change day wise Week OFF count >>>>>>> then it should be automatically changed in Roster sheet. >>>>>>> >>>>>>> Example- >>>>>>> >>>>>>> We have 20 agents in a Shift and we need to give Weekly OFF to >>>>>>> everyone basis of attached sheet but WO should not be repeat more than >>>>>>> one. >>>>>>> >>>>>>> *Sample- * >>>>>>> >>>>>>> Shift Timing-- 05:00-14:00 >>>>>>> Shift Count -- 20 >>>>>>> >>>>>>> We can give Weekly OFF basis of Following days count. >>>>>>> >>>>>>> Monday-3 >>>>>>> Tue- 3 >>>>>>> Wed-2 >>>>>>> Thu-2 >>>>>>> Fri-2 >>>>>>> Sat-3 >>>>>>> Sun-5 >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> Regards >>>>>>> Mohd Sadiq >>>>>>> E-mail :- mohdsadiq...@gmail.com >>>>>>> >>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> Regards >>>>>> Mohd Sadiq >>>>>> contact no:- 9565809193 >>>>>> E-mail :- mohdsadiq...@gmail.com >>>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> Regards >>>>> Mohd Sadiq >>>>> contact no:- 9565809193 >>>>> E-mail :- mohdsadiq...@gmail.com >>>>> >>>>> -- >>>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>>>> https://www.facebook.com/discussexcel >>>>> >>>>> FORUM RULES >>>>> >>>>> 1) Use concise, accurate thread titles. Poor thread titles, like >>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need >>>>> Advice will not get quick attention or may not be answered. >>>>> 2) Don't post a question in the thread of another member. >>>>> 3) Don't post questions regarding breaking or bypassing any security >>>>> measure. >>>&g
Re: $$Excel-Macros$$ Excel Need to Assign Weekly OFF by Formula
Dera Team , Please help on the same On Mon, Jan 4, 2016 at 4:34 PM, mohd sadiq wrote: > Hello Pankaj , > > Pls help on the same > > On Thu, Dec 10, 2015 at 7:01 PM, mohd sadiq > wrote: > >> Hello , >> >> I need put Week OFF (WO) basis of attached excel (Day wise WO count) >> (Excel attached with your reference.( if change day wise Week OFF count >> then it should be automatically changed in Roster sheet. >> >> Example- >> >> We have 20 agents in a Shift and we need to give Weekly OFF to everyone >> basis of attached sheet but WO should not be repeat more than one. >> >> *Sample- * >> >> Shift Timing-- 05:00-14:00 >> Shift Count -- 20 >> >> We can give Weekly OFF basis of Following days count. >> >> Monday-3 >> Tue- 3 >> Wed-2 >> Thu-2 >> Fri-2 >> Sat-3 >> Sun-5 >> >> >> >> >> Regards >> Mohd Sadiq >> E-mail :- mohdsadiq...@gmail.com >> > > > > -- > Regards > Mohd Sadiq > contact no:- 9565809193 > E-mail :- mohdsadiq...@gmail.com > -- Regards Mohd Sadiq contact no:- 9565809193 E-mail :- mohdsadiq...@gmail.com -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Excel Need to Assign Weekly OFF by Formula
Hello Pankaj , Pls help on the same On Thu, Dec 10, 2015 at 7:01 PM, mohd sadiq wrote: > Hello , > > I need put Week OFF (WO) basis of attached excel (Day wise WO count) > (Excel attached with your reference.( if change day wise Week OFF count > then it should be automatically changed in Roster sheet. > > Example- > > We have 20 agents in a Shift and we need to give Weekly OFF to everyone > basis of attached sheet but WO should not be repeat more than one. > > *Sample- * > > Shift Timing-- 05:00-14:00 > Shift Count -- 20 > > We can give Weekly OFF basis of Following days count. > > Monday-3 > Tue- 3 > Wed-2 > Thu-2 > Fri-2 > Sat-3 > Sun-5 > > > > > Regards > Mohd Sadiq > E-mail :- mohdsadiq...@gmail.com > -- Regards Mohd Sadiq contact no:- 9565809193 E-mail :- mohdsadiq...@gmail.com -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Re: Introduce Yourself !!
Hello , Sadiq this side , I am from Gurgaon - India and I m part of WFM/ CCP . On Nov 27, 2015 1:43 PM, "shilpag" wrote: > Hi > This is Shilpa > > > On Saturday, June 9, 2012 at 12:51:59 AM UTC+5:30, Ayush Jain wrote: >> >> Hey all new and current posters, >> >> Welcome to excel group,one of the largest online community of excel Fans! >> >> I hope you enjoy your time here & find this forum to be a friendly and >> knowledgeable community. Please feel free to post a small introduction, a >> friendly hello or tell us a bit about yourself. Why not tell us where are >> you from, what you do, what your interests are, how old you are, which is >> your favourite excel site or blog is or anything else that comes to mind! >> >> Thanks for your time >> Ayush Jain >> Group Manager >> Microsoft MVP >> > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Excel Need to Assign Weekly OFF by Formula
Dear All , Pls help on the same. On Dec 14, 2015 3:00 PM, "mohd sadiq" wrote: > yet I am not getting solution :( > > > Rgds, Mohd Sadiq > > > On Fri, Dec 11, 2015 at 12:06 PM, mohd sadiq > wrote: > >> Dear Team , >> >> Please help on the same as i need to make it on on priority. >> >> >> Thanx >> >> >> On Thu, Dec 10, 2015 at 7:01 PM, mohd sadiq >> wrote: >> >>> Hello , >>> >>> I need put Week OFF (WO) basis of attached excel (Day wise WO count) >>> (Excel attached with your reference.( if change day wise Week OFF count >>> then it should be automatically changed in Roster sheet. >>> >>> Example- >>> >>> We have 20 agents in a Shift and we need to give Weekly OFF to everyone >>> basis of attached sheet but WO should not be repeat more than one. >>> >>> *Sample- * >>> >>> Shift Timing-- 05:00-14:00 >>> Shift Count -- 20 >>> >>> We can give Weekly OFF basis of Following days count. >>> >>> Monday-3 >>> Tue- 3 >>> Wed-2 >>> Thu-2 >>> Fri-2 >>> Sat-3 >>> Sun-5 >>> >>> >>> >>> >>> Regards >>> Mohd Sadiq >>> E-mail :- mohdsadiq...@gmail.com >>> >> >> >> >> -- >> Regards >> Mohd Sadiq >> contact no:- 9565809193 >> E-mail :- mohdsadiq...@gmail.com >> > > > > -- > Regards > Mohd Sadiq > contact no:- 9565809193 > E-mail :- mohdsadiq...@gmail.com > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Excel Need to Assign Weekly OFF by Formula
yet I am not getting solution :( Rgds, Mohd Sadiq On Fri, Dec 11, 2015 at 12:06 PM, mohd sadiq wrote: > Dear Team , > > Please help on the same as i need to make it on on priority. > > > Thanx > > > On Thu, Dec 10, 2015 at 7:01 PM, mohd sadiq > wrote: > >> Hello , >> >> I need put Week OFF (WO) basis of attached excel (Day wise WO count) >> (Excel attached with your reference.( if change day wise Week OFF count >> then it should be automatically changed in Roster sheet. >> >> Example- >> >> We have 20 agents in a Shift and we need to give Weekly OFF to everyone >> basis of attached sheet but WO should not be repeat more than one. >> >> *Sample- * >> >> Shift Timing-- 05:00-14:00 >> Shift Count -- 20 >> >> We can give Weekly OFF basis of Following days count. >> >> Monday-3 >> Tue- 3 >> Wed-2 >> Thu-2 >> Fri-2 >> Sat-3 >> Sun-5 >> >> >> >> >> Regards >> Mohd Sadiq >> E-mail :- mohdsadiq...@gmail.com >> > > > > -- > Regards > Mohd Sadiq > contact no:- 9565809193 > E-mail :- mohdsadiq...@gmail.com > -- Regards Mohd Sadiq contact no:- 9565809193 E-mail :- mohdsadiq...@gmail.com -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Excel Need to Assign Weekly OFF by Formula
Dear Team , Please help on the same as i need to make it on on priority. Thanx On Thu, Dec 10, 2015 at 7:01 PM, mohd sadiq wrote: > Hello , > > I need put Week OFF (WO) basis of attached excel (Day wise WO count) > (Excel attached with your reference.( if change day wise Week OFF count > then it should be automatically changed in Roster sheet. > > Example- > > We have 20 agents in a Shift and we need to give Weekly OFF to everyone > basis of attached sheet but WO should not be repeat more than one. > > *Sample- * > > Shift Timing-- 05:00-14:00 > Shift Count -- 20 > > We can give Weekly OFF basis of Following days count. > > Monday-3 > Tue- 3 > Wed-2 > Thu-2 > Fri-2 > Sat-3 > Sun-5 > > > > > Regards > Mohd Sadiq > E-mail :- mohdsadiq...@gmail.com > -- Regards Mohd Sadiq contact no:- 9565809193 E-mail :- mohdsadiq...@gmail.com -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Excel Need to Assign Weekly OFF by Formula
Hello , I need put Week OFF (WO) basis of attached excel (Day wise WO count) (Excel attached with your reference.( if change day wise Week OFF count then it should be automatically changed in Roster sheet. Example- We have 20 agents in a Shift and we need to give Weekly OFF to everyone basis of attached sheet but WO should not be repeat more than one. *Sample- * Shift Timing-- 05:00-14:00 Shift Count -- 20 We can give Weekly OFF basis of Following days count. Monday-3 Tue- 3 Wed-2 Thu-2 Fri-2 Sat-3 Sun-5 Regards Mohd Sadiq E-mail :- mohdsadiq...@gmail.com -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Book2.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ Macro (Excel) Need data via Formula
Good Morning Mandeep , I need put Week OFF basis of Given chart (Day wise WO count).(Excel attached for your reference ) Lets example we have 20 agents in team and we need to give Weekly off to everyone basis of decided Day wise count and WO should not be repeated within Week. Please refer the attached sheet , I am sure you will understand what I want. On Wed, Dec 9, 2015 at 11:23 PM, Mandeep baluja wrote: > Hi, > > Give us a clear explanation to what to achieve by giving some output !! > > Regards, > Mandeep baluja > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Regards Mohd Sadiq contact no:- 9565809193 E-mail :- mohdsadiq...@gmail.com -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Book2.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ Macro (Excel) Need data via Formula
Thanks a lot Mandeep for quick help . If don't mind can you pls do one more help. I have a sheet where i have given shift wise weekly off i want to assign WO in another sheet by Formula in day wise. Excel sheet attached for your easy reference. On Wed, Dec 9, 2015 at 6:20 PM, Mandeep Baluja wrote: > Check this out and let me know !!! > > Two formulas to be used !! > > Regards, > Mandeep baluja > > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Regards Mohd Sadiq contact no:- 9565809193 E-mail :- mohdsadiq...@gmail.com -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Book2.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ Macro (Excel) Need data via Formula
I did not required the count of name . I need that names in cells of given count. e.g - Name- Sadiq Count 20 I need this name in 20 times in "a" cell. On Wed, Dec 9, 2015 at 3:45 PM, Mandeep Baluja wrote: > > Check this out !! > Mandeep baluja > > > > On Wednesday, December 9, 2015 at 3:31:45 PM UTC+5:30, Sadiq wrote: >> >> Hello Team , >> >> >> >> I have a excel sheet where have Team Name in “A” column and in “B” column >> we have count. I need Team name details in another sheet with count of Team >> Name via formula. >> >> >> >> Sheet attached for your easy reference. >> >> >> >> Rgds, >> >> Mohd Sadiq >> > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Regards Mohd Sadiq contact no:- 9565809193 E-mail :- mohdsadiq...@gmail.com -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Macro (Excel) Need data via Formula
Hello Team , I have a excel sheet where have Team Name in “A” column and in “B” column we have count. I need Team name details in another sheet with count of Team Name via formula. Sheet attached for your easy reference. Rgds, Mohd Sadiq -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Book2.xlsx Description: MS-Excel 2007 spreadsheet
