MrExcel’s Learn Excel #980 – Dueling: Wildcard Match
March 28th, 2009 learn accounting
Mike Girvin and Bill Jelen meet up again to offer three solutions to the problem of counting how many records match a wildcard criteria.Episode 980 shows you how. 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! …
Duration : 0:6:18
MrExcel's Learn Excel #968 - Keep Headings
ExcelIsFun 28Mar09
Dear amianondito,
…
Dear amianondito,
Yes, dynamic criteria always makes Excel more fun!!
–excelisfun
amianondito 28Mar09
I liked yours …
I liked yours because of the ability to use dynamic criteria. It’s the same reason I liked MrExcel’s method better on the last lookup challenge.
You’re both awesome!
ExcelIsFun 28Mar09
Dear amianondito,
…
Dear amianondito,
Thanks for the vote!!!
But
The two methods that Mr Excel showed are clearly the best for most Excel users (The vast majority of people do not know how to use wildcards or the ampersand). The method that I used is clearly best because it shows all three at once.
Now who really won?
Only Context knows who really won!!
–excelisfun
rickcjohnson 28Mar09
Really enjoyed the …
Really enjoyed the podcast! Watched it twice and look forward to the next one. I also like the theme song!!!
bjele123 28Mar09
We already have one …
We already have one in the works for next Friday! I’ll try to even the score, but I already like Mike’s answer better than mine!!!
amianondito 28Mar09
I am an official …
I am an official nerd. I love this, including the theme song
Mike won this round, I’m afraid. Bring on more challenges!!
bjele123 28Mar09
Why under five …
Why under five minutes?
When I was first thinking about podcasting, I checked out other tech podcasts. There was, at the time, a podcast called the Two Minute Photoshop Podcast. The first episodes that I watched were 7 and 9 minutes and it struck me that the guy wasn’t living up to his contract of showing something in two minutes. Since I promise a tip in 2-3 minutes, I don’t want to infringe on your time and make it be a longer podcast.
ExcelIsFun 28Mar09
Dear Team,
3 …
Dear Team,
3 methods to make different sorts of people happy:
1) Filter & SUBTOTAL solution good for: a) Don’t mess with criteria syntax b) Works in all versions
2) Table & SUBTOTAL solution good for: a) Don’t mess with criteria syntax b) Works only in 2003 & 2007
3) COUNTIF and criteria syntax solution good for: a) Mess with criteria syntax b) Works in all versions
–excelsifun
planiolro 28Mar09
I think it is a …
I think it is a good solution for this dual approach.Having 2 solutions help you to understand much better and faster the solutions.Why do you want to keep the videos under 5 min?Mike has awesome videos on his channel but none of those awesome videos are under 5 min, since he is explaining everything in great detail.Bottom line: awesome video and Mike’s idea seems more appealing. You aare doing an excellent job.
Leave a Reply