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

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 mandeepbal...@gmail.com wrote: Check the *result sheet* in the attachment . for single single row this formula will work with helper column. On Saturday,

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 mandeepbal...@gmail.com 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

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 will00...@gmail.com wrote: Gosh l like this method thanks a lot. This is the best l have seen most

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

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-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

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 will00...@gmail.com 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

$$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)

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

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 sahe...@gmail.com 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

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 mandeepbal...@gmail.com wrote: Check this attachment achieved with a macro. Change your numbers combination as per your requirement. Regards, MandeepBaluja Learningzmypassion.

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 mandee...@gmail.com javascript: wrote: Check this attachment achieved with

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 rockerna...@gmail.com wrote: send me the

$$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)) in Excel? And