1Q 2010 -- Podcast #1212

If you like this content, please consider visiting the video on YouTube and subscribe to the MrExcel Channel to show your support!
This video has been published on Jul 26, 2010 .
Clive provides a great tip for filling years and quarters using the Fill Handle. Episode #1212 shows you how.

...This blog is the video podcast companion to the book,Learn Excel 97-2007 from MrExcel - learn one of the 377 tips from the book!
maxresdefault.jpg


Transcript of the video:
Hey, welcome back to MrExcel netcast.
I am Bill Jelen.
Here is another tip from the Orlando seminar.
This is from Clive. Clive regular Mr.Excel.
He watches the podcast so he collared.
Thanks for this great tip.
We talking about the fill handle in the seminar.
You know of course the fill handle works great with quarters, Like that smart enough that after cube for it starts over again, but it really does not do well with quarters and years Q1 2010.
They just can't get it right its Q1 2011, 2012.
A climb showed me this great trick.
He said, hey if you can if you can live with the fact that you put the quarter number first, 1Q 2010.
Then all of a sudden they figured out what's going on and so you get 2Q, 3Q, 4Q and then they switched to 1Q 2011 to Q2 2011.
That's a great trick.
I never thought of doing it that way.
Works out really really well and it seems that you can use...
If you put the number 1Q 10, 1Q 10 that's one that will also work.
So, you can use any format you want.
Provided you put the quarter number before the letter Q and then the year number after.
So a very very cool way to go.
Like a run for stopping by.
Here in the United States.Have a great memorial day weekend.
See you ext time for another netcast from MrExcel.
 

Watch MrExcel Video

Forum statistics

Threads
1,130,362
Messages
5,641,703
Members
417,229
Latest member
BODYCOTE

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top