hi mike (and joel), my apologies but i've been out of the office most of this
week. there is a work around, in the instructions i sent previously, for
getting unique values: asking for "average of place" returns an error but
there is an option to replace an error value with the value of one.

therefore, if a certain place is visited by a person two, three, or more,
times in one day the pivot table will return an error which, by specifying in
the options menu, will return the number 1. if there are no visits then the
space is left blank.

resulting pivot table has values you need to calc unique visits, you just
need the subtotals . .

you shouldn't use GETPIVOTDATA (one of more unwieldy formula) just get
values. click on the bottom right cell of pivot table, highlight all the way
left, and then go up to row with dates . .

hi joel, that's pretty nifty code(!), wouldn't it make sense to have
additional, or separate, sub that goes over grid and replaces places names
with a count of places. i can't think of formula that can do that easily.

hope you're well, that two combo boxes in single userform model is on hold
as the two userform method is working out fine. i do intend to finish that
though, will send it when it's finished.

hope you both have a great weekend!