Search results

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

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

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

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

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

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

Suppose I have a name in B2 and then a series of numbers in C2:M2. I have a set of data (numerical) in cells C1:C100 (some of these numbers may be duplicates). What I would like to do is set a conditional format (red) on the cells in C2:M2 should they match any of the numbers in the cells...