Does Excel have the ability to auto-populate all combinations of a series of cells that meet a certain criteria, and then list each combination seperately?
I need all combinations possible of the sum of six cells' values. The sum cannot exceed 50000 and must be greater than 49700. Also all combinations must contain the two cells with different font color. Each cell is independent of each other, even when value is the same. For example, there are five cells with the value of 7600. Consider these 7600a, 7600b, 7600c, etc.
[TABLE="width: 240"]
<tbody>[TR]
[TD="width: 64, bgcolor: transparent, align: right"]13000
[/TD]
[TD="width: 64, bgcolor: transparent, align: right"]7600
[/TD]
[TD="width: 64, bgcolor: transparent, align: right"]6900
[/TD]
[TD="width: 64, bgcolor: transparent, align: right"]6200
[/TD]
[TD="width: 64, bgcolor: transparent, align: right"]5300
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]12600
[/TD]
[TD="bgcolor: transparent, align: right"]7600
[/TD]
[TD="bgcolor: transparent, align: right"]6900
[/TD]
[TD="bgcolor: transparent, align: right"]6200
[/TD]
[TD="bgcolor: transparent, align: right"]5300
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11500
[/TD]
[TD="bgcolor: transparent, align: right"]7600
[/TD]
[TD="bgcolor: transparent, align: right"]6900
[/TD]
[TD="bgcolor: transparent, align: right"]6200
[/TD]
[TD="bgcolor: transparent, align: right"]5300
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11300
[/TD]
[TD="bgcolor: transparent, align: right"]7600
[/TD]
[TD="bgcolor: transparent, align: right"]6800
[/TD]
[TD="bgcolor: transparent, align: right"]6200
[/TD]
[TD="bgcolor: transparent, align: right"]5300
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10800
[/TD]
[TD="bgcolor: transparent, align: right"]7600
[/TD]
[TD="bgcolor: transparent, align: right"]6800
[/TD]
[TD="bgcolor: transparent, align: right"]6200
[/TD]
[TD="bgcolor: transparent, align: right"]5300
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10700
[/TD]
[TD="bgcolor: transparent, align: right"]7500
[/TD]
[TD="bgcolor: transparent, align: right"]6800
[/TD]
[TD="bgcolor: transparent, align: right"]6100
[/TD]
[TD="bgcolor: transparent, align: right"]5300
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10200
[/TD]
[TD="bgcolor: transparent, align: right"]7500
[/TD]
[TD="bgcolor: transparent, align: right"]6800
[/TD]
[TD="bgcolor: transparent, align: right"]6100
[/TD]
[TD="bgcolor: transparent, align: right"]5300
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10000
[/TD]
[TD="bgcolor: transparent, align: right"]7500
[/TD]
[TD="bgcolor: transparent, align: right"]6700
[/TD]
[TD="bgcolor: transparent, align: right"]6100
[/TD]
[TD="bgcolor: transparent, align: right"]5300
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9900
[/TD]
[TD="bgcolor: transparent, align: right"]7500
[/TD]
[TD="bgcolor: transparent, align: right"]6700
[/TD]
[TD="bgcolor: transparent, align: right"]6100
[/TD]
[TD="bgcolor: transparent, align: right"]5300
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9600
[/TD]
[TD="bgcolor: transparent, align: right"]7400
[/TD]
[TD="bgcolor: transparent, align: right"]6600
[/TD]
[TD="bgcolor: transparent, align: right"]6100
[/TD]
[TD="bgcolor: transparent, align: right"]5300
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9400
[/TD]
[TD="bgcolor: transparent, align: right"]7400
[/TD]
[TD="bgcolor: transparent, align: right"]6600
[/TD]
[TD="bgcolor: transparent, align: right"]6100
[/TD]
[TD="bgcolor: transparent, align: right"]5300
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9100
[/TD]
[TD="bgcolor: transparent, align: right"]7400
[/TD]
[TD="bgcolor: transparent, align: right"]6600
[/TD]
[TD="bgcolor: transparent, align: right"]6000
[/TD]
[TD="bgcolor: transparent, align: right"]5200
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9000
[/TD]
[TD="bgcolor: transparent, align: right"]7400
[/TD]
[TD="bgcolor: transparent, align: right"]6600
[/TD]
[TD="bgcolor: transparent, align: right"]6000
[/TD]
[TD="bgcolor: transparent, align: right"]5200
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8900
[/TD]
[TD="bgcolor: transparent, align: right"]7400
[/TD]
[TD="bgcolor: transparent, align: right"]6600
[/TD]
[TD="bgcolor: transparent, align: right"]6000
[/TD]
[TD="bgcolor: transparent, align: right"]5200
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8800
[/TD]
[TD="bgcolor: transparent, align: right"]7300
[/TD]
[TD="bgcolor: transparent, align: right"]6600
[/TD]
[TD="bgcolor: transparent, align: right"]6000
[/TD]
[TD="bgcolor: transparent, align: right"]5200
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8700
[/TD]
[TD="bgcolor: transparent, align: right"]7300
[/TD]
[TD="bgcolor: transparent, align: right"]6600
[/TD]
[TD="bgcolor: transparent, align: right"]5900
[/TD]
[TD="bgcolor: transparent, align: right"]5100
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8600
[/TD]
[TD="bgcolor: transparent, align: right"]7200
[/TD]
[TD="bgcolor: transparent, align: right"]6500
[/TD]
[TD="bgcolor: transparent, align: right"]5900
[/TD]
[TD="bgcolor: transparent, align: right"]5100
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8500
[/TD]
[TD="bgcolor: transparent, align: right"]7100
[/TD]
[TD="bgcolor: transparent, align: right"]6400
[/TD]
[TD="bgcolor: transparent, align: right"]5900
[/TD]
[TD="bgcolor: transparent, align: right"]5100
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8100
[/TD]
[TD="bgcolor: transparent, align: right"]7000
[/TD]
[TD="bgcolor: transparent, align: right"]6400
[/TD]
[TD="bgcolor: transparent, align: right"]5900
[/TD]
[TD="bgcolor: transparent, align: right"]5100
[/TD]
[/TR]
</tbody>[/TABLE]
I need all combinations possible of the sum of six cells' values. The sum cannot exceed 50000 and must be greater than 49700. Also all combinations must contain the two cells with different font color. Each cell is independent of each other, even when value is the same. For example, there are five cells with the value of 7600. Consider these 7600a, 7600b, 7600c, etc.
[TABLE="width: 240"]
<tbody>[TR]
[TD="width: 64, bgcolor: transparent, align: right"]13000
[/TD]
[TD="width: 64, bgcolor: transparent, align: right"]7600
[/TD]
[TD="width: 64, bgcolor: transparent, align: right"]6900
[/TD]
[TD="width: 64, bgcolor: transparent, align: right"]6200
[/TD]
[TD="width: 64, bgcolor: transparent, align: right"]5300
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]12600
[/TD]
[TD="bgcolor: transparent, align: right"]7600
[/TD]
[TD="bgcolor: transparent, align: right"]6900
[/TD]
[TD="bgcolor: transparent, align: right"]6200
[/TD]
[TD="bgcolor: transparent, align: right"]5300
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11500
[/TD]
[TD="bgcolor: transparent, align: right"]7600
[/TD]
[TD="bgcolor: transparent, align: right"]6900
[/TD]
[TD="bgcolor: transparent, align: right"]6200
[/TD]
[TD="bgcolor: transparent, align: right"]5300
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11300
[/TD]
[TD="bgcolor: transparent, align: right"]7600
[/TD]
[TD="bgcolor: transparent, align: right"]6800
[/TD]
[TD="bgcolor: transparent, align: right"]6200
[/TD]
[TD="bgcolor: transparent, align: right"]5300
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10800
[/TD]
[TD="bgcolor: transparent, align: right"]7600
[/TD]
[TD="bgcolor: transparent, align: right"]6800
[/TD]
[TD="bgcolor: transparent, align: right"]6200
[/TD]
[TD="bgcolor: transparent, align: right"]5300
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10700
[/TD]
[TD="bgcolor: transparent, align: right"]7500
[/TD]
[TD="bgcolor: transparent, align: right"]6800
[/TD]
[TD="bgcolor: transparent, align: right"]6100
[/TD]
[TD="bgcolor: transparent, align: right"]5300
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10200
[/TD]
[TD="bgcolor: transparent, align: right"]7500
[/TD]
[TD="bgcolor: transparent, align: right"]6800
[/TD]
[TD="bgcolor: transparent, align: right"]6100
[/TD]
[TD="bgcolor: transparent, align: right"]5300
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10000
[/TD]
[TD="bgcolor: transparent, align: right"]7500
[/TD]
[TD="bgcolor: transparent, align: right"]6700
[/TD]
[TD="bgcolor: transparent, align: right"]6100
[/TD]
[TD="bgcolor: transparent, align: right"]5300
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9900
[/TD]
[TD="bgcolor: transparent, align: right"]7500
[/TD]
[TD="bgcolor: transparent, align: right"]6700
[/TD]
[TD="bgcolor: transparent, align: right"]6100
[/TD]
[TD="bgcolor: transparent, align: right"]5300
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9600
[/TD]
[TD="bgcolor: transparent, align: right"]7400
[/TD]
[TD="bgcolor: transparent, align: right"]6600
[/TD]
[TD="bgcolor: transparent, align: right"]6100
[/TD]
[TD="bgcolor: transparent, align: right"]5300
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9400
[/TD]
[TD="bgcolor: transparent, align: right"]7400
[/TD]
[TD="bgcolor: transparent, align: right"]6600
[/TD]
[TD="bgcolor: transparent, align: right"]6100
[/TD]
[TD="bgcolor: transparent, align: right"]5300
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9100
[/TD]
[TD="bgcolor: transparent, align: right"]7400
[/TD]
[TD="bgcolor: transparent, align: right"]6600
[/TD]
[TD="bgcolor: transparent, align: right"]6000
[/TD]
[TD="bgcolor: transparent, align: right"]5200
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9000
[/TD]
[TD="bgcolor: transparent, align: right"]7400
[/TD]
[TD="bgcolor: transparent, align: right"]6600
[/TD]
[TD="bgcolor: transparent, align: right"]6000
[/TD]
[TD="bgcolor: transparent, align: right"]5200
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8900
[/TD]
[TD="bgcolor: transparent, align: right"]7400
[/TD]
[TD="bgcolor: transparent, align: right"]6600
[/TD]
[TD="bgcolor: transparent, align: right"]6000
[/TD]
[TD="bgcolor: transparent, align: right"]5200
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8800
[/TD]
[TD="bgcolor: transparent, align: right"]7300
[/TD]
[TD="bgcolor: transparent, align: right"]6600
[/TD]
[TD="bgcolor: transparent, align: right"]6000
[/TD]
[TD="bgcolor: transparent, align: right"]5200
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8700
[/TD]
[TD="bgcolor: transparent, align: right"]7300
[/TD]
[TD="bgcolor: transparent, align: right"]6600
[/TD]
[TD="bgcolor: transparent, align: right"]5900
[/TD]
[TD="bgcolor: transparent, align: right"]5100
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8600
[/TD]
[TD="bgcolor: transparent, align: right"]7200
[/TD]
[TD="bgcolor: transparent, align: right"]6500
[/TD]
[TD="bgcolor: transparent, align: right"]5900
[/TD]
[TD="bgcolor: transparent, align: right"]5100
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8500
[/TD]
[TD="bgcolor: transparent, align: right"]7100
[/TD]
[TD="bgcolor: transparent, align: right"]6400
[/TD]
[TD="bgcolor: transparent, align: right"]5900
[/TD]
[TD="bgcolor: transparent, align: right"]5100
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8100
[/TD]
[TD="bgcolor: transparent, align: right"]7000
[/TD]
[TD="bgcolor: transparent, align: right"]6400
[/TD]
[TD="bgcolor: transparent, align: right"]5900
[/TD]
[TD="bgcolor: transparent, align: right"]5100
[/TD]
[/TR]
</tbody>[/TABLE]