Forum Discussion
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"...
For the advanced filter to group by level, just write the following formula in the Criteria Range:
= TEXT ("1 *"; "General")
The 1 * represents everything that follows next to what is to the right of the "1".
The "General" is not essential but makes you sure the comparison is against a text.
Hope this helps!