Search results

Hi All, Tried searching existing forums with no luck. I've got a long list of every instance that a customer made a change to their account. I'm trying to create a summary showing how many people made n number of changes in a given year. For example: CHANGES IN YEAR COUNT 0...

Hi All, In this "How-To" article I learned a ton of shortcuts to make my graph creation easier: http://chandoo.org/wp/2009/10/15/dynamic-chart-data-series/ I'm getting very lazy now. Is there an easy way to always have the graph display the last 12 months of data even though the underlying...

Thanks Luke!! I was expecting some long answer involving VBA or something but this is perfect. I'm sure I will get a lot of mileage out of this one!

Hi All, I've been asked to track my employees' time in Excel using a new sheet for each week. The template/layout of all the fields on the sheet are identical week to week. My questions is this: Is there a way to have the values in new sheets I create for a new week automatically included in...

Thanks SirJB! Looks some good reading ahead for me.

Hi All, Does anyone know of any free or very inexpensive macro/automation software out there that will help me accomplish the following: 1. Log into my survey online. 2. Use the built in tools on the site to export the results into CSV 3. Import and append the day's results into my master...

Hi All, Often times when I export data from an application to an Excel sheet and go to enter formulas in the sheet it never calculates the formulas but rather displays the formula itself. I try toggling the "Display Formulas" option and it makes no difference. I ultimately have to copy and...

Thanks everyone!! Very helpful!

Ahhhhh. I think that is one piece of info I've been missing that helps tie all this together! This has been most informative but I have one more small favor to ask... As I am still not that fluent in formulas can you, in plain language, describe what your example formula is doing...

Hi Luke, This is helpful. I still am not sure of one thing: "But if we tell it to treat is as an array formula" What did you do to make it an array formula in the bottom example vs the top one? Thanks

Hi All, For whatever reason my simple mind can't understand what an array formula is compared to other formulas. Can someone give me some simple examples and also tell me the power and benefit that using array formulas have? Many thanks, Jason