Excel advanced filter issues with multiple decimal style numbering
Howdy Folks, Currently running MS Excel professional 2019 and currently feel blocked by the advanced filter function. In column A, I have the title "Number" and in column B, the title "Description". Column A is formatted as text and contains the following style number system: 1 1.1 1.2 1.2.1.1 1.2.1.2 ...2.1.28 1.2.2 2 3 etc. etc. I basically then want to filter by column A, down to a certain level of detail. This level is included in the number format. As an example, I just want to see the top level - Ok, this is relatively straight forward with the filter as text option and would return just whole integer numbers 1 2 3 etc. I can add a second argument in the filter as text option, which gives me the start of the next level of detail e.g. =?.? However, when I want to filter any more than two levels (e.g. 1 & 1.1 1.2 1.3 etc) then I include a table with the syntax which I wish to filter. My table would read: "Number" in the header of column A, and then I would include operators like: ="=?" [Top level] ="=?.?" [2nd level] ="=?.??" [2nd level] ="=?.?.?" [3rd level] ="=?.??.?" …. and so on. The filter is not coping with returning the correct values, I assumed because it is still trying to convert the text back into a number, due to the single decimal. I therefore swapped the decimal sign for an accent " ` ", but this has not helped. Any other ideas how to filter multiple syntaxes of text would be very much appreciated? ;)
Advanced Filters, is it possible colA=("a" OR "b" OR "c") AND colB=("1" OR "2" OR "3") on one row?
Doing some diagnostics of mail delivery failures of messages within several domains all under the same Office 365 tenant. So, looking for messages with domains a.com, b.com, and c.com as part of both the SenderAddress and RecipientAddress this requires a criteria table nine rows tall as in: SenderAddress RecipientAddress =*a.com =*a.com =*a.com =*b.com =*a.com =*c.com =*b.com =*a.com =*b.com =*b.com =*b.com =*c.com and so on We have nine domains of interest which results in a criteria table 81 rows tall!! Not so easy to read the intent or be sure all domain pairs are identified. I've searched in vain for a way to do something like the following. Can anyone point me in the direction of a solution like this? SenderAddress RecipientAddress =*a.com OR =*b.com OR =*c.com =*a.com OR =*b.com OR =*c.com Thank you.