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
My Index function won't resolve in Excel 365. I want the function to return the value at an interesecton of a row or column of a pre-defined array which I have also setup as a named Range. The syntax I am typing is: =INDEX(Db1_Pageviews|$C$7|C$8). here, C7 gives the row number and C8 the column number. Why is Excel not resolving this?
Solved by E. A. in 16 mins
I need to add more to a range and the rest of the group I need to add is in different sections of Excel what should I do
Solved by O. B. in 26 mins
I created a chart in Excel but the frequency range came out in duplicates ex. 1 , 1,2,2,3,3,4,4,5. When it was done automatically the range was fine but there were fraction ex 1, 1.5 2. 2.5. I changed numbers to have whole numbers only and got the whole numbers with duplication.
Solved by D. E. in 11 mins
create range names based on the values in the range A2:B5
Solved by V. U. in 29 mins
I am having trouble with a median calculation using nested ifs. This time it's for a text status within date range.
Solved by Z. J. in 26 mins
in cell G2 in the valuable worksheet, enter the YEARFRAC function to calculate the number of years from the release date and the date in cell Q2. Use relative and mixed references correctly. format the value with comma style with one decimal place. copy the function to the range G3:G40
Solved by C. S. in 14 mins
in cell L2 in the valuable worksheet, enter a nested logical function to display highly valuable if either condition is met:
-the release date is on or before December 31,1994 or
-the sold out status is yes, the percentage increase in value is at least 500%, and the edition size was less than 700
enter an empty text string if the two conditions are not met
you need to nest two logical functions within the logical test argument. use cell references to set all conditions. copy the function from cell L2 to range L3:L40
Solved by O. H. in 21 mins
in cell O12 in the valuable worksheet enter a database function to estimate values of the highly valuable pieces of artwork indicated in column L. the criteria range is located in the range N6:N7
Solved by F. B. in 17 mins
assign the range name called database to the range A14:J178
Solved by V. B. in 16 mins
create column labels for the criteria range (in row 7) by copying the labels from row 14 and then replace Edition Size with a second Release date column label (in E7)
Solved by C. H. in 14 mins