Your knowledge of Excel and your teaching is fantastic, but your humor is underappreciated
5 років тому
This video is brilliant, very well explained. I'm using Google Sheets for accounting, and I used this for auto-populate clients data by selecting their name from a drop-down list. It's so easy now! Thanks!
THANK YOU!!! I keep track of my sales for my home business and when I enter a product name I needed it to populate the wholesale cost and the retail cost so I didn't have to look it up each time. Thank you!! You've saved me so much time!
***** I need help regarding my work. What formula should i use in getting the results for a survey? It should state what answer got the highest votes. e.g. 113- Disagree, 100-Agree, 90-Undecided. The cell must display the word instead of the number.
I am trying to get name and address to merge from one spreadsheet to another, exactly what you are doing here. What function/formula did you use to get to the point where an identifying number automatically inserts the student information? I did try to find your previous tutorial as you suggested, but the video I found is an entirely different scenario, and I cannot figure out how to do it. Can you help me?
@Mark This video is really helpful but I need to know how can you interconnect all the data from student id ? If possible please prepare 1 video for all the function including how can you fetch bus name
been looking for this for last 3 hours on youtube . thanks man. thank you so much. I have a concern i want to address. i have a flexible price list for each customer how can we approach that with v loop up formula. like same products are sold for different prices to customer A and customer B and Customer C
How would I copy paste into a whole column? For example I want all of column A to use this formula to fill out the row based on an ID I input into a cell in column A.
help! I've been looking for hours and can't find what I need, until your video. How did you get all the data on the bus pass to populate? We have a weekly covid food drive and need to expedite the checkin process because the car lines are so long they are blocking traffic, but we don't want to turn anyone away or have to shut it down! The banks won't buy the food unless we have records. Basically looking to have a volunteer input a phone number which is in column B and have the name (A) and Address (C) to populate, and column D to say "YES" for visited before, all of which pulls from sheet 7 - where we store all existing data of people who already checked in atleast once before. If nothing matches, the volunteer continues to input their information. I didn't think it was possible until I saw ur bus pass video. Can you please help?
Hi Mark, I would like to ask the same question. From the link I could understand how you merged the data but I looking for the information where I can enter a number and information related to that number will populate. Eg. in the video you typed 456 and William Clinton's information populated. Please explain how you did that
Is there any formula that tell the cell to lookup to the sheet before. for example set a formula in sheet 2 that lookup for the value in sheet 1 and set a formula in sheet 3 to lookup in sheet two and when create a new sheet always lookup for the value for sheet before
Hi, what if i have multiple buses with the same ID for example, and i want excel to take each one of those lines and populate a different line for example each time, how to i do that ?
I have a fillable PDF form of 3 pages that I would like to export data from my excel sheet. This is to print out multiple forms prevailed forms. Please assist with a video.
Thank you so much for this tutorial it's very helpful for my practicing. Anyway i have to do some advance for using Vlookup function. if i like to use Vlookup for get data from url spreedsheet if i have permission to access data in other spreedsheet. please help me to solve this work. thank you so much.
I need some help, I have searched google, and youtube and I guess I'm just NOT asking the right question. I am trying with ZERO success to get the cells in this spreadsheet to populate the city and the county automatically when I enter the zip code. I am doing this in Google Sheets. Is there and idiot guide somewhere that can WALK ME THROUGH this?
Great video. I would like to vlookup customer name instead of customer id. Reasoning. I am preparing an invoice in google sheets. I am in Pest business. A customer may have 1, 2, 3, or 4 structures to spray. I would like to prepare a vlookup that would show me all structure for customer. Example. Jimmy W. customer has 123 rodella drive and 2234 paisley road. I would like to quickly look up customer name, it show me his structures to be treated, i pick and it autopops data into invoice
How do you make the bus pass sheet? So that when you enter the student ID everything auto populates? Or even what the name of this function is so I can search and leer about it
Do you have a video on how you got the spread sheet to populate the information once you placed the student ID into the cell? Or does anyone know of a video showing how that works?? Thanks!
Hi Mark, I would like to ask the same question. From the link I could understand how you merged the data but I looking for the information where I can enter a number and information related to that number will populate. Eg. in the video you typed 456 and William Clinton's information populated. Please explain how you did that
Google Sheet Functions: A step-by-step guide on Amazon - amzn.to/2qokYzj
Your knowledge of Excel and your teaching is fantastic, but your humor is underappreciated
This video is brilliant, very well explained. I'm using Google Sheets for accounting, and I used this for auto-populate clients data by selecting their name from a drop-down list. It's so easy now! Thanks!
You are the best! I've literally spent the last 9 hours trying to find this formula. Thank you so much for spending your time helping.
THANK YOU. I’m going to try this to see if my district can make it work for after school club late bus passes.
THANK YOU!!! I keep track of my sales for my home business and when I enter a product name I needed it to populate the wholesale cost and the retail cost so I didn't have to look it up each time. Thank you!! You've saved me so much time!
AWESOME video Mr. Jenkins !
Thank you for sharing, exactly what I was looking for.
Thank you! Life saver!
Mark Jenkins, I just created it. So thankful! This will save me a lot of time!
I subbed because this really helped me a lot! I thought the formula would be so long and I stayed up all night looking for the answer! Huge thanks
***** I need help regarding my work. What formula should i use in getting the results for a survey? It should state what answer got the highest votes. e.g. 113- Disagree, 100-Agree, 90-Undecided. The cell must display the word instead of the number.
+Mark Jenkins I don't get it pretty much. What do I need to place inside the A:A?
+Mark Jenkins omg thank you very much. Can I just share it to you so that you can look on it?
No thanks. I already got it right. Thanks again for helping me a lot :)
Very helpful. Thank you
Great video but how did you get the student name to auto populate by typing the student ID? Been trying to figure this part out
I am trying to get name and address to merge from one spreadsheet to another, exactly what you are doing here. What function/formula did you use to get to the point where an identifying number automatically inserts the student information? I did try to find your previous tutorial as you suggested, but the video I found is an entirely different scenario, and I cannot figure out how to do it. Can you help me?
Loved the humor
Thank you! Thank you so much! Very helpful :)
@Mark
This video is really helpful but I need to know how can you interconnect all the data from student id ?
If possible please prepare 1 video for all the function including how can you fetch bus name
been looking for this for last 3 hours on youtube . thanks man.
thank you so much.
I have a concern i want to address. i have a flexible price list for each customer how can we approach that with v loop up formula.
like same products are sold for different prices to customer A and customer B and Customer C
Really helpful tutorial! Ive been looking for this method all night and I am so glad to finally found it! Thank you :)
Still helping people like me, 6 years later!
How would I copy paste into a whole column? For example I want all of column A to use this formula to fill out the row based on an ID I input into a cell in column A.
help! I've been looking for hours and can't find what I need, until your video. How did you get all the data on the bus pass to populate? We have a weekly covid food drive and need to expedite the checkin process because the car lines are so long they are blocking traffic, but we don't want to turn anyone away or have to shut it down! The banks won't buy the food unless we have records. Basically looking to have a volunteer input a phone number which is in column B and have the name (A) and Address (C) to populate, and column D to say "YES" for visited before, all of which pulls from sheet 7 - where we store all existing data of people who already checked in atleast once before. If nothing matches, the volunteer continues to input their information. I didn't think it was possible until I saw ur bus pass video. Can you please help?
Hi Mark, I would like to ask the same question. From the link I could understand how you merged the data but I looking for the information where I can enter a number and information related to that number will populate. Eg. in the video you typed 456 and William Clinton's information populated. Please explain how you did that
Thank you Mark.. this helped a lot. My spreadsheet looks good now yeyy
Thanks for this really helped me with something I needed to do. I was able to finish it. Good tutorial and easy to understand and follow. Keep it up
Is there a way to use 2 identifiers to populate remaining data?
Is there any formula that tell the cell to lookup to the sheet before. for example set a formula in sheet 2 that lookup for the value in sheet 1 and set a formula in sheet 3 to lookup in sheet two
and when create a new sheet always lookup for the value for sheet before
very helpful - thank you!
very very Helpful, Thanks a lot....
Hi, what if i have multiple buses with the same ID for example, and i want excel to take each one of those lines and populate a different line for example each time, how to i do that ?
Great Help
I have a fillable PDF form of 3 pages that I would like to export data from my excel sheet. This is to print out multiple forms prevailed forms. Please assist with a video.
Thank you so much for this tutorial it's very helpful for my practicing. Anyway i have to do some advance for using Vlookup function. if i like to use Vlookup for get data from url spreedsheet if i have permission to access data in other spreedsheet. please help me to solve this work. thank you so much.
This was sooo helpful!!!
How do I automate vlookup on weekly changing data on different workbook
how did you make the Student ID part?
I need some help, I have searched google, and youtube and I guess I'm just NOT asking the right question. I am trying with ZERO success to get the cells in this spreadsheet to populate the city and the county automatically when I enter the zip code. I am doing this in Google Sheets. Is there and idiot guide somewhere that can WALK ME THROUGH this?
Is there any correlation between the student "Dan Quayle" and the "short bus"?!! ;>}
Great video. I would like to vlookup customer name instead of customer id. Reasoning. I am preparing an invoice in google sheets. I am in Pest business. A customer may have 1, 2, 3, or 4 structures to spray. I would like to prepare a vlookup that would show me all structure for customer. Example. Jimmy W. customer has 123 rodella drive and 2234 paisley road. I would like to quickly look up customer name, it show me his structures to be treated, i pick and it autopops data into invoice
Thank you Mark. I am really impressed with your knowledge. Thank you for taking the time to respond. True professional. Jimmy
THANK YOU SO MUCH!!!!!
Thank you sir
Very helpful
How do you make the bus pass sheet? So that when you enter the student ID everything auto populates? Or even what the name of this function is so I can search and leer about it
It's vlookup. I have another video on it, as well.
@@nogripes perfect is there a link to it?
@@Kai99342 ua-cam.com/video/2Dic8-TFp20/v-deo.html
Awesome! Thanks!!!
Can you show a video how you made the bus pass ?
hi can you do tutu real about bus seat reservation with daily shcedule ?
Do you have a video on how you got the spread sheet to populate the information once you placed the student ID into the cell? Or does anyone know of a video showing how that works?? Thanks!
Hi Mark, I would like to ask the same question. From the link I could understand how you merged the data but I looking for the information where I can enter a number and information related to that number will populate. Eg. in the video you typed 456 and William Clinton's information populated. Please explain how you did that
thank you!
how we can inventory list in excel
nice video
I like your data lol
mine wont work huhu
Look this could have been a good tutorial but you got to start it at the beginning of the creation of all the documents, not at the end
This did not work at all
It does work, you must have missed something in your vlookup. Feel free to reach out via email (contact (at) ultratech.us)
Helloo...