Re: $$Excel-Macros$$ Macro for Find

2012-11-01 Thread Shrinivas Shevde
Dear Vijay File is not working Regards Shrinivas On Tue, Oct 30, 2012 at 6:31 PM, Vijay Kr. Aggarwal < vjaggarwal2...@gmail.com> wrote: > Hi Shrini, > > First sheet:- Raw Data > Second Sheet :- Criteria is given in this sheet. > third sheet :- Final output would be pasted here by using criteri

Re: $$Excel-Macros$$ Macro for Find

2012-10-30 Thread Vijay Kr. Aggarwal
Hi Shrini, First sheet:- Raw Data Second Sheet :- Criteria is given in this sheet. third sheet :- Final output would be pasted here by using criteria from second sheet. regards, Vijay On 10/30/12, Shrinivas Shevde wrote: > Dear Rajan and ANil > Sample file is already attached . > Dear Vija

Re: $$Excel-Macros$$ Macro for Find

2012-10-30 Thread Shrinivas Shevde
Dear Rajan and ANil Sample file is already attached . Dear Vijay Can u explain me the file u send Regards Shrinivas On Mon, Oct 29, 2012 at 7:27 PM, Vijay Kr. Aggarwal < vjaggarwal2...@gmail.com> wrote: > Hi Shrinivas, > > Please check attached file. I hope this will answer your query. > > rega

Re: $$Excel-Macros$$ Macro for Find

2012-10-29 Thread Vijay Kr. Aggarwal
Hi Shrinivas, Please check attached file. I hope this will answer your query. regards, Vijay On 10/27/12, Shrinivas Shevde wrote: > Dear all > > >I WANT TO WRITE A MACRO WHICH WILL ASK USER TO DEFINE HIS SEARCH Example > .-: user want to find details of " H".then macro should ask the name a

Re: $$Excel-Macros$$ Macro for find any possible combination of numbers from given numbers to a given total

2011-07-05 Thread Markkim
Thanks a lot!!! Well, I looked at the macro and its' not what I want. I thought through and came up with a following code.. ( just testing code) In this example, there are five values: 12.25, 10.3, 24.3, 23.19, 55.2 And I need to find any combination of values above which sum up to ... let's

Re: $$Excel-Macros$$ Macro for find any possible combination of numbers from given numbers to a given total

2011-07-04 Thread Markkim
Hi! siti Vi I tried to download the example workbook but no file found could you send me the file if you can please??? Thanks -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks

Re: $$Excel-Macros$$ Macro for find any possible combination of numbers from given numbers to a given total

2011-07-04 Thread Markkim
Well, I haven't tried but looks like it's exactly what I want Thanks Million -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Jo

Re: $$Excel-Macros$$ Macro for find any possible combination of numbers from given numbers to a given total

2011-07-03 Thread STDEV(i)
you are talking about *Permutation* given number : 1 2 3 4 5 total arrangement of permutation *=FACT(5)* = *120* == 12345 21345 31245 41235 51234 12354 21354 31254 41253 51243 12435 21435 31425 41325 51324 12453 21453 31452 41352 51342 12534 21534 31524 41523 51423 12543 21543 31542