0 Comments
|
Be the first to comment
0 Comments
|
Member has blocked you from commenting
Confirm Block
Are you sure you want to block this member?
This member will not be able to send you messages, comment on your videos/profile or subscribe to your channel.
You can cancel blocking anytime from the member's page
10 Subscribers [ 1 hidden ]
- Recently Added
- Most Discussed
- Most Viewed
- Highest Rated
Duel: Portugal - 1139 - Learn...
Added 13-Nov-09
Rated 4.33 | 7 Views | 0 Comments
A viewer from Portugal sends in a
question about finding which row
contains the match. Episode 1139 shows
you a few ways to go!
This blog is the...
Submitted by: MrExcel
06:09
Avoid a Loop - 1140 - Learn...
Added 09-Nov-09
Rated 0.00 | 3 Views | 0 Comments
A cool way to streamline a VBA loop
using SpecialCells. Episode 1140 shows
you how.
This blog is the video podcast companion
to the book, Learn Excel...
Submitted by: MrExcel
04:53
TRIM VLOOKUP Table - 1138 -...
Added 05-Nov-09
Rated 4.33 | 6 Views | 0 Comments
Rod from Cincinati asks how to solve the
problem of trailing spaces in the lookup
table. I had never tried it before, but
you can apply a TRIM to the...
Submitted by: MrExcel
02:47
Removing Hyperlinks - 1137 -...
Added 04-Nov-09
Rated 0.00 | 6 Views | 0 Comments
In Episode 1137, a cool way to remove
all hyperlinks from a spreadsheet.
This blog is the video podcast companion
to the book, Learn Excel 97-2007...
Submitted by: MrExcel
01:25
AutoFilter Some - 1136 - Learn...
Added 03-Nov-09
Rated 0.00 | 5 Views | 0 Comments
Mary from Louisiana passes along a cool
tip for applying AutoFilter dropdowns to
a subset of your records. Episode 1136
shows you how.
This blog is...
Submitted by: MrExcel
02:06
Embedding Lookup - 1135 -...
Added 02-Nov-09
Rated 4.33 | 6 Views | 0 Comments
Nick asks how to do a pretty lengthy
bonus calculation. It might be too
complex for the Excel 2003 nested IF
limit, so I decided to use the range...
Submitted by: MrExcel
03:19
Duel: Index:Index - 1134 -...
Added 30-Oct-09
Rated 0.00 | 13 Views | 0 Comments
Today's Dueling Excel Podcast is a
question sent in by Hassan. Hassan wants
to enter a name and a through-month and
then add up that person's sales...
Submitted by: MrExcel
07:47
ADM Calculation - 1133 - Learn...
Added 29-Oct-09
Rated 0.00 | 6 Views | 0 Comments
Patricia called the other day with a
problem which will be familiar to
everyone who works in a public school
district. The state pays the school
for...
Submitted by: MrExcel
02:38
Filling Quarters - 1132 -...
Added 28-Oct-09
Rated 0.00 | 5 Views | 0 Comments
The Excel fill handle is really cool
with quarters. But wait....it can not do
quarters and years. But wait...it can do
them but in a hideous format....
Submitted by: MrExcel
04:10
Increase Chart Font Size -...
Added 27-Oct-09
Rated 0.00 | 7 Views | 0 Comments
of the text in a chart at once. Episode
1131 shows you how.
This blog is the video podcast companion
to the book, Learn Excel 97-2007 from
MrExcel....
Submitted by: MrExcel
01:33
