Related:
- List unique values from multiple columns
- Display two columns in data validation list but return only one - Guide
- Counter strike 1.6 cheats list - Guide
- All contact number list with name - Guide
- How to change your best friends list on snapchat to 3 - Guide
- Amd crossfire compatibility list - Guide
2 responses
Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Oct 19, 2009 at 08:12 AM
Oct 19, 2009 at 08:12 AM
Hello there,
A workaround
In a blank column put the formula = if(A1&B1&C1 =A2&B2&C2,"",1)
where A1, B1 & C1 refer to your three categories
Filter to remove blanks
A workaround
In a blank column put the formula = if(A1&B1&C1 =A2&B2&C2,"",1)
where A1, B1 & C1 refer to your three categories
Filter to remove blanks