Re: $$Excel-Macros$$ Macro (Excel) Need data via Formula

2015-12-09 Thread mohd sadiq
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 th

Re: $$Excel-Macros$$ Macro (Excel) Need data via Formula

2015-12-09 Thread Mandeep baluja
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 RU

Re: $$Excel-Macros$$ Macro (Excel) Need data via Formula

2015-12-09 Thread mohd sadiq
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 Bal

Re: $$Excel-Macros$$ Macro (Excel) Need data via Formula

2015-12-09 Thread Mandeep Baluja
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

Re: $$Excel-Macros$$ Macro (Excel) Need data via Formula

2015-12-09 Thread Mandeep Baluja
Check this out !!! Regards, Mandeep baluja On Wednesday, December 9, 2015 at 5:22:27 PM UTC+5:30, Sadiq wrote: > > 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

Re: $$Excel-Macros$$ Macro (Excel) Need data via Formula

2015-12-09 Thread mohd sadiq
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:

Re: $$Excel-Macros$$ Macro (Excel) Need data via Formula

2015-12-09 Thread Mandeep Baluja
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 v