Please help: A way to find multiple rows??

L

LuckyStar

I have a problem that I'm not able to solve:
Check this table:

DATE CUSTOMER RIVISTA
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

I would like to search by DATE and CUSTOMER column and get RIVISTA
fileds as result:confused: !
I.E: find by "05/01/1997" and "ROSSI" and get as result a string with
"Foto and Video". Maybe it could be fine also an array instead of a
string...but then I don't know how I can get values from array.

Any suggestions will be very appreisiated!!!!!
Thanks.
 
L

LuckyStar

CLR said:
Take a look at Data > Filter > AutoFilter......

That way let me search rows...but I need also to copy values in anothe
cell like a string. (i.e. "Foto, Video").
Is there a way
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Please help me! 4
How to find the year from a given date 2
Please help with Column to row formatting 7
How to do a lookup using multiple values 4
Advanced problem using auto-number and datediff to find readmissio 1
fixing a table to conform to current system 3
How to Find the Date of Last Change in Inventory 15
Please help with formula (multiple ifs to determine due date) 3

Top