LIFE SAVER!!! I am learning from a book, EXCEL Statistics, the 3rd edition (by Neil J. Salkind) and the directions are so vague. There are not enough visuals to grasp the concept of this function. I appreciate the upload and how you broke this down so easily. I will be sharing this with my classmates, who will also be very grateful!
How can you get multiple modes that have different Counts. Example the Mult.Mode that appears most and second to the most, third to the most and so on and then to use the "Count to see how many times? So, the highest count of numbers are listed first MODE Count 14 appears 83 times 30 appears 68 times 57 appears 50 time 63 appears 34 times
Thanks. I was trying to learn this form a book and could not get the array to work due to unusual process of highlighting first and then using CTR-SHIFT-ENTER.
I need to take a question, a little more complex. Example.. 100,000 deliveries are made in 30 days. There are 1,000 neighborhoods in the city, divided for 50 drivers .. The drivers do not have fixed neighborhoods, but I need to route the neighborhoods, according to the drivers' history. I need to know which neighborhoods each driver did times over a period, using formula and not just filters, because there are 1,000 neighborhoods and I do not want to check one by one.
If I get you correctly. What is the information you already have? i.e. Do you have the history of each driver? or what? You can send me what you have to my email and I can solve it for you: MGBasheerH @ Outlook . com
LIFE SAVER!!! I am learning from a book, EXCEL Statistics, the 3rd edition (by Neil J. Salkind) and the directions are so vague. There are not enough visuals to grasp the concept of this function. I appreciate the upload and how you broke this down so easily. I will be sharing this with my classmates, who will also be very grateful!
I am using the same book
Thank you!! I was never able to work out what an array function was until I saw your video - at last I can work out multiple modes properly :)
First video that actually helped me understand. Thank you!!!
Excellent easy to follow explanation
That does clear up a lot about how to use Mode. My question is, in what circumstance would I need it?
Thanks once again always great information plus a bonus to get Excel tips!
O my God! Thank you so much, been battling with this for days. I got the fomular but clicked enter straight.
If the rest of your video's are this good call me a regular! Thank you.
Very well explained.
Thanks
How can you get multiple modes that have different Counts. Example the Mult.Mode that appears most and second to the most, third to the most and so on and then to use the "Count to see how many times? So, the highest count of numbers are listed first
MODE Count
14 appears 83 times
30 appears 68 times
57 appears 50 time
63 appears 34 times
Thanks. I was trying to learn this form a book and could not get the array to work due to unusual process of highlighting first and then using CTR-SHIFT-ENTER.
Thank you sir, this has helped me tremendously!!!
You're welcome!
Thank you, very clear and helpful.
You are welcome - thank you for watching -
Thank you you this really helped me !
You're welcome, thanks for watching -
I need to take a question, a little more complex.
Example..
100,000 deliveries are made in 30 days.
There are 1,000 neighborhoods in the city, divided for 50 drivers ..
The drivers do not have fixed neighborhoods, but I need to route the neighborhoods, according to the drivers' history.
I need to know which neighborhoods each driver did times over a period, using formula and not just filters, because there are 1,000 neighborhoods and I do not want to check one by one.
If I get you correctly.
What is the information you already have?
i.e. Do you have the history of each driver? or what?
You can send me what you have to my email and I can solve it for you:
MGBasheerH @ Outlook . com
tysm sir!
Thank you! Couldn't figure out what I was doing wrong. lol
You're welcome - thanks for watching -
Thanks for help :)
You're welcome!
how to remove endmode on excel sheet
how solved error in excel " #name? "
COUNDT MAKE IT TO WORK IN MAC
poorly understood