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!

Exactly what I wanted - no waffle and straight to the answer whilst explaining the steps. Superb.

@ChrisMenardTraining

3 жыл бұрын

Thank you.

Straight Forward. Clear. Great Visual and Audio Instructions. Saved me a TON of Time! Thank You Brotha! Excellent Video. New Sub!

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

4 ай бұрын

Thank you. I'm glad it is still working also. :-)

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.

Thank you! Easy to follow and worked perfectly

This is awesome. Worked great for a list of 4000 companies and addresses. Thank you!!

@ChrisMenardTraining

10 ай бұрын

That is awesome! Thanks for letting me know it worked.

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. :-)

Perfect explanation! Thank you.

@ChrisMenardTraining

Жыл бұрын

You bet. Thanks, Stephen.

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.

Just saved my life...subscribed.

@ChrisMenardTraining

2 жыл бұрын

Thanks, Monique!

Thanks...came in handy at just the right time

@ChrisMenardTraining

Жыл бұрын

Glad to help. Thanks, Harsh,

Thanks for this! Great explanation.

@ChrisMenardTraining

Жыл бұрын

You are welcome. Thanks for visiting.

I love learning new things. This is exactly what I needed. Thank you.

This was so helpful and a great intro to IF and IS statments in excel. I really appreciate this!

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.

Thank you, you helped a lot with my sheet :)

@ChrisMenardTraining

Жыл бұрын

Thank you.

Thank you a lot! This video lesson has saved me a ton of time! Super helpful!!!

@ChrisMenardTraining

Жыл бұрын

I appreciate the positive feedback. Thank you.

thanks so much, your method is way easier compared to other youtube videos ive seen

@ChrisMenardTraining

Жыл бұрын

Glad to hear that!

Exactly what i was looking for :) Thank You :)

@ChrisMenardTraining

Жыл бұрын

Glad I could help!

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 😀

What I was exactly looking for. Thanks for keeping it simple :) Absolutely brilliant!

@ChrisMenardTraining

10 ай бұрын

You're welcome!

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!

Thank you Chris, this is awesome! Saved me hours of work!!

@ChrisMenardTraining

3 жыл бұрын

You're welcome!

Absolutely brilliant. This is just what I need for an excel task today. Thank you.😀

@ChrisMenardTraining

2 жыл бұрын

You're very welcome!

This was so so helpful thanks! very clearly explained

magic wow i was searching for this but i didn't know how to search for this haha many thanks dude , big help

WOW !!! I didnt know if this could be done. Thank you so much helped me out alot

@ChrisMenardTraining

4 ай бұрын

You're welcome!!

Thank you, Chris! This worked perfectly! You saved me lots of time.

@ChrisMenardTraining

2 жыл бұрын

Glad it helped!

Thank you Sir. Very well produced and easy to understand.

@ChrisMenardTraining

2 жыл бұрын

You are very welcome. Thanks, Tom.

This is amazing! Wonderful tutorial. Thank you so much. You saved me like three hours

@ChrisMenardTraining

Жыл бұрын

You're welcome!

So Helpful. Thank you for the clear steps and easy to understand:) 🙂

Thank you so very much, very clear and easy to follow, Thank you !

@ChrisMenardTraining

Жыл бұрын

You're very welcome!

YOU ARE AMAZING! Thank you so much!

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 .

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

Жыл бұрын

Fantastic! Thank you.

Helpful indeed! Thank you. You save me a bunch of time.

@ChrisMenardTraining

2 жыл бұрын

You're welcome!

It's just amazing....you taught so calm ....🎉🔥

@ChrisMenardTraining

2 жыл бұрын

Thank you so much 😀

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)

Thank you so much, Chris! You are a life saver :)

Absolute life saver. Pure gold thank you :)

@ChrisMenardTraining

3 жыл бұрын

Thank you!

great - thank you so much, very easy to follow and exactly what I needed. Will be subscribing.

@ChrisMenardTraining

9 ай бұрын

Awesome, thank you!

Thank you so much and so clearly explained!

Such a great help! Worked like a charm!

@ChrisMenardTraining

3 жыл бұрын

Thank you!

excellent tutorial

@ChrisMenardTraining

Жыл бұрын

Thank you.

Chris thank you so much. Trully appreciate this video.

@ChrisMenardTraining

2 жыл бұрын

My pleasure!

This really saved me! Thank you so much!!!!!!!!!!!!!!

@ChrisMenardTraining

2 жыл бұрын

Jazmine, glad to help.

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!

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. :-)

Thank you so much!

@ChrisMenardTraining

2 ай бұрын

You're welcome!

Very helpful, thanks!

@ChrisMenardTraining

2 жыл бұрын

You're welcome!

Thanks Chris!

Thanks man. Auto subscribed

Thank you. Awesome.

@ChrisMenardTraining

3 жыл бұрын

You bet!

thank you, my dear

@ChrisMenardTraining

8 ай бұрын

Welcome 😊

Thank you!!!

@ChrisMenardTraining

2 жыл бұрын

You're welcome!

That was great. Thnx

@ChrisMenardTraining

3 жыл бұрын

You're welcome!

Thank you

@ChrisMenardTraining

2 жыл бұрын

You're welcome

Thanks!

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

wow! thank you!

@ChrisMenardTraining

Жыл бұрын

welcome.

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.

loved it

@ChrisMenardTraining

3 жыл бұрын

Thank you.

Awesome! + new subscriber

@ChrisMenardTraining

2 жыл бұрын

Thanks for subbing!

amazing :)

@ChrisMenardTraining

2 жыл бұрын

Thank you.

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

Very nice! What if I want to copy every 5th row?

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

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

with excel (16.0.14326) - values is separted by ';" instead of "," so the command is =IF(ISODD(ROW());A2;"")

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?

When I type =IF(ISODD(row())),A2,"" Excel does not recognize as a formula. Can anybody help me?

ice man