• ## Excel - Charts and Data Visualization

### Temperature Forecast Chart

by Published on 2013-03-20 05:04 AM     Number of Views: 30078

Some of the really cool charts that we can build in Excel involve the trick of combining multiple chart types together to make them happen. In this article, we’ll build one of those; a temperature chart that not only shows the forecasted high and low temperatures, but also the season highs and lows. The beauty of this chart is that it provides a lot of information, some of which essentially fades into the background until you really need it.
...
• ### Recent Forum Posts

#### Conditionally filling a table based on non-unique information from another table

Just for completeness, this would be an AND lookup:

=IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW(\$A\$1:\$A\$13)/((\$C\$1:\$C\$13="Production")*(\$D\$1:\$D\$13="Forward")),ROWS(\$1:1))),"")...

AliGW Today, 03:35 PM

#### Conditionally filling a table based on non-unique information from another table

Yep, that did it! Thank you so much, it works amazing!...

Joecam Today, 03:21 PM

#### Conditionally filling a table based on non-unique information from another table

Maybe this?

=IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW(\$A\$1:\$A\$13)/((\$C\$1:\$C\$13="Production")+(\$C\$1:\$C\$13="Something Else")),ROWS(\$1:1))),"")...

AliGW Today, 03:00 PM

#### Conditionally filling a table based on non-unique information from another table

That worked perfectly! Thank you!

What if column C had more options to choose from and I wanted to allow for multiple variables to be looked...

Joecam Today, 02:55 PM

#### Conditionally filling a table based on non-unique information from another table

And there he was, gone, with not one word of thanks for the solution offered. What happened to good manners and common courtesy, I wonder?...

AliGW Today, 02:32 PM