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...
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...
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...
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...
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
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...
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
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...
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...
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...
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...
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...
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!
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...
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...
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
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...
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
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...