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!”
Here are some problems that our users have asked and received explanations on
I need a formula to look at several rows of outputs (Column I) associated with varying identifiers, some the same and tell me, for the range of outputs for anyone unique identifier (Column C), what is the highest number associated with the collection of outputs for that unique identifiers (Column C) and that a table is generated showing that for each unique identifier, what that highest value is from Column I.
Solved by X. H. in 14 mins
I'm trying to use MATCH to a find a value in a range that is specified by cell references that are derived from other formulas. MATCH doesn't seem to let me do it. Anyone able to help?
Solved by T. A. in 30 mins
I have a pivot table created based on a range of data. Now I added 40 more rows to original cell, to refresh the pivot table, I have to reselect the new data range.
Is there any way the data range will be automatically updated after I add more rows?
Thanks for your help.
Solved by O. S. in 29 mins
i want to modify formula to pick up a range when a date is changed
Solved by X. H. in 12 mins
I have a workbook with several sheets named Jan, Feb, Mar, Apr, May, Jun, Jul, etc. I'd like to be able to dynamically reference a range of sheets to sum in another sheet. For example, I have a Summary sheet that has a cell E3 that contains "Jun" and E4 contains "Dec". I'd like to sum cell E10 in the sheets Jun through Dec. If I change E3 to Jan, I'd like the formula to sum Jan through Dec. If I change E4 to Apr, I'd like it to sum Jan through Apr.
This is what I've tried:
=sum(Indirect("'"&$E$3:$E$4"&&"'!E10")
It doesn't work to sum values in E10 across the sheets in E3 and E4.
Solved by K. A. in 23 mins
In the Database sheet, enter conditions in the criteria range for unoccupied two- and three-bedroom apartments that need to be remodeled. Enter criteria as text only, without use of quotation marks. Be sure to enter the criteria separately in rows 3 and 4.
Apply an advanced filter based on the criteria range (A2:H4). Filter the existing database (range A15:H65) in place. Nine apartments meet the advanced filter conditions.
In cell C8, use the DCOUNTA database function to calculate the number of apartments that need to be remodeled based on the advanced filter you created.
Solved by Z. J. in 18 mins
What is range in excel definition?
Solved by M. D. in 14 mins
I need help with range function in excel!
Solved by V. F. in 27 mins
How to name a range excel?
Solved by S. H. in 17 mins
How can I find domain and range of a function?
Solved by K. L. in 16 mins