• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

vba add condition

V

vicktor schausberger

Member
Hello everybody.
I have couple problems with this code, first the code is about to generate a list of combinations according to what number you input on B1, this is the first wrong part when I write for example 6 anyway give me also sombination of 5 number, and second I need to add a condition trying to filter and reduce the amount of combinations, I really apreciate guys if you insert a condition that IF COLUMN f MINUS COLUMN e = B3 (I want to choose the diferent) then show only the combination that match this condition.
thanks.
 

Attachments

  • combination NP two.xls
    226.5 KB · Views: 5
Hi Viktor ,

I cannot understand your requirement ; are you saying that if the input in B1 is 6 , you want the combinations of 6 numbers out of 15 , as well as the combinations of 5 numbers out of 15 ?

Where does this stop ? What about the combinations of 4 , 3 , 2 and 1 ?

Narayan
 
You must log in or register to reply here.
Back
Top