# Get instant live Excel expert help to learn how to find range in Excel

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

I am trying to figure out a Subtotal formula that calculates a specific range. In column "L" you will see L13 formula calculating L9-L12 which is correct but when you look at L17 it is calculating L13-L16 which is not correct...it should calculate L14-L16. How can I adjust the formula so it captures the appropriate range without having to adjust line by line?
Solved by A. L. in 11 mins
i want to know something if i enter a value in one cell. another cell should display a text starting with the value entered from a range of cell i have given
Solved by M. F. in 11 mins
I'm trying to get a cell to add up all the cells in a column range that have an "A" and then another cell to add up all the cells in the same range to add up all that have a "P".
Solved by K. J. in 22 mins
Hello. I've searched everything I can find on countifs, array formula, named ranges and cell references and I can't find out why my formula isn't working. This formula is working: =SUMPRODUCT(COUNTIFS(E7:F7,{1,2},E12:F12,"X")) I would like the array {1,2} to be pulled from a cell reference or a named range instead of having it embedded in the formula. So I tried these: =SUMPRODUCT(COUNTIFS(E7:F7,B11,E12:F12,"X")) where B11 contains {1,2} And =SUMPRODUCT(COUNTIFS(E7:F7,Weeks,E12:F12,"X")) where Weeks is a named range referencing B11 I use CSE after entering each of these to get the curly brackets. Yet neither pull back the correct results (they show a 0 when the correct formula (the first one) would pull back 2.
Solved by M. B. in 16 mins
Converting a quarter (4Q'14) into a start and end date range. So for example, 4Q'14 would become 10/1/14 - 12/31/14. Please note that the quarters in my workbook (4Q'14) are projected quarters which are x months prior or after a particular date. For example, the date 12/15/17 became the quarter 4Q'14 since the requirement was to project a date 36 months prior. I have several columns that project months prior and post a specific date across various # of months (18, 6, 24, 36 months and etc). The formula used to project these dates is: =MONTH(date(year(A2),month(A2)-18,day(A2)))/3&"Q'"&mid(year(date(year(A2),month(A2)-18,day(A2))),3,2) For each projected quarter I would change the "-18" to represent how many months post or prior to a particular date I wanted. My goal is to then convert these projected quarters to date ranges as I explained in the beginning.
Solved by Z. H. in 21 mins
I've created an excel drop down list from table with data validation so that once an item is selected from the list (starting in cell B2, it cannot be selected in the range from C2:R2) and would like to apply it to rows 3-1000
Solved by C. E. in 30 mins
Ex_20 I have been provided with this code by another Support Person but when I try to run it as a macro in an Excel App using VBA code, it fails to recognise the active sheet range. When I start the macro another window opens entitled “GO TO” which seems to suggest to me that it does not recognise the 9x9 array of cells that the macro is supposed to be working on. I will copy to the screen the complete module when I submit this query. Below is a copy of my original problem. I have a 9x9 matrix of cells (C4:K12). Some have numbers in the cells others do not and are empty. I want create a macro that will allow me to set the text format and size of text (or numbers) in those cells, and to pre-set the format of the empty cells to another style and size. I can then clearly identify where the original numbers were, and where the numbers that were subsequently added are placed. I have created to two text formats I want to use and have called them simply Large and Small in the Styles list. I have been trying to use macros to do this but have found that I need to create an “IF” function which I cannot do by recording key strokes. One needs to edit the macro code which is in VBA and have not yet fathomed out how to use it. I would send you a file of my failed attempts but as the file contains macros your site rejects it. Please can you help
Solved by E. E. in 23 mins
I have been provided with this code by another Support Person but when I try to run it as a macro in an Excel App using VBA code, it fails to recognise the active sheet range. When I start the macro another window opens entitled “GO TO” which seems to suggest to me that it does not recognise the 9x9 array of cells that the macro is supposed to be working on. I will copy to the screen the complete module when I submit this query.
Solved by G. L. in 16 mins
ex_amt I have tried your revised code and I still get the same result. A "GO TO" window opens asking for the range of the 9x9 cell group. If I enter C4:K12 in the box those cells become shaded but when I test the function of the macro, it is not working.
Solved by X. W. in 23 mins
I have a set of data that has Country, Company, Job Title, and a Count of available people. I want to return the top 3 companies with the highest count per country, per job title. I thought to use the LARGE function, but this returns the top 3 values for ALL countries/job titles. I am trying to use an IF statement within the large excel function to filter the count range based on the country/job title, but i can't seem to work out how.
Solved by F. Y. in 28 mins