Search results

I have a sumifs formula that reads criteria in each of 5 columns beside it. E14 is criteria that is common between the formulas buy a14-d14 will very...

I've got a workbook of charts in several sheets. Each sheet is the same form and has the same charts. When I make copies of my master template, the dynamic ranges I have in the chart (named ranges) become static references. I want to change the references for each chart back to the named...

Thanks Luke. But how can i reference space on a different sheet?

Hey Chandoo! I'm trying to populate a activex box with dates that i've listed down a column on a sheet called "Data". This is my first time writing a form in ActiveX, though I've coded some macros. What is wrong with what I've written? This returns Application-defined or object-defined...

I think I can figure this out quick if you attach a sample. Google Docs is good for this. Sounds like you just need a vlookup that will concatenate strings.

Thanks for the welcome and thanks for the help. You have really helped people out a lot here. I knew that it was going to be some min max function but i wasn't sure. This looks like it will work. Will look for other users to help out.

Hi Folks, I've graphing actual budgets against planned budgets. I wanted to use a dynamic range but I am having trouble defining the bounds. In this example, if I applied the dynamic range to only "actual" it would not capture the last outlier in "planned". If i applied the dynamic range to...