since no one else has answered...............
could you use auto filter on the dates? it wouldn't produce results
in the same format that you mentioned in your 2nd example, it would be
the same format as the original list.
just an idea.
:)
susan



On Aug 17, 8:56*am, mark wrote:
Hi probably a silly one but i want to make a list of people to be seen on a
specific date, my data is in a table where column one is a date list and
subsequent columns are headed with clients names. Data is recorded against a
date as the number of reviewsthatclient has had so the sheet look *something
like this

* * * * * *AB * *CD * * *EF * * GH * * *IJ
01/01 * *1 * * * * * * * *3 * * * * * * * *1
01/02 * * * * * *2 * * * * * * * * 4
01/03 * * * * * * * * * * *4 * * * * * * * *2
01/04 * *2 * * *3 * * * * * * * * * * * *
01/05 * * * * * * * * * * * * * * * 5

It would be great ro be able to type in a date and have a listof those to be
seen and whatnumber review it is produced to print off: to look alittle like
this:

Date * * Client * * * Review No
01/04 * * AB * * * * * * *2
01/04 * * CD * * * * * * *3

Cananyone help?