Wild cards - Excel World Cup Boot Camp Day 4

  Рет қаралды 778

Diarmuid Early

Diarmuid Early

Күн бұрын

Today's video is all about wildcards, which can represent one or more unknown characters in a string pattern - what they are, and how to use them.
This video is part of a bootcamp for people interested in trying out the Excel esports battles - or just improving their Excel skills. You can find the intro video for the course here:
• Excel esports boot cam...
And the playlist, which will include all the videos from the course, is here:
• Excel esports boot camp
====================================
Here's a link to the workbook with the example I went through in the video:
1drv.ms/x/s!Aryypvyx4xIO7E7dg...
====================================
If you want to download some of the cases I talked about today and will be talking about over the next couple of weeks, the ‪@FMWC‬ team has kindly made a selection of them free to people following our course. You can get cases 2 to 6 from last year's series (Bear Island by Harry Seiders, Laundry Time by Peter Scharl, What's My Flight Number by Patrick Chatain, Battle Royal by Harry Seiders, and Fantasy Excel by Peter Scharl) for FREE between now and the first battle of this year's series (Jan 26) with the code BOOTCAMP.
They're the first four cases here, and the last one on the page before:
fmworldcup.com/product-catego...
====================================
If you want to get the workbook Giles prepared that walks you through the basics of all the main functions we'll be talking about in the next couple of weeks (including explanations, examples, and exercises), you can get that here:
drive.google.com/drive/folder...

Пікірлер: 6
@petercompton538
@petercompton538 5 ай бұрын
Thanks once again - great Bing story 😂😂
@DimEarly
@DimEarly 5 ай бұрын
It was too funny not to share! And thanks, I'm glad you're enjoying them!
@ExcelWizard
@ExcelWizard 5 ай бұрын
3:30 for COUNTIFS ,SUMIFS escape character for > < is = =COUNTIF(D19:D21,{"=A";"=>C";"=
@DimEarly
@DimEarly 5 ай бұрын
Thanks! Now I see it, I do remember having to work this out once before - I was counting responses to a survey that included things like "90", etc.
@divangouws4365
@divangouws4365 5 ай бұрын
Hi Diarmuid. While >C does not produce any matches, to some other value that we assume not to be present in the text, apply our desired formula and convert it back if necessary, as a workaround.
@DimEarly
@DimEarly 5 ай бұрын
Sorry, you're spot on that what I wrote is incorrect - counting "
Working with cell colors - Excel World Cup Boot Camp Day 11
15:44
Diarmuid Early
Рет қаралды 1 М.
Split text into letters - Excel World Cup Boot Camp Day 2
8:34
Diarmuid Early
Рет қаралды 1,1 М.
Каха ограбил банк
01:00
К-Media
Рет қаралды 10 МЛН
⬅️🤔➡️
00:31
Celine Dept
Рет қаралды 52 МЛН
🌊Насколько Глубокий Океан ? #shorts
00:42
Count occurrences of text - Excel World Cup Boot Camp Day 1
10:30
Diarmuid Early
Рет қаралды 1,6 М.
What's The Secret Strategy For Trading?
0:33
Umar Ashraf
Рет қаралды 401 М.
Linear LED Clock
1:03
Andrei Erdei
Рет қаралды 2,1 М.
Regex day 2 - Extracting matches
31:02
Diarmuid Early
Рет қаралды 868
Photo finish! Losing Road to Las Vegas round 3 by 25 seconds
24:36
INDIRECT and friends - Excel World Cup Boot Camp Day 7
10:54
Diarmuid Early
Рет қаралды 992
RTLV round 1 walkthrough - Doggie Daycare by David Brown
34:11
Diarmuid Early
Рет қаралды 664
The surprising value of a function that does nothing
17:14
Diarmuid Early
Рет қаралды 1,9 М.
Excel World Cup - Pass the arrows, by Peter Scharl
42:29
Diarmuid Early
Рет қаралды 495