•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Excel not filtering unique values
I have 2 columns of data mostly the same data but 1 column has more than the other and I want to highlight the unique values to remove them. But when I use the conditional formatting and highlight unique values, it only does a few of the unique ones but not all. And I can see for a fact that it’s missing unique values. Anyone know how to fix this?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel
#Unique Values
#Conditional Formatting
#Data
#Columns
#Filtering
#Highlight
#Remove
#Data Cleaning
#Spreadsheet
#Formula
#Rows
#Error
#Missing Data
#Sort
#Data Validation
#Function
#Range
#Worksheet
#Cell