View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nitya Satheesh Nitya Satheesh is offline
external usenet poster
 
Posts: 41
Default column comparison

hi!,
this is what my data looks like,

A B
1 a
1 b
1 b
3 b
3 b
3 c
4 b
4 b
5 d
6 e
7 d

now i need to display all unique values of column a but that should include all repeated values of column b.

so for example, if column a has 1 it should display both 'a' and 'b'. now i know i can take unique values but that doesn't really work because for 1 the corresponding value that is displayed is only 'a'.

Please help !