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
Hello! How do I Use the newly created range names to create a formula to calculate Net Profit (in cell B22). My newly created range names were Gross_ Profit, Hourly _Wage, and Production_Cost.
Solved by M. H. in 19 mins
Hello! How do I Complete the one-variable data table in the range E2:H22 using cell B4 as the column input cell?
Solved by Z. J. in 14 mins
Hello! Can you please show me how to do this? Complete the two-variable data table in the range E25:K45. Use cell B6 as the Row input cell and B4 as the Column input cell. Format the results with Accounting Number Format with two decimal places.
Solved by D. E. in 12 mins
In cell H15, enter a VLOOKUP function to determine the 2018 percentage of total attendance for the city listed in cell H14. Use the range A5:H11 as the table array
Solved by D. J. in 27 mins
Type Total Original Value in cell G1. In cell G2, enter a structured formula: If Edition Size is greater than 0, then multiply Edition Size by Issue Price; otherwise display an empty cell using "". Format the range G2:G105 with Accounting Number Format with zero decimal places.
=IF[@Edition Size]]>0,Edition Size*Issue Price,"")
^ formula not working
Solved by V. U. in 19 mins
Write a sub that asks the user for a positive integer less than 100. Using a Do While loop sum all the even numbers from 0 to the number entered. Display the results of this calculation with proper verbiage in a MsgBox. Assume 0 is an even number for our purposes. Check to be sure that the number is within the specified range and allow the user to correct the entry if it is not without having to re-run the problem.
Solved by A. A. in 15 mins
I am trying to build a formula in excel that looks at a certain date range and returns adjacent values based on a criteria
Solved by I. F. in 11 mins
I'm trying to create a HLOOKUP formula using a structured reference to look up the value in the Service Years column and retrieve the value in the 2nd row of the table in the range Q15:U16. Here's what I've done and it just won't work. =HLOOKUP([Service Years],Q15:U16,16) I've also tried =HLOOKUP([Service Years],Q15:U16, Q16:U16)
Solved by E. W. in 27 mins
I have a combobox on my excel sheet. I have it filled with a range and headers set. noting appears in the combobox until click on it. I want it to show at least the header while the sheet is active and not wait for a click on the combobox
Solved by F. J. in 15 mins
I have a combobox on my excel sheet. I have it filled with a range and headers set. nothing appears in the combobox when the sheet is active until I click on it. I want it to show at least the header when the sheet is active and not wait for a click on the combobox or it this the way a combobox works?
Solved by Z. J. in 14 mins