If you like my videos, check out the YouTube channel EXCELISFUN. Mike Gel Girvin has an amazing collection of enthusiastic Excel Videos on YouTube. Also in Episode 938 - an improvement for episode 933: =MOD(ROW(),2) is equivalent to =MOD(ROW(A2),2)=1.
This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
Transcript of the video:
Hey. Welcome back to the MrExcel netcast. I’m Bill Jelen.
This is episode number 938 which means that it's our 838th episode.
I want to send a shoutout to Mike Gel Girvin.
If you go to YouTube, go to YouTube, and search for Excel Is Fun, all one word, E-X-C-E-L-I-S-F-U-N, and click SEARCH, you're going to get to the ExcelIsFun channel.
Mike Gel Girvin has a thousand videos that he’s produced.
He is extremely enthusiastic with all kinds of great Excel tips.
So, if you enjoy watching my Excel videos, I want to send you out to check out these videos on YouTube.
Just an amazing collection and Mike has done a great job of organizing them.
So, you can see all of his videos on VLOOKUP or whatever, so check that out.
Also, from last week, I did 5 different podcasts about how to do alternate row shading.
At least a dozen people wrote in about Wednesday's podcast complaining about this formula.
We went into conditional formatting and I set up a rule that says =MODROW of A2 , 2.
Some people were nice enough to copy the help topic that says, look, you don't need to specify A2.
It will refer to the row in which the formula lives, and so that was one simplification.
Several other people said, you know, this basically is going to return a 0 or a 1, a 0 or a 1.
Excel will treat the 1 as TRUE, so you don't even need to put the =1.
Just simply put that formula =MOD (, row,) , 2 ), click OK, and it will work equally well.
[ =MOD(ROW(),2) ].
So, thanks to everyone who wrote in with a great way to shorten that formula.
That's what I love about this community.
I mean, you come up with one solution and someone says, wait, wait, we can tweak that.
We can shave a few characters off.
I certainly appreciate that.
I didn't understand that one piece of the row function.
So, thanks to everyone.
Also, don't forget to check out on YouTube ExcelIsFun, Mike Gel Gervin [ unintelligible – 02:14 ] MrExcel community.
Tons of videos there.
Very enthusiastic.
I want to thank you for stopping by.
We'll see you next time for another netcast from MrExcel.
This is episode number 938 which means that it's our 838th episode.
I want to send a shoutout to Mike Gel Girvin.
If you go to YouTube, go to YouTube, and search for Excel Is Fun, all one word, E-X-C-E-L-I-S-F-U-N, and click SEARCH, you're going to get to the ExcelIsFun channel.
Mike Gel Girvin has a thousand videos that he’s produced.
He is extremely enthusiastic with all kinds of great Excel tips.
So, if you enjoy watching my Excel videos, I want to send you out to check out these videos on YouTube.
Just an amazing collection and Mike has done a great job of organizing them.
So, you can see all of his videos on VLOOKUP or whatever, so check that out.
Also, from last week, I did 5 different podcasts about how to do alternate row shading.
At least a dozen people wrote in about Wednesday's podcast complaining about this formula.
We went into conditional formatting and I set up a rule that says =MODROW of A2 , 2.
Some people were nice enough to copy the help topic that says, look, you don't need to specify A2.
It will refer to the row in which the formula lives, and so that was one simplification.
Several other people said, you know, this basically is going to return a 0 or a 1, a 0 or a 1.
Excel will treat the 1 as TRUE, so you don't even need to put the =1.
Just simply put that formula =MOD (, row,) , 2 ), click OK, and it will work equally well.
[ =MOD(ROW(),2) ].
So, thanks to everyone who wrote in with a great way to shorten that formula.
That's what I love about this community.
I mean, you come up with one solution and someone says, wait, wait, we can tweak that.
We can shave a few characters off.
I certainly appreciate that.
I didn't understand that one piece of the row function.
So, thanks to everyone.
Also, don't forget to check out on YouTube ExcelIsFun, Mike Gel Gervin [ unintelligible – 02:14 ] MrExcel community.
Tons of videos there.
Very enthusiastic.
I want to thank you for stopping by.
We'll see you next time for another netcast from MrExcel.
