Get instant live Excel expert help to learn how to use Large function?
“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
Correct the function used in cell A3 to calculate the sum of the values in the NumAttending column. Correct the function used in cell A4 to count the number of values in the Street column. Correct the function used in cell A5 to count the number of blank cells in the NumAttending column.
Correct the function used in cell A6 to display the largest value in the NumAttending column.
Correct the function used in cell A7 to display the average value in the NumAttending column.
Solved by F. C. in 22 mins
I need to show a frequency distribution and a histogram for a set of 200 data. all ranging from 43-116. I have sorted it from smallest to largest and would like to class the data from 40-49,50-59,60-69,70-79,80-89,90-99,100-109, 109-110, and 110-119. How do I create the frequency distribution and histogram with this data?
Solved by O. F. in 28 mins
Sort the data by the CHANGERS/NOCHANGERS column. Then, sort the CHANGERS by audit fees (largest to smallest). Lastly, in a final column, provide the percentage change in audit fees from 2016 to 2017 for the CHANGERS observations. Label the CHANGER/NOCHANGERS column as Auditor Change, and the percentage change in audit column as % Fees Change. The % Fees Change column should be formatted to be shown as percentages.
Solved by T. B. in 15 mins
i need help editing a formula to count cells that are not blanks and the largest streak of zero
Solved by E. E. in 16 mins
How can I take the 3 largest numbers from a list of numbers and sum them?
Solved by X. D. in 18 mins
4. Use graphing software to complete the following question.
It’s swimming season and Parks and Recreation of Sunnyville plans to enclose part of the lake along the beach for the town’s swimmers as shown in Figure 6 below. The swimming area is to be divided into two equal smaller rectangular areas by a rope parallel to one side of the entire swimming area. There is 800m of rope available. Determine the values of the length and the width that would provide the largest swimming area.
(Hint: Start with w = 0m with equal increments of 10, up to w = 270m.)
Solved by F. L. in 26 mins
I am working on a spread sheet and I need to do it by date
( monday - friday ) using sort - no problem. Then I would like to sort it by patient balance smallest to largest. When I add a level I loose the sort by date monday- friday.
Help Please
Solved by F. C. in 30 mins
I have an assignment which needs me to use Excel to find Standard Error and Confidence Level of 99% for the top 20 areas when kth largest and kth minimum are both equal to 1.
Solved by E. B. in 21 mins
Need to sort my pivot chart from largest to smallest for each agent.
Solved by S. C. in 29 mins
Need to sort my pivot column chart from largest to smallest for each agent.
Solved by K. J. in 28 mins