ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Wildcard character (https://www.excelbanter.com/excel-discussion-misc-queries/25675-wildcard-character.html)

agenda9533

Wildcard character
 
I have a formula (SUMIF('Email Data'!O:O,"<.*",'Email Data'!P:P))

In this case what the Wildcard character "<.*" means?

Thank you

JE McGimpsey

"Is not equal to the period character, followed by zero or more of any
character"

so it excludes



All times are GMT +1. The time now is 01:45 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com