A
Arnie
Hi,
Is it possible in excel te look in a database for more than one criterium?
Example database (a1:d4)
Name Date Product-X Product-Y
John 1-1-2004 4 0
John 2-1-2004 1 0
Pete 10-1-2004 1 1
Find all sold products from: 1-1-2004 (cell b6)
to: 7-1-2004 (cell b7
By John and Pete
Output should look like this:
Name Product-X Product-Y
John 5 0
Pete 0 0
Thanx in advance,
Arnie
Is it possible in excel te look in a database for more than one criterium?
Example database (a1:d4)
Name Date Product-X Product-Y
John 1-1-2004 4 0
John 2-1-2004 1 0
Pete 10-1-2004 1 1
Find all sold products from: 1-1-2004 (cell b6)
to: 7-1-2004 (cell b7
By John and Pete
Output should look like this:
Name Product-X Product-Y
John 5 0
Pete 0 0
Thanx in advance,
Arnie