• 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

    Counting Rows to Max Value

    Thanks Marc. I knew it had to be something easy but the brain was not working today. I appreciate your time.
  2. G

    Counting Rows to Max Value

    Suppose you have rows of data and want to find out when the max value was achieved within a range like below. This data could be historical stock prices as an example. So, I know on Day 1 the price was 2.14. I want to put a formula in the next column to calculate the number of days I'd have...
  3. G

    Formula Differences

    I've always used the Quartile formula for calculation quartiles on a set of numbers. Then someone gave me a quartile formula using a MATCH function. As you can see on the attached document, columns D and E yield different results. I'm not sure how the formulas in column D (using MATCH) result...
  4. G

    Combining Rows of Data

    I would have never figured that out. Many thanks.
  5. G

    Combining Rows of Data

    I get a file every month with several tabs and varying amounts of addresses. I'm looking to simplify or automate a copy/paste process. Each sheet could contain up to 90000 records. My sample file uses random numbers for each region. I would like to take the data from each worksheet and make...
  6. G

    Spell check on protected cells

    Great reference...many thanks Luke.
  7. G

    Spell check on protected cells

    I have a spreadsheet with protected cells and areas where I need users to input data. Once I lock the spreadsheet to protect the cells, users cannot run spellcheck on their work to the areas where data is permitted to be entered. Is there a non-macro way in which spellcheck can be activated in...
  8. G

    Throw out the high and low

    Thank you too Nick M for the tip with LARGE and SMALL. Happy Holidays!
  9. G

    Throw out the high and low

    Yes, that nearly got me there. I tweaked the denominator slightly to account for a varied range. =(SUM(A1:A15)-MAX(A1:A15)-MIN(A1:A15))/(COUNT(A1:A15)-2) Thanks your time! Grumpus
  10. G

    Throw out the high and low

    I know how to calculate the average of a range of numbers but what I want to do is to take that range but exclude the "high" (MAX) and "low" (MIN) from the calculation. Is there a formula that can do that without having to use the MAX and MIN formulas to identify those values and then manually...
  11. G

    Breaking address field

    Nick! You da man! This is genius...I thought I was going to have to use text to columns and then reassemble the fields. A tedious process. Thanks again for taking the time to develop this slick solution. Grumpus
  12. G

    Breaking address field

    I have a column of addresses that may or may not end in an apartment number, suite number, or unit number. I need to break that field into 2 fields one with the address and the second column that extracts the apartment, suite, or unit #. What would be the best approach to accomplish this...
  13. G

    Raffle Entries

    Thank you so much for your help! This works great. I'll just update the formulas in Columns C, I and J to expand to the proper rows based upon the number of people in Column A because I can envision having a 100 participants or more. The red-shadowed area is an error and is why I wanted to...
  14. G

    Raffle Entries

    Thanks SirJB7 for taking a stab at it. I'm not sure I understand how that would apply to what I was looking to do. It may do so but I would need further explanation. I uploaded a quick version of how I might envision it to look. I was hoping through the magic of excel formulas to simplify...
  15. G

    Raffle Entries

    I want to set up a contest raffle that awards more chances for those that get the correct response to a question earlier than others. For example, the contest is open for 10 days...those who respond correctly the first day would get 10 chances/entries in a random draw, those responding...
  16. G

    Bubbles - Auto Labeling

    Perfect! Many thanks.
  17. G

    Bubbles - Auto Labeling

    I'm trying to figure out how to automate the process of labeling the bubbles in the chart link below. Since actual titles may be too long, just putting the numbers from A7:A16 would suffice. Any insight is most appreciated. Thanks in advance for your time. Grumpus...
  18. G

    Related Cells

    Thanks Luke and mercatog! I tried opening a new file and started anew and then it worked...must have been some conflict somewhere in the file because I was copying and pasting the formula. Much appreciated!
  19. G

    Related Cells

    I tried this with cells A2:B2 empty and then tried to enter a number into either of those two cells and received an error message, "The value you entered is not valid. A user has restricted the values that can be entered into this cell." I'm using Excel 2007 and tried both the COUNTA and the...
  20. G

    Related Cells

    This one should be easy to explain but I have not figured out the solution. So I'm back climbing the Chandoo mountain seeking the advice of the wise sages who live atop it. I have 2 cells, for simplicity A2 and B2. These cells are related to each other in that if there is a value is entered...
  21. G

    Unlocking Form Control

    Oh, I was confused about the validation set versus the drop down box. Thanks for your assistance, mucha appreciated! Mike
  22. G

    Unlocking Form Control

    Should I not be able to right click the box in H4 so I can size it in a similiar manner to the sample up in L2? How do I edit the box in G24 so that I can sort that 2nd table on the choices in C25:g25? Currently it is based upon the C5:H5 selections. Hope this helps! Mike
  23. G

    Unlocking Form Control

    I have taken one of the incell panel charts as a template and have been modifying it to suit my needs...everything working except, I cannot get the form control in cell H4 to unlock so I can better format it. Additionally, I want to essentially copy and paste it through several categories like...
  24. G

    Inserting Symbols in Formula

    I am learning so much on this forum and am creating more complex formulas based upon this new knowledge. Changing the formatting never occured to me. Thanks so much for helping me solve this so quickly! Mike
  25. G

    Inserting Symbols in Formula

    I am working with Excel 2007 and am befuddled as to why this formula won't work: =IF($N$5=2,CHAR(232),"") Char (232) is supposed to be a bold right pointing arrow as noted on the insert symbol wingdings screen. However, when the statement is TRUE it shows this as a result of the TRUE...
Back
Top