Excel Problem (1 Viewer)

[dino259]

I have 25 numbers, I know 13 of these add up to $362,659.67. Is there a way to identify which 13 of these add up to that total?

 

[Bogeys]

Do you mean there is a formula somewhere adding 13 of the numbers to get to that total? Not sure I understand the excel question.

 

[Ned]

Yes, you need the solver add-in.

My Link

 

[Spike]

Wilked knows all.

 

[dino259]

Which 13 of these 25 numbers equals 362,659.67

[SIZE=medium]34196.09[/SIZE]

[SIZE=medium]42967.06[/SIZE]

[SIZE=medium]8506.49[/SIZE]

[SIZE=medium]35627.95[/SIZE]

[SIZE=medium]18662.34[/SIZE]

[SIZE=medium]38930.83[/SIZE]

[SIZE=medium]36801.29[/SIZE]

[SIZE=medium]38999.5[/SIZE]

[SIZE=medium]16156.54[/SIZE]

[SIZE=medium]16393.7[/SIZE]

[SIZE=medium]28744.67[/SIZE]

[SIZE=medium]9540[/SIZE]

[SIZE=medium]18131.72[/SIZE]

[SIZE=medium]20131.43[/SIZE]

[SIZE=medium]42430.15[/SIZE]

[SIZE=medium]8321.38[/SIZE]

[SIZE=medium]29313.81[/SIZE]

[SIZE=medium]17356.18[/SIZE]

[SIZE=medium]51098.38[/SIZE]

[SIZE=medium]8441.57[/SIZE]

[SIZE=medium]44547.69[/SIZE]

[SIZE=medium]17357.26[/SIZE]

[SIZE=medium]31926.23 [/SIZE]

[SIZE=medium]8941.39[/SIZE]

[SIZE=11pt]13234.33[/SIZE]

[SIZE=11pt]Thanks for any help. [/SIZE]

[SIZE=11pt]I couldn't figure out the constraints to limit it to these 25 items.[/SIZE]

 

[East Coast Bias]

Are you sure there is an answer?

 

[Maurile Tremblay]

I've never used the solver add-in, so I can't opine on whether that would work.

It wouldn't be too difficult to write a macro that would run through the roughly 5.2 million combinations of 13 numbers and tell you which ones add up to a given sum. (Assuming you know some VBA.)

Without using solver or a macro, I don't think there are any built-in functions that will do this for you.

 

[wilked]

Wilked knows all.

 

[wilked]

I've never used the solver add-in, so I can't opine on whether that would work.

It wouldn't be too difficult to write a macro that would run through the roughly 5.2 million combinations of 13 numbers and tell you which ones add up to a given sum. (Assuming you know some VBA.)

Without using solver or a macro, I don't think there are any built-in functions that will do this for you.

I don't see any way to do it other than brute force via a macro

 

[East Coast Bias]

I let Solver run for an hour and it didn't get an answer.

 

[Sarnoff]

Are you sure it's 362659.57?

 

[Insein]

Even the macro would be messy and more effort than its worth. Why do you need to know this?

 

[MattFancy]

Instead of making a new thread, figured I just ask this here.

I'm working on a bar graph and want to add a diamond to the chart to show an amonut. I have no idea how to change the bar to a diamond. Right now it is showing as another bar over top of the original. I just want to show a symbol on the orignial.

 

[Nathan R. Jessep]

Instead of making a new thread, figured I just ask this here.

I'm working on a bar graph and want to add a diamond to the chart to show an amonut. I have no idea how to change the bar to a diamond. Right now it is showing as another bar over top of the original. I just want to show a symbol on the orignial.

if you're talking about changing the bar to another thing like a spike/pyramid, then just click the chart, then click one of the bars and it should highlight them all. Right-click that bar and hit "Format data series", then select Shape and choose what you want

 

[MattFancy]

Instead of making a new thread, figured I just ask this here.

I'm working on a bar graph and want to add a diamond to the chart to show an amonut. I have no idea how to change the bar to a diamond. Right now it is showing as another bar over top of the original. I just want to show a symbol on the orignial.

if you're talking about changing the bar to another thing like a spike/pyramid, then just click the chart, then click one of the bars and it should highlight them all. Right-click that bar and hit "Format data series", then select Shape and choose what you want

I figured it out. Had to change it to a Scatter Plot for that series and the just changed the marker to a diamond.

 

[Ned]

Instead of making a new thread, figured I just ask this here.

I'm working on a bar graph and want to add a diamond to the chart to show an amonut. I have no idea how to change the bar to a diamond. Right now it is showing as another bar over top of the original. I just want to show a symbol on the orignial.

Sounds like you're talking about 2 different things....

If you just want the amount of the bar, right click the bar and choose 'Add Data Labels'. You can right click the labels and choose 'Format Data Labels' to modify them.

If you just want to change the bars to look like diamonds, follow Jessep's advice.

 

[Inhiding]

NVM, i found the average button to work..

 

[tjnc09]

Very very basic excel user here. I need to find an average of how many days a certain beer will sell out in. We have kegs and will have anywhere from 2 to 6 kegs based on how much we produce. So what formula do I need to use to average the timeframe in days. Some beers have 6 kegs that need to be averaged, some have 2... i know there is probably an if then statement but i have not used those.

thanks in advance

Can you type out a simple example with rows and columns? I don't quite understand

 

[tjnc09]

I think if you have this in A1:B7 for example

keg day

6 10

2 3

2 4

6 7

6 2

6 1

In E1 and E2 type,

=AVERAGEIF($A$2:$A$7,6,$B$2:$B$7) returns 5 = (10+7+2+1)/4

=AVERAGEIF($A$2:$A$7,2,$B$2:$B$7) returns 3.5 (3+4)/2

*and change the "6" and "2" in the formula for the number of kegs you want to average. so on and so forth

 

[Inhiding]

Thanks for the responses so far. I was cleary over-thinking it.

Here is what I have:

Amber Ale: 6,8,12,10,6,7 (each # is a different keg)

Double IPA: 8, 7

IPA: 7,6,7,8,9,6

etc etc

I wanted an average of these. I was thinking that each column had to have a number in it to average it out. Looks like excel see how many have inputs and uses that for the dividing number.

 

[tjnc09]

If column A is beer names and column B is days, use same formula but type beer name in " "

=AVERAGEIF($A$2:$A$7,"Amber Ale",$B$2:$B$7) etc.

$A$2:$A$7 and $B$2:$B$7 are your ranges that will need to be changed to fit how many lines of beers you have