•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
Tagged with
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#Excel compatibility
#Excel alternatives
#roman numerals
#filter
#Microsoft 365
#text conversion
#=ROMAN()
#Excel
#filter option
#multiple tags
#table
#input range
#overlap exclusion
#combination filtering
#number interpretation
#criteria mismatch