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

    Animated screen shots

    Thanks Hui. Looks like theres a lot of edditing involved, but the results are very good.
  2. G

    Animated screen shots

    Hi Can any one suggest what software to use to make animated screenshots as used by chandoo in the newsletters? Thanks GreenBoy
  3. G

    Excel equivalent of Words 'Quick Parts' or Building Blocks

    Hi Bob - that looks interesting in terms of setting fonts and formats to the worksheet - I shall take a closer look and see how useful this is to me. Still looking for something that will allow me to add predefined 'boilerplate' sections which could include text and formulas etc... Thanks...
  4. G

    Excel equivalent of Words 'Quick Parts' or Building Blocks

    Hi In word I have an option to use something called quick parts which is a effectively a powerful version of the clip board in that I can store text and formatting as well as data that is relevant to the document (page numbers, authors etc.) Is there something like this in Excel? I know I...
  5. G

    How many functions do you know?

    SirJB7 - I think it has limited use, and as there is not reciprocal of it to convert Roman numerals back to decimals. Just my opinion.
  6. G

    How many functions do you know?

    Thanks for clearing that up Luke - I was starting to panic there! SirJB7 - jury is out on that one. Luke M - thanks for the list - never used DOLLAR, and I know of FV, PF and NPR - but generally never use them, so would need to refresh my memory before using them in anger - otherwise you...
  7. G

    How many functions do you know?

    Well that's encouraging as a straw poll taken of my work colleagues seemed to show most were in the 1-10 mark that they could use without thinking. My guess is that as this is an excel forum most people should know quite a few, but they are keen users of excel, where as my colleagues are just...
  8. G

    How many functions do you know?

    I was pondering the meaning of life the other day (OK I was bored), and got around eventually to listing how many Excel functions I knew, and how many I could type in without reference to the help system (e.g. could type them in off of the top of my head, including all options - eg...
  9. G

    Vlookup with multiple criteria

    Hayden - I have to say I am not sure what you are trying to do exactly, as you seem to be selecting or already have the country and state information and only need to look up the capital of the state - assuming that you don't have two capitals of the same name, in different countries or states...
Back
Top