You need to take the bus into campus to attend MIS 204. You know that the M bus is the route you need, and you’ve
got the route schedule in Excel. Your task is to write a formula that determines when the next bus will arrive at your
stop, and how long until that time.
1. Enter a time in cell C11.
2. Setup data validation in cell C12 and then choose a stop.
3. Write a formula for cell C14 that uses INDEX & MATCH to determine when the next bus will arrive.
a. You will need to match on two dimensions: stop number and time.
b. Your INDEX array should not include the stop numbers.
c. The MATCH() you setup to determine column number is complex.
i. You will need to use the OFFSET() function in your second MATCH function. The OFFSET
function shifts a range from a starting point x number of rows and y number of columns.
1. Your reference will be cell D1.
2. The number of rows you need to shift downwards is equal to the stop number minus 1.
3. The number of columns you need to shift rightwards is 0.
4. The height is 1
5. Use the COLUMNS() function to determine the width.
ii. Specify the match type (HINT: the times are in ascending order).
d. You will need to add 1 to the results of the second MATCH().
4. Once you have your INDEX & MATCH working, you need to make one last change. If you enter a time that is
when the bus isn’t running (e.g., 1:00AM) the formula will return a #REF error for stops 3 – 9 because you are
asking the INDEX function to return from an array that is not on the range you specified.
a. To fix this problem, put your formula inside an IFERROR() formula.
b. For the value_if_error argument, write another INDEX & MATCH with the INDEX array the first column
of times, and matching the stop number to the column of stop nu
Hi there!
This project really interest me! I'm a dedicated professional with experience in this area.I guarantee my work 100%.
• Very high speaking and writing skills
• Hard, motivated worker
• Highly efficient data entry clerk
• Highly proficient advance excel user
I look forward to discuss this project further with you.
Thank you very much in advance.
$10 USD dalam 1 hari
0.0 (0 ulasan)
0.0
0.0
6 pekerja bebas membida secara purata $58 USD untuk pekerjaan ini
Hi there
My name is Carlos and I'm an expert in .Net and sql server.
I have been working in software developement for the last 20 years.
I have many experience in desktop and web development.
Regards
Hi,
I am Monir and it will be my pleasure to assist you with this project. I have read your project description
You can expect from me I strong commitment to a deadline, the highest quality, and a fluid/friendly communication. Client satisfaction is my ultimate goal. I look forward to working on this project. I would be glad to chat with you to see how I can help.
Thank you for your time and consideration. Don't hesitate to contact me if you are interested, I am sure I will not let you down.
Thanks & Best Regards
Monir
It's piece of a cake. It would be more suitable if you will do it in the google sheets. The programming is more efficient in google scripts. However, it is your decision to make. I would deliver the working project in 15 days. Look forward to your kind response.