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

    Cut and Paste weirdness

    Hi, Just thought I'd share a bit of Excel weirdness that reared its ugly head today at work. It was strange and interesting and the first time I'd ever seen this behaviour; although maybe the more experienced members are already aware of it. To demonstrate, try setting up a small table of...
  2. E

    Multiple lookups

    Assuming you're able to reorder the data then the following might help: Sort the columns in ascending order Driver 1st, License 2nd and Date 3rd. In column D put formula: =IF(AND(B2=B3, A2=A3), IF(DATE(YEAR(C2)+2, MONTH(C2), DAY(C2))<C3, "Gap", ""), "End") and fill down. It should...
  3. E

    Rolling months based on TODAY()

    Looking at the Rolling Month article and the example sheet provided (http://chandoo.org/wp/2010/04/06/rolling-months/) the months are just text strings, and not dates with formatting to show the month name only; which is why my previous solution was just to get the name of the current month...
  4. E

    creating a template from an existing table

    If you've got a lot of constant data intermixed with formulas, then perhaps the Goto Special dialog may help editing it. Press Ctrl+G then click the Special button (or press Alt+S), the dialog you get allows you to pick the kind of data you want to select. So you could use it to select all...
  5. E

    Count and Sum Simultaneously ( even in filtered rows)

    In Excel 2003 it'll show you metrics of your selected range which you can change from count to sums to min, max, average, etc... but only one figure at a time, whereas 2007/10 shows you several metrics in one go. If this is a table or report in which you want a quick summary of the data that...
  6. E

    Count and Sum Simultaneously ( even in filtered rows)

    Please could you describe what you are trying to do? The functions COUNT, COUNTA, COUNTIF, SUM, SUMIF, SUMPRODUCT are all unaffected by filters and can in various configurations used to be count or sum ranges of data. I'm not sure of what result is wanted that is a count and sum at the same...
  7. E

    Hiding rows after a check box is selected

    I know how it goes with inexperienced users not putting the right information into the right place on excel based forms. The only way you can get the rows to hide would be using a macro to respond to your checkboxes. An alternative non-macro option would be to use conditional formatting. Try...
  8. E

    Rolling months based on TODAY()

    Hi 3G, If I understand correctly you want to get the starting month of the list so your rolling list can auto-update based upon today's date. I assume the rolling portion of your list is working fine, with the switch from horizontal to vertical data. Here's a couple of ways you can convert...
Back
Top