Minnaar has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Trump cards
I would like to use a sumif formula with not equalt to a certain word and I know one can use a trumpcard (or special character) to do this. What are all the trumpcards in excel?
RE: Trump cards
Hi Minaar
Thank you for your question.
The trump cards, or wildcards as they are more commonly known, are ? (question mark) for a single character, e.g. organi?ation will find organisation and organization; and * (asterisk) for multiple characters, e.g. org* would find organise, organize, organising, organizing, organisation, organization and anything else that started with the letters org.
I hope this helps.
Amanda