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

    Simple question i am sure, but has been 10+ years since i have used excel.

    Hey Tony, What is the D/H for? Almost done.
  2. Montrey

    Hover Over Formatting with chart

    Chart Tool Tips look at the original data's format. So you have to make sure your data that you are using for your chart series is formatted correctly. In your example just: Change the Date column format to: [$-409]h:mm AM/PM;@
  3. Montrey

    Ignoring Empty Cells in an array-based formula (Excel 2013)

    Hey S_eden, You could do a few things. You could insert-->table. then paste your data in the table. The formulas you have in the table will automatically adjust down to the last row. or you could modify your formula that is giving you errors to =iferror(yourformulahere,average($A$1:A1)). this...
  4. Montrey

    Regression

    Stupid question but I need confirmation. Can you use a moving average of the dependent variable as an independent variable in a regression analysis? I know there is a term for this type of error but it has been several years since college. I almost positive this is a big no no mostly because...
  5. Montrey

    Using VBA to find a range of cells

    Hey Guys, I've search high and low for what I'm trying to do and can't seem to find it. I guess my main problem is that the range(s) I need to copy, can change in size. So what I'm thinking I need to find the cell where my range starts, and then find the cell where my range ends(there is...
  6. Montrey

    How to copy paste cells in such a way that only cells having values are copied

    Press the F5 button on ur keyboard. Then click the special button on the dialogue box. then select constants. then press ok. then copy and paste
  7. Montrey

    The Chandoo of SQL?

    I want to learn SQL. Since Chandoo and related blogs helped me become pretty fkin awsome in excel, is there an equivalent SQL blog /site? Chandoo's site got me so interested in Business intelligence it is now what I want to do for a living but I am having some trouble on figuring out how to...
  8. Montrey

    Dynamic array in countif formula

    Ginger, Create a dynamic named range! Press Ctrl+F3 to get to the named range manager. Then paste the following in the formula box =OFFSET(Sheet1!$B$3,,MATCH(Sheet1!$A$1,Sheet1!$C$3:$L$3,0),1,MATCH(Sheet1!$A$2,Sheet1!$C$3:$L$3,0)-MATCH(Sheet1!$A$1,Sheet1!$C$3:$L$3,0)+1) Make sure you name...
  9. Montrey

    Looks like I got the first 100%

    I confess! It took me a couple tries!
  10. Montrey

    Looks like I got the first 100%

    Don't be Jelly. I know #9 is stumping everyone. :p
  11. Montrey

    Need Help Formatting Chart Data Labels

    First,Right click one of the bars in the bar graph and for the data label type choose category name. Second set up another column with an if statement that references the first cell in the list of your category x labels. Example. =IF(ISNUMBER(F6),"",F6) Third. Drag this formula down until...
  12. Montrey

    Find a list of words in a cell

    Just want to say this is a really cool formula to extract stuff from text if you have a list of what you want to find. This is in reference to the formula posted by Chandoo and the preceding posters.
  13. Montrey

    Learning SQL. Any Great Resources?

    Hi Guys, I'm learning SQL because it is pretty much mandatory now adays. Anyone know of some great resources to help me a long the way. Most of it seems pretty straight forward. But hopefully you guys know some 'Resource Gems'. Thanks.
  14. Montrey

    Extract text string from in between two _ ?

    =MID(A1,12,LEN(A1)-20)
  15. Montrey

    Extract text string from in between two _ ?

    No problem Deb. My formula has assumptions like yours too! :) It assumes only 4 letters will be extracted and the text string always ends with "_bill.xls" If Rich informs us otherwise we can help him out. If the above assumptions I mentioned hold true. then my formula will work every time...
  16. Montrey

    Which formula will work for desired result .. pls do fast

    Guys. I think this does the same thing as Faseeh's formula. Can you tell me if this formula could be used as well? =IF(ISNUMBER(IF($B$2:$F$15<100,ROW($B$2:$B$15))),$A$2:$A$15,0)
  17. Montrey

    Extract text string from in between two _ ?

    Try this Rich. =LEFT(RIGHT(A1,13),4)
  18. Montrey

    Multiply values in row that match corresponding column

    Deleted my post :(. Glad you figured it out. Luke you are evil! :(
  19. Montrey

    Student Data Dashboard

    I think it is well done. I would have to agree some titles would be nice. Nice and clean and simple which is good. I would say get rid of the borders on the graphs to make it even more clean looking. Then make the top 2 graphs bottom axis line up. The choice of colors is nice. Nice...
  20. Montrey

    Formulas showing as values in charts

    =OFFSET(AN8:AP8,0,0,countif(AN9:AN20,"<>")),3) Try that
  21. Montrey

    select bar on graph and go to data

    Mind posting the Code Greg?
  22. Montrey

    select bar on graph and go to data

    I'm pretty sure he wants a some VBA setup.
  23. Montrey

    Vlookup and Sumproduct

    Weird. I have your exact example and I have changed the arrays in every which way and it is still working for me. For example: =SUMPRODUCT(--(E2:R2=E5:E65)*(F5:F65="Yes")) as long as the RPT List and the Yes/no List are the same size. The Horizontal array can be any size.
Back
Top