View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Simna Simna is offline
external usenet poster
 
Posts: 1
Default unique values among duplicates without considering specific words

unique values among duplicates without considering specific words from
different columns.
Ex; column A Column B
1 abc del
2 abc
3 abc
4 bcd del
shud result in 1 (i.e; does not count the data which has del in column B,
also no duplicates in Column A)