Search results

  1. S

    help with INDIRECT

    My guess is that it is beginning to treat like a date. It might be better to label the worksheets with 200901, 200902, etc. That way they can be sorted as needed and fulfill the date requirements.
  2. S

    Sum data based on month

    Howdy. Sounds like maybe a lookup table for dates might be a starting point; makes life much simpler to expand.
  3. S

    How to call a function in an addon

    If the add-on is provided by someone, perhaps even free, it may still be a protected VBA project, and so you wouldn't be able to access that add-on. Thus, if you contact the developer, ask about getting access to the whole VBA project.
  4. S

    Conditional Formatting

    Although you will want to select A2:A10 based on OP requirements. ;)
  5. S

    Values do not update

    Sometimes an inadvertent key combination can turn it off.
  6. S

    Vlookup vs. Index/Match

    Yes, I think that is what he means.
  7. S

    Vlookup vs. Index/Match

    Howdy, Ed. As noted on another thread, with my new position (since April) I don't get here often, but I occasionally miss the work in Excel. Then I sit down, and it passes... ;)
  8. S

    Conditional Sums?

    A solution from almost a year ago. Wow, the last time I was called a "kid" was about a half century ago. :D You are right, Mike. I seldom get by here with my new position (seminary president). But occasionally I miss the old crowd and peek in to see what is going on.
  9. S

    Vlookup vs. Index/Match

    Howdy. With VLOOKUP the column on the left has to be sorted for it to work properly. For INDEX/MATCH, there is no need to sort, and you can use any column to do the lookup. INDEX/MATCH is much more flexible.
  10. S

    Charts - Lining up one data series with another

    Howdy. Make that a second axis.
  11. S

    Chart with VBA

    Howdy. Check out Jon Peltier's VBA approach to charts dealing with series.
  12. S

    Help with compacting & optimization

    Howdy. A little further explanation might be in order. :)
  13. S

    Using the answer from a formula

    Well, up to three conditions. :D Anything more and then you need code.
  14. S

    Need to apply 4 conditional formatting rules.

    Howdy. For conditions above three, use VBA. Check on the forums for VBA conditional formatting.
  15. S

    Concatenating cells

    Howdy. Assume duty is in Col A and StaffNo in Col B and each starts in row 2. In Col C2, put this formula: =A2&","&B2 Copy down as appropriate. Is that what you are wanting?
  16. S

    Formatting graph column spacing

    Another reason to have your data on one (or more) worksheet, your setup on other worksheets, and your display on still other worksheets.
  17. S

    Formatting graph column spacing

    Yes, you would need to have another column for each blank space in the data. Be sure to look at the options after the chart is made, so that empty cells are not plotted (uncheck the check box to that effect). John Walkenbach has some instructions in his book,Excel Charts, chapters 7-8, that...
  18. S

    Average non-contiguous cells, ignoring zeros

    Will that eliminate the issue though, because the average is still counting number of cells? (I don't have Excel currently, so can't check).
  19. S

    Average non-contiguous cells, ignoring zeros

    Howdy. You could use an IF statement combined with COUNTIF and then use the average based on that. ________ Stobart motorsport
  20. S

    Using IF statement with GETPIVOTDATA

    That's good. But be sure everything works as you intend in several scenarios, because in some contexts, ISERR (and other error functions) can obscure future problems. (Note that ISERROR was the function used in 2000/2002/2003. Did this change with 2007?) ________ Digital scales
Top Bottom