Related:
- List unique values from multiple columns
- My contacts list names - Guide
- Excel data validation list from table multiple columns - Guide
- Whatsapp country code list - Guide
- How to change your best friends list on snapchat to 3 - Guide
- Allow multiple downloads chrome - 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