Thank you! Using your video, I was able to modify it and figured out a way to complete a task at work in 30 minutes rather than 4 hours.
@IuliusCaesar18
2 жыл бұрын
Thanks a lot, Chris! You saved me a lof of time and headache, couldn't ask for a better Excel tutorial!
@ChrisMenardTraining
2 жыл бұрын
You're welcome! Thanks, Caesar11.
@Nabiyah1
3 ай бұрын
Straight Forward. Clear. Great Visual and Audio Instructions. Saved me a TON of Time! Thank You Brotha! Excellent Video. New Sub!
@bronfoth
2 жыл бұрын
Thanks for a great explanation. Fabulous teaching. The row tip for numbering is much appreciated too!
@ChrisMenardTraining
2 жыл бұрын
You're very welcome!
@bronfoth
2 жыл бұрын
@@ChrisMenardTraining it worked well. I ended copying the "values only" onto a new Sheet in correct alignment, and then filtering/deleting the blank cells. With almost 3000 rows in each of my 2 columns so this was WONDERFUL!
@nicolef9165
8 ай бұрын
This was so helpful and a great intro to IF and IS statments in excel. I really appreciate this!
@olehchuprynskyi4599
Жыл бұрын
Thank you a lot! This video lesson has saved me a ton of time! Super helpful!!!
@ChrisMenardTraining
Жыл бұрын
I appreciate the positive feedback. Thank you.
@shieldteam
6 ай бұрын
Thank you! Easy to follow and worked perfectly
@cheuky555
Жыл бұрын
thanks so much, your method is way easier compared to other youtube videos ive seen
@ChrisMenardTraining
Жыл бұрын
Glad to hear that!
@StephenLoughlin-h8k
Жыл бұрын
Perfect explanation! Thank you.
@ChrisMenardTraining
Жыл бұрын
You bet. Thanks, Stephen.
@thepgprincess
2 жыл бұрын
Just saved my life...subscribed.
@ChrisMenardTraining
2 жыл бұрын
Thanks, Monique!
@savissm
Жыл бұрын
Thank you so very much, very clear and easy to follow, Thank you !
@ChrisMenardTraining
Жыл бұрын
You're very welcome!
@mbe2533
3 жыл бұрын
Thank you, Chris! This worked perfectly! You saved me lots of time.
@ChrisMenardTraining
3 жыл бұрын
Glad it helped!
@dido.the.side.h0646
2 жыл бұрын
This was so so helpful thanks! very clearly explained
@tammychoink8617
3 жыл бұрын
Exactly what I wanted - no waffle and straight to the answer whilst explaining the steps. Superb.
@ChrisMenardTraining
3 жыл бұрын
Thank you.
@SylviaSimicic
6 ай бұрын
Great information, which I'm sure will come handy in the future. How can I transfer data from Column B into Column A, If I have 100 part numbers in Column A and I need to insert a serial number from column B into Colum A after every other cell? For example, the Serial number has to be inserted below it's Part number, not across in row B.
@iRocGrl
Жыл бұрын
Thank you so much and so clearly explained!
@ShannCommand
Жыл бұрын
YOU ARE AMAZING! Thank you so much!
@hannahpetersen1134
2 жыл бұрын
Helps a lot. btw in my excel IF function uses ; instead of ,
@ChrisMenardTraining
2 жыл бұрын
That sounds like a Windows setting, but as long as it is working, that's all that matters. :-)
@hanrealistic
Жыл бұрын
excellent tutorial
@ChrisMenardTraining
Жыл бұрын
Thank you.
@FromHawaii83
3 жыл бұрын
Good tip but for me (Mac) every time I click "delete row" (after applying the filter) the filter is no longer selected and ALL my highlighted rows are gone. Have you run across this before? Any tips? tnx
@mharnish
2 жыл бұрын
What if the original data in Column A spans 3 rows E.g., Row 1 = "Delta Airlines", Row 2 = "11 Main Ave. Atlanta GA 30303" and Row 3 = "800 123 4567". Is there a formula to move data from Rows 2 and 3 to Columns B and C respectively?
@jordanbaker931
2 жыл бұрын
Very helpful, thanks!
@ChrisMenardTraining
2 жыл бұрын
You're welcome!
@asingh386
2 жыл бұрын
Thank you!!!
@ChrisMenardTraining
2 жыл бұрын
You're welcome!
@traceyagate9578
2 жыл бұрын
amazing :)
@ChrisMenardTraining
2 жыл бұрын
Thank you.
@ubaidillahmuhammad20
3 жыл бұрын
loved it
@ChrisMenardTraining
3 жыл бұрын
Thank you.
@faezehtalebi4316
2 ай бұрын
👍👍👍
@jakevolk_
Жыл бұрын
ice man
@the_blurbob2556
2 жыл бұрын
Hey Chris, I have a problem, I seem to not be able to use the function and Excel keeps popping up the message "there's a problem with this formula" (but in Spanish, I use it in Spanish because it's my main language). it keeps on saying that I'm not trying to use a formula and to rewrite the formula for it to just output text what do I do?? i really need to separate even and odd values but doing it by hand would be incredibly tedious and hard... Also, I use mac if that of any importance. Thanks for any help you can provide
@jonathansamuel1223
2 жыл бұрын
with excel (16.0.14326) - values is separted by ';" instead of "," so the command is =IF(ISODD(ROW());A2;"")
@mwendabaimwendabai4923
4 ай бұрын
I am going to bookmark this forever! You have no idea how I was cratching my head and trying to figure out what I need to do to get this done. I love it!
@MrPaddy35
Жыл бұрын
Exactly what i was looking for :) Thank You :)
@ChrisMenardTraining
Жыл бұрын
Glad I could help!
@craiggoebbel8922
2 жыл бұрын
I love learning new things. This is exactly what I needed. Thank you.
@penguin0075
2 жыл бұрын
Hello from the UK! Brilliant video Chris, thank you so much as I need this for a task at work. I have client lists and next of kin contact details for each client are on every other row, I will test this tomorrow as I think think this will work perfectly for moving the data from every other second row, to the first row. Thanks so much! Subscribed too ☺️
@ChrisMenardTraining
2 жыл бұрын
Fantastic! Thank you.
@Suriel08
Жыл бұрын
Thanks for this! Great explanation.
@ChrisMenardTraining
Жыл бұрын
You are welcome. Thanks for visiting.
@harshkatyal8470
Жыл бұрын
Thanks...came in handy at just the right time
@ChrisMenardTraining
Жыл бұрын
Glad to help. Thanks, Harsh,
@AlekyaPawarMamidi
Жыл бұрын
Thank you, you helped a lot with my sheet :)
@ChrisMenardTraining
Жыл бұрын
Thank you.
@danf73
2 жыл бұрын
Awesome! + new subscriber
@ChrisMenardTraining
2 жыл бұрын
Thanks for subbing!
@maggiemondo7459
2 жыл бұрын
Absolutely brilliant. This is just what I need for an excel task today. Thank you.😀
@ChrisMenardTraining
2 жыл бұрын
You're very welcome!
@MK-kl9zk
11 ай бұрын
When I type =IF(ISODD(row())),A2,"" Excel does not recognize as a formula. Can anybody help me?
@ilanalani
4 ай бұрын
Thank you so much!
@ChrisMenardTraining
4 ай бұрын
You're welcome!
@74H1D
10 ай бұрын
thank you, my dear
@ChrisMenardTraining
10 ай бұрын
Welcome 😊
@lockoutslayer
3 жыл бұрын
This man is a genius. . . Exactly what I needed. Felt like you could read my mind.
@ChrisMenardTraining
3 жыл бұрын
Thank you! I'm not sure about genius, but I appreciate the comment. :-)
@lihuazeng7640
Жыл бұрын
wow! thank you!
@ChrisMenardTraining
Жыл бұрын
welcome.
@JaKoMaGrp
3 жыл бұрын
Thank you Chris, this is awesome! Saved me hours of work!!
@ChrisMenardTraining
3 жыл бұрын
You're welcome!
@A7medChannel
2 жыл бұрын
Thank you
@ChrisMenardTraining
2 жыл бұрын
You're welcome
@bhaveshmunot136
2 жыл бұрын
It's just amazing....you taught so calm ....🎉🔥
@ChrisMenardTraining
2 жыл бұрын
Thank you so much 😀
@gesaputra
8 ай бұрын
Thanks man. Auto subscribed
@Thanasis_Tsiris
11 ай бұрын
Very nice! What if I want to copy every 5th row?
@MrBos2000
2 жыл бұрын
Exactly what I need. You are awesome. Thanks a lot for this help. I have subscribe to your channel. Keep making such helpful contents
@ChrisMenardTraining
2 жыл бұрын
Thank you, Mohan! I appreciate the sub!
@AmaruCH
2 жыл бұрын
Helpful indeed! Thank you. You save me a bunch of time.
@ChrisMenardTraining
2 жыл бұрын
You're welcome!
@johnmcneeley5880
6 ай бұрын
This was exactly what I needed. I had data with associated entries stacked on top of eachother because it was a dead pull from two different systems. I was able to get things all lined up exactly how I needed. Thank you for clearly writing this out and giving a solid explanation of what everything is doing. Glad it all still works three years later.
@ChrisMenardTraining
6 ай бұрын
Thank you. I'm glad it is still working also. :-)
@greensandgolds
Жыл бұрын
great - thank you so much, very easy to follow and exactly what I needed. Will be subscribing.
@ChrisMenardTraining
11 ай бұрын
Awesome, thank you!
@wanderer4196
Жыл бұрын
What I was exactly looking for. Thanks for keeping it simple :) Absolutely brilliant!
@ChrisMenardTraining
Жыл бұрын
You're welcome!
@willennavarra5556
2 жыл бұрын
I am having a hard time looking for the correct formula for my today's task. This video of yours helped me a lot :) Thanks!
@ChrisMenardTraining
2 жыл бұрын
Excellent! Thanks, Willen .
@chriscowboyfan
6 ай бұрын
WOW !!! I didnt know if this could be done. Thank you so much helped me out alot
@ChrisMenardTraining
6 ай бұрын
You're welcome!!
@gabrielkimbrough
Жыл бұрын
This is awesome. Worked great for a list of 4000 companies and addresses. Thank you!!
@ChrisMenardTraining
Жыл бұрын
That is awesome! Thanks for letting me know it worked.
@nic5958
2 жыл бұрын
This is amazing! Wonderful tutorial. Thank you so much. You saved me like three hours
@ChrisMenardTraining
2 жыл бұрын
You're welcome!
@razminazman7323
2 жыл бұрын
Chris thank you so much. Trully appreciate this video.
@ChrisMenardTraining
2 жыл бұрын
My pleasure!
@renbaldwin4024
3 жыл бұрын
Excellently done. You refer to chapters. Where are those chapters to be found?
@ChrisMenardTraining
3 жыл бұрын
Those are the bookmarks throughout the video. The blue dots with the timestamps. drive.google.com/file/d/1I5AM-SVzK-WvtQD3Vdxkf5hplUOLjjv3/view?usp=drivesdk
@jingle3
10 ай бұрын
Thanks Chris!
@Nabiyah1
3 ай бұрын
Thanks!
@TomIkonomouVancouverHomes
2 жыл бұрын
Thank you Sir. Very well produced and easy to understand.
@ChrisMenardTraining
2 жыл бұрын
You are very welcome. Thanks, Tom.
@jazminemiddleton9775
2 жыл бұрын
This really saved me! Thank you so much!!!!!!!!!!!!!!
@ChrisMenardTraining
2 жыл бұрын
Jazmine, glad to help.
@flemmingelmstrand3061
Жыл бұрын
Didn't work for me first, but then I realized that when you hit comma, I have to use Semikolon....But you saved my day (had a list with +1.000 entries I had to get sorted) THANKS A LOT
@ChrisMenardTraining
Жыл бұрын
Thank you! That one keyboard key can get you. :-) I'm glad you got it to work.
@PeggyStinson
Жыл бұрын
@@ChrisMenardTraining wait, where do I need to use a semicolon...I'm in Europe. because this does not work for me - does this work for Excel 365?
@PeggyStinson
Жыл бұрын
oh wow - this is what I used - =WENN(ISTUNGERADE(ZEILE());A1;"") and it worked. (using a German version of Excel)
@flowgurus
3 жыл бұрын
Absolute life saver. Pure gold thank you :)
@ChrisMenardTraining
3 жыл бұрын
Thank you!
@shauntairenee1270
3 жыл бұрын
Such a great help! Worked like a charm!
@ChrisMenardTraining
3 жыл бұрын
Thank you!
@davidh2260
11 ай бұрын
Perfect Chris, just what I needed for a quick task. Not only did it do what I needed, similar to the example but it is very flexible and efficient so I will keep a note the method for other use cases. Great teaching style and yep, now another subscriber! Thank you 😀
@NicholeCIEE
8 ай бұрын
Thank you so much for this video and your extra explanations about each function! Perfect for what I'm working on today and will also help in the future.
@belzebul
2 жыл бұрын
6:17 and 7:11 How do I select all items, if let's say, my data is not in 5 rows, but there is 500 rows of data? Thank you
@yashvardhanpandey4523
2 жыл бұрын
magic wow i was searching for this but i didn't know how to search for this haha many thanks dude , big help
@martindobrovic2223
3 жыл бұрын
Thank you. Awesome.
@ChrisMenardTraining
3 жыл бұрын
You bet!
@nj678
Жыл бұрын
So Helpful. Thank you for the clear steps and easy to understand:) 🙂
Пікірлер: 124