Excel Magic Trick 1217: D Functions: Text Criteria: “Starts With”, “Exact” and “Contains”

For Text Criteria in D Functions (Like DSUM, DCOUNT, DMAX) learn about the difference between: “Starts With”, “Exact” and “Contains” Criteria.
1. (00:10) Problem Setup
2. (00:47) “Starts With” Criteria requires that you just type text into cell.
3. (01:08) Basics of D Functions Database Functions in Excel.
4. (03:03) “Exact” Criteria requires that you create a text formula with the text and the comparative operator equal sign.
5. (04:08) “Contains” Criteria requires that you use the wild card asterisk before and after the text, where asterisk is a wild card that stands for zero or more characters

Thanks to Excel.i Adam at YouTube!!

[MrXL]

Hey! Cool trick Mike! This solved my friend Derek's problem! Thanks!

[evgeniam]

Thanks a lot Mike for the amazing information :)

[HarishNarendrula]

Thanks for the video Very Interesting Highly Appreciated Please keep posting

[BillSzysz]

Thanks for video and interesting lesson  :-)
In this case, text insertion rules are the same as when we use an advanced filtering.
So, the second * is not necessary (as Excel.i Adam said)

[lbm]

Thanks so much! You make GREAT tutorials! I have a particular question I haven´t been able to solve looking through your very many videos... I want to write an IF formula that says "if you find this string of text in any of the cells in a certain range, write "yes" in this cell... How can I do it??

[pmsocho]

I can see that no one mentioned that we can also format the cells for criteria as text and then we can insert just:
Bellen
=Bellen
=(asterisk)Bellen(asterisk)

[ratexcel]

great video Mike! ;)
btw '=Bellen with apostrophe in front of equals sign instead of ="=Bellen" would also work

[levelzeroD]

Oh yeah also since I'm your nephew, can I join your excel team