Multiple values

[camposcarmo]

Small exemple.

Column 1____Column 2
ASD_________TEXT1
QWE_________TEXT2
RGB_________TEXT3
ASD_________TEXT4
QWE_________TEXT5
ASD__________TEXT6

So, this means that i have duplicate values on column 1 and when i seach, for exemple - "ASD", i want to get the 3 anwsers "TEXT1", "TEXT4" and "TEXT6", and each one in a diferente cell.

Column1____Column2
ASD_____TEXT1
_________TEXT4
_________TEXT6


Can anyone help me.

Thanks[/b]

 

[lenze]

Hi and welcome to the board!!

Just use a Pivot Table, which will turn this

  A    B     
1 NAME ITEM  
2 ASD  TEXT1 
3 QWE  TEXT2 
4 RGB  TEXT3 
5 ASD  TEXT4 
6 QWE  TEXT5 
7 ASD  TEXT6 

Sheet2

[Table-It] version 07 by Erik Van Geit

into this

   D    E     
 6            
 7 NAME ITEM  
 8 ASD  TEXT1 
 9      TEXT4 
10      TEXT6 
11 QWE  TEXT2 
12      TEXT5 
13 RGB  TEXT3 

Sheet2

[Table-It] version 07 by Erik Van Geit

lenze

 

[NateO]

Hello,

Select column A, Click Data->Filter->Autofilter. Autofilter Column A, copy and paste the return cells somewhere else and remove the filter.

Edit: Or what Lenze said.