seems like everybody is using either a conditional format or some other
means.

i'm looking for something that looks up TODAY as a date, then looks over at
a customer ID, and THEN looks at FUTURE bookings for a one or more bookings
by that SAME customer, finally tallying how many of TODAY's customers have
FUTURE bookings. with approximately 100 appointments a day, it's hard to
track this manually. i'll keep looking for an answer in this thread, and
if any programmers want more specific info, i would be happy to pay for help.


would it help if i imported the datafile into access? then is there a
query or something? i'm pretty amateur at this, but not computer stupid.

neil

"neil" wrote:

i have repeating customers that book appointments in advance. this
appointment list winds up in an excel sheet. i want to find future
appointments that have the same client ID as an appointment today (to find
out how many of my current customers are booked for future visits).

neil