Re: $$Excel-Macros$$ Re: Help with combination formula

2015-03-16 Thread Ashu k
Dear Mandeep Sir, I am big fan of yours..! Regards Ashu Kenith -- 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 ti

Re: $$Excel-Macros$$ Re: Help with combination formula

2015-03-16 Thread Mandeep baluja
Hey Will Sob it's my pleasure, Vabz I want too add you into my network as i have started learning Excel techniques and admire your logics of Macros. Regards, MandeepBaluja Learningzmypassion. https://www.facebook.com/VBAEXCELSQL?ref=hl https://www.linkedin.com/profile/view?id=312532939 On Mon

Re: $$Excel-Macros$$ Re: Help with combination formula

2015-03-16 Thread Vaibhav Joshi
Hi Mandeep, Logic used in macro is rilli cool... Cheers!! On Mon, Mar 16, 2015 at 1:46 PM, Mandeep baluja wrote: > Check the *result sheet* in the attachment . for single single row this > formula will work with helper column. > > > > > > > On Saturday, 14 March 2015 15:06:13 UTC+5:30, Will So

Re: $$Excel-Macros$$ Re: Help with combination formula

2015-03-16 Thread Vaibhav Joshi
Hey Will Check this attachment..in any of given columns it will check occurrence of 10 , 13 & 17 in any order... Hope you like it,.,. Cheers!! On Mon, Mar 16, 2015 at 5:34 PM, Will Sob wrote: > Gosh l like this method thanks a lot. This is the best l have seen most > appreciated > > On Mon,

Re: $$Excel-Macros$$ Re: Help with combination formula

2015-03-16 Thread Will Sob
Gosh l like this method thanks a lot. This is the best l have seen most appreciated On Mon, Mar 16, 2015 at 8:16 AM, Mandeep baluja wrote: > Check the *result sheet* in the attachment . for single single row this > formula will work with helper column. > > > > > > > On Saturday, 14 March 2015 15

$$Excel-Macros$$ Re: Help with combination formula

2015-03-16 Thread Mandeep baluja
Check the *result sheet* in the attachment . for single single row this formula will work with helper column. On Saturday, 14 March 2015 15:06:13 UTC+5:30, Will Sob wrote: > > Hi, > Please I need help with the attached file. I want a formula that > calculates how many times (10, 13, 17) com

Re: $$Excel-Macros$$ Re: Help with combination formula

2015-03-16 Thread Will Sob
Yes it is by macros l like your code but it just won't work On 16 Mar 2015 07:27, "Will Sob" wrote: > Thanks for responding yes in a single row. H l would like to know > about both methods of you can most appreciated > Tell me two things > > is the triplet combination your searching in single

Re: $$Excel-Macros$$ Re: Help with combination formula

2015-03-16 Thread Will Sob
Thanks for responding yes in a single row. H l would like to know about both methods of you can most appreciated Tell me two things is the triplet combination your searching in single , single row one by one it can be achievedd with concatenate but if you are trying to search the combination

Re: $$Excel-Macros$$ Re: Help with combination formula

2015-03-16 Thread Mandeep baluja
Tell me two things is the triplet combination your searching in single , single row one by one it can be achievedd with concatenate but if you are trying to search the combination triplet like the I5 contain 10 , d6 contain 13,d7 contain 17 is this countable or not . ?? On Monday, 16

Re: $$Excel-Macros$$ Re: Help with combination formula

2015-03-15 Thread Will Sob
thanks for your reply: l have loads of values, l am trying to build a template where when l place numbers it should tell me how many triplet combination exist within a range 10, 13, 17 1,19, 22 7, 21,22 On Mon, Mar 16, 2015 at 4:25 AM, Mandeep Baluja wrote: > send me the values which you are t

Re: $$Excel-Macros$$ Re: Help with combination formula

2015-03-15 Thread Mandeep Baluja
send me the values which you are trying to get On Monday, March 16, 2015 at 3:24:40 AM UTC+5:30, Will Sob wrote: > > thanks but it is not working when l use other values > > On Sun, Mar 15, 2015 at 7:11 PM, Mandeep baluja > wrote: > >> Check this attachment achieved with a macro. Change your num

Re: $$Excel-Macros$$ Re: Help with combination formula

2015-03-15 Thread Will Sob
thanks but it is not working when l use other values On Sun, Mar 15, 2015 at 7:11 PM, Mandeep baluja wrote: > Check this attachment achieved with a macro. Change your numbers > combination as per your requirement. > > Regards, > MandeepBaluja > Learningzmypassion. > https://www.facebook.com/VBA

Re: $$Excel-Macros$$ Re: Help with combination formula

2015-03-15 Thread Mandeep baluja
Check this attachment achieved with a macro. Change your numbers combination as per your requirement. Regards, MandeepBaluja Learningzmypassion. https://www.facebook.com/VBAEXCELSQL?ref=hl https://www.linkedin.com/profile/view?id=312532939 On Sunday, 15 March 2015 23:04:26 UTC+5:30, Will So

Re: $$Excel-Macros$$ Re: Help with combination formula

2015-03-15 Thread Will Sob
l'm sorry please see attachment On Sun, Mar 15, 2015 at 2:45 AM, sahemur khan wrote: > On Saturday, 14 March 2015 15:06:13 UTC+5:30, Will Sob wrote: > > Hi, > > Please I need help with the attached file. I want a formula that > calculates how many times (10, 13, 17) combination has appeared wit

$$Excel-Macros$$ Re: Help with combination formula

2015-03-14 Thread sahemur khan
On Saturday, 14 March 2015 15:06:13 UTC+5:30, Will Sob wrote: > Hi,  > Please I need help with the attached file. I want a formula that calculates > how many times (10, 13, 17) combination has appeared within the range D5:I32 > > > > > > > > > > > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) i