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!
|