Get instant live Excel expert help to learn how to use Find function 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'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
Macro to "find" a common value (it is in multiple worksheets but not on the same row), Then select the row that the value is in, then select the remaining rows in the worksheet, delete those rows, and then save the worksheet.
Solved by G. E. in 26 mins
A researcher is interested in sentencing dispositions and their relationship with the severity of a crime. She asked a sample of 10 prospective jury members to rate the seriousness of a particular crime (X) on a 1 (not very serious) to 7 (extremely serious) scale and then determine the sentence (Y) in years that sample members would recommend for that crime. The data are as follows: a. Calculate the regression slope and Y-intercept. Interpret your results. b. Predict the length of recommended sentence for a crime rated “5” on seriousness. c. Find the R-square. What does it mean?
Solved by O. Q. in 18 mins
A researcher has gathered data from seven randomly selected correctional employees on the number of years (X) the employees have worked in a particular department and their salaries (Y) in thousands of dollars.
a. Calculate the regression slope and Y-intercept. Interpret your results.
b. What would the predicted salary be for someone in the department who has worked for 6 years?
c. Find the R-square. What does it mean?
Solved by B. B. in 25 mins
Hi, I need to find a way automatically insert a label in a cell based on the words it contains in a different cell (same row).
Solved by D. H. in 24 mins
I don't know how to filter out values that link to another variable to find 2 different averages
Solved by G. L. in 22 mins
I need to make a Pareto chart and analyze data in excel to find out why a particular action is late.
Solved by X. U. in 23 mins
I can't seem to figure out how to find the average daily attendance by month, by role, and overall based on the data available to me.
Solved by O. E. in 27 mins
I would like support on how to now find the average attendance by month by role and overall based on the data shared in Pivot table 1 of the linked sheet
Solved by E. H. in 28 mins
I would like to find a formula to accurately calculate the total number of order each employee makes that contains an email address.
Solved by G. H. in 25 mins