• 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. K

    Extract the name of a column (using VBA) from excel

    Hi I have a question re: VBA macros, and I'm not very good at them. Anyway, it is one worksheet, with vertical page breaks and each column has a heading. So cell D1 is Person D, cell E1 is Person E etc to column AU. I want to use this column name to name my pdf docs. One pdf doc per person...
  2. K

    Align text in data tables under charts

    On a chart, I know you can align text on an x or y axis in a chart, but once you insert a data table, it seems that you can only re-size the font, not align it so it stops wrapping. So you might end up with a label that continues over 2 lines splitting the words 'For Example" up as below: For...
  3. K

    Need to return text based on maximum date, but can't do this in 1 step

    Hi I am trying to simplify a process which takes me multiple steps. I'm trying to find the last position a person has held. Small Example: Person A Junior Clerk 01-Nov-09 Person A Senior Clerk 01-Dec-11 So when I use the SUMPRODUCT(MAX) formula, I retrieve...
Back
Top