# Mulitple Combinations in one sheet

#### RICH1980

##### New Member
Hi

I have 2 tables:

one lists loans (amount, term, type (reducing debt orlevel) –
the second list is for types of life cover amount, term,type, cost)

The maximum loans is six and I 'm looking to also limit the policies to six aswell.

I have already had some help with VBA to get all the combinations for the loans – this runshorizontally and can have a maximum of 63 combinations (this will varydepending on input) for from column "E:AGO"

If there are two loans – you would only get 3 outcome(E:S:AG) etc. but if there were 6 loans there would be 63 combinatons.

Above each combinations I have an array and this listsall the policies that meet the criteria (term and type) and this createsmultiple lists above the loan combinations.

What I would like to try and do is create combinationsfor each of the ‘policy lists’ above – if there were two loans – these possibilitieswould be:
E20:E25 / S20:S25 / AG20:AG25……but all the way to “AGO20:AGO25”

This could mean 63 different combinations.
If there are no policies that meet the criteria the rangefor that would be blank …
I need the result starting from row 45 and each combinationin a separate row as I will need to add data and formula next two each one anda gap of 3 row between each calculation as I need to add in totals.

EG
Data in range E20:E25 – combination result in E45
Data in range S20:S25 – combination result in S45
Data in range AG20:AG25 – combination result in AG45
Data in range AU20:AU25 – combination result in AU45
If the range in blank then there is no combination..

Hope this makes sense, if at all possible?

1,078,437
Messages
5,340,270
Members
399,361
Latest member
Linford

### This Week's Hot Topics

• Problem with Radio Button's format control
I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
• Last Display on userform to a Listbox
[CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
• Rename and move files to a new location
Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
• Help with True/False Formula
Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
• Clear extra characters from a provided range of cells
Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
• Help with Current and highest streaks
Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...