Thread: Please help me!
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Domenic
 
Posts: n/a
Default Please help me!

If you don't mind having the values in separate cells, assuming that
A2:C10 contains the data, let E2 contain the date of interest, such as
05/01/1997, let F2 contain the costumer of interest, such as ROSSI, and
then try the following...

G2:

=SUMPRODUCT(--($A$2:$A$10=E2),--($B$2:$B$10=F2))

H2, copied across:

=IF(COLUMNS($H2:H2)<=$G2,INDEX($C$2:$C$10,SMALL(IF ($A$2:$A$10=$E2,IF($B$2
:$B$10=$F2,ROW($C$3:$C$10)-ROW($C$3)+1)),COLUMNS($H2:H2))),"")

....confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!

In article ,
"LuckyStar" wrote:

I have di rows:

02/01/1997 BIANCHI Automobili
02/01/1997 BIANCHI Barche
05/01/1997 ROSSI Foto
05/01/1997 ROSSI Video
07/01/1997 VERDI Spettacolo
08/01/1997 NERI Modellismo
10/01/1997 VERDI Moda
12/01/1997 VERDI Viaggi
13/01/1997 ROSSI Sport


I need a way to search by date = "05/01/1997" and costumer = "ROSSI" and get
as result in a cell a string with "Foto, Video"
is it possible??? Please help me!