| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter a list of names!
Hi there!
I'v got a spreadsheet which lists names of clients (surname, first name), dates they last visited so on. I would like to be able to fill, in a cell, the surname and first name of a client and a list is produced of all the visits that person made. But if if it`s the first visit, it would indicate this with a message. -- George |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Filter a list of names!
go in the help and type in "advanced filter"
read the section on filtering by using advanced criteria, and try to test some of the examples using this, you can set your sheet up with another area where you can filter by surname and first name for all the entries for a particular client. then you could sort by date. -- Allllen "George" wrote: Hi there! I'v got a spreadsheet which lists names of clients (surname, first name), dates they last visited so on. I would like to be able to fill, in a cell, the surname and first name of a client and a list is produced of all the visits that person made. But if if it`s the first visit, it would indicate this with a message. -- George |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Filter a list of names!
Thanks for getting back so quick. Is there a way to do this using vb codes?
-- George "Allllen" wrote: go in the help and type in "advanced filter" read the section on filtering by using advanced criteria, and try to test some of the examples using this, you can set your sheet up with another area where you can filter by surname and first name for all the entries for a particular client. then you could sort by date. -- Allllen "George" wrote: Hi there! I'v got a spreadsheet which lists names of clients (surname, first name), dates they last visited so on. I would like to be able to fill, in a cell, the surname and first name of a client and a list is produced of all the visits that person made. But if if it`s the first visit, it would indicate this with a message. -- George |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| create a random list of names from a list of names in EXCEL | Excel Worksheet Functions | |||
| How to filter list from pre-existing list | Excel Discussion (Misc queries) | |||
| auto updating list | Excel Worksheet Functions | |||
| The filter didn't show all (2,254) names when I set it up | Excel Discussion (Misc queries) | |||
| looking up names in a list | Excel Worksheet Functions | |||
Linear Mode
