•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Filtering roman numerals while excluding overlap in numbers
I would like to filter within a table that includes roman numerals and multiple tags. When using the normal filter option III is included when filtering for II which isn't what I am looking for. I also wouldn't like to exclude III as it is possible that it appears as a combination of II, III for example. Any ideas?
I was hoping that by using =ROMAN() Numbers would be regarded as Numbers but they are converted to text, so this isn't helful.
I am using Microsoft 365 for Enterprises
[link] [comments]
Want to read more?
Check out the full article on the original site