• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. T

    Text box referencing cell won't update

    Hi all, I created a relativly simple template that will update values based on what hospitals the users pick, driven by lots of vlookup and match/index functions. The data displayed is in pretty text boxes (which references a cell; I wanted to make it look prettier with the use of text...
  2. T

    Dynamically changing pivot table print area

    I have a pivot table that expands and contracts with data. I am constantly changing print areas to accomodate all the data and to hide the report filters so it looks more like an actual report. Does anyone know how a macro that I could use that could help me: 1. Print the pivot table...
  3. T

    Highlight Axis Labels Based on Selection

    Hi, I'm working on a lot of charts that compare 40 hospital performance to each other. Of those 40 hospitals, there are about 10 regions that those hospitals can be grouped into. As I'll be presenting data to these regions separately, I'd like to highlight the relevant hospitals in each...
  4. T

    Match function or another one?

    Hi all, I just started using using the match formula along with index formula and am enjoying how powerful it is. I am wondering if you could help me figure out if there's another function that would better suited for my need. I'm trying to figure out what percentile a value belongs in...
  5. T

    Any fans of Walkenbach 2003 Charts out there?

    In chapter 7 of his 'Excel Charts' book from 2003, he has a section on creating a dynamic chart where the series plotted depends on the location of the Active Cell in the worksheet. In the new edition of this book, 'Excel 2007 Charts', his Table of Contents is very similar, but this section of...
  6. T

    Referencing range with column heading

    I am trying to calculate the average age of a group of patients under the column heading of Age. Is there anyway to calculate it as to point out the column heading title instead of the referencing the column range reference. Also, the age range can vary as well (meaning, sometimes, there's 30...
  7. T

    Skip logic based on cell entry

    Hi all, I am trying to design a 10 page form in excel and am hobbling through it because I know Access is a better way to go about doing this...Anyway, I'm using Excel due to accessibility to MS Access, but I digress. To make the form flow better, is there a good way to make it skip to next...
Back
Top