Search results

Hi there- I have 2 "major" data categories...projected & actual. Both categories can be further broken down to Business & Technical. What I'm trying to show is Projected Business & Techincal (1 bar) for the month vs Actual Business & Technical (1 bar). I can get one set of the series to...

Looking for input on the best way to show some data. I have actual vs projected, but, now people are interested in the variance between the two. It's a standard column chart, but, I would somehow like to show the difference between the two on the same chart. Any thoughts?

fred- your solution is more the direction I was trying. I was layering Rights, Lefts, and, what not upon each other and fell down the slippery slope. Also, the nationality was indeed 3 chars (i.e. (Ger)) Thanks for the help!

Gotcha Luke! I agree. The problem I sometimes have is visualizing the "math" (i.e. Subtract the length of one word from another/etc.) and it creates a "gap" in my creativity :-).

Hello- I've been practicing some text processing with the LEN, MID, FIND, etc formulas, and, am having some problems figuring out how to break out the various data points. Data is A11:A28 and structured all in one cell as follows: Firstname Lastname (Nationality) Team I'm trying to break...

Yes! Looks great Luke & Hui. Thanks for the help. Also, thanks Fred for the suggestion too!

Is the "|" another cell, or did you want to split it IN cell? If IN cell, assume text is in B2 In B3:=FIND("CA",B2) In B4: =LEFT(B2,B3+1)&" | "&RIGHT(B2,B3+2) not sure how you can join these two formulas, but coincidentally, I was just practicing this stuff!

Hi there- I have 2 sets of data/series...Actuals & Projected. What I'm trying to do is have 1 line on the graph where Actuals show Jan-Aug, then, Projected shows Sept-Dec. For every actuals month, I've set the projected values to 0, but, at the aug/sept junction the graph spikes way up and...

Sometimes the easiest things are just easy! :)

Hi there- I have a few series that I've got on an area chart. Now, I'd like to overlay a line onto that chart. I've seen the "cooking delicious charts" lesson, but the example doesn't really explain how to merge the two chart types? Is it nothing more than overlaying (manually) one on top of...

Luke...you Ninja you! Thanks. It didn't even dawn on me. Ha! Thanks 3G

HI there- I have 5 rows of data, all using a DATEDIF formula. For some reason, there is only 1 row that throws a #NUM! error. I have double checked all formatting, and, in the formula arguements window there are no errors reported (granted it says Volatile), but, it's identical to the ones that...

Check out Chandoo's post on dynamic charts (in the Dashboard series). Just search the site for dynamic chart. I used that and was up and running in no time!

Thanks guys. I'm looking for the Week of the Max Actual where the Model = Gold. I'm only getting back the max week for Gold. I've tried just offsetting the max, but, it doesn't like it. Am I overanalyzing it?

Hello How can I find the largest value in an array? I have tried both: =INDEX(Week,MATCH((LARGE(Actual,1)),Actual),0) (Pulls back the largest value in the week column) and =LARGE(IF(Model="Gold",Week,""),1) (Always seems to pull back the largest instance of "Gold"). Any thoughts how to...

Hi there- I have a spreadsheet kept locally on my PC that references a spreadsheet that is posted on a Sharepoint site as a document, not a sharepoint list. I have located the spreadshet from the drive directly, as opposed to opening it via the site (lives on a network drive), and can reference...

Hello- This is a mutation of the killer array formula Luke helped me with in a different post. Basically, I want to pull back only the first occurence of Column A, based on the data entered in B3. When I copy down, it's pulling back multiples where they occur, when, I only want the first...

So would you do an "INDIRECT" then Hui, or, just index/match the same value twice, and, offset it by 1?

Hello- I have the following formula: =MATCH(B6,Sheet1!$B$5:$B$14,0) However, I want to pull back Column C from Sheet1 (In this case, C6). However, when I write the OFFSET, it tells me there's an error with the formula: OFFSET(MATCH(B6,Sheet1!$B$5:$B$14,0),,1) Can you use OFFSET with...

Hello- The following formula works fine, but I'm wondering if there's more than one way to skin a cat*: =INDEX(Project_Name,MATCH(MasterLOE062911!A6,ProjectNumber,0),MATCH(MasterLOE062911!$B$5,'Master Project Roadmap'!$B$2,0)) This formula looks at the Master Project Roadmap document, and...

Hi Hui- I just changed a value in the table, that is all.

Hi there- I currently have a data sheet that is supporting a pivot table. I am having an issue with the refresh portion of it. I've changed some data on the table, and, then gone ahead and refreshed the data, but, the changes are not reflected. Yet, if I create a NEW pivot table with the exact...

Original =SUMIF($D$5:$D$871,D890,L5:L871) Pasted down where the values were way off =SUMIF($D$5:$D$871,D891,L6:L872) =SUMIF($D$5:$D$871,D892,L7:L873) Working fine version (s) =SUMIF($D$5:$D$871,D890,$L$5:$L$871) =SUMIF($D$5:$D$871,D891,$L$5:$L$871) =SUMIF($D$5:$D$871,D892,$L$5:$L$871)

Hi there- I have a SUMIF that I copied down a few cells. The sum range of the first was A5:A871 (criteria range C5:C871), which I forgot to "$" to freeze. So, when I copied it down, it went from A6:A872, and, A7:A873. Cells A872 & A873 were both blank, and, the SUMIF criteria was NOT met in the...

Hello- Have 2 columns: Start Date / End Date Currently formatted as mmmm yyyy Start date is always the 1st of the month, end date is always the last day. Trying to do a datedif to get weeks. DATEDIF(A1, B1, "y")*52 Something's not working as when I copy it down to all of the other...