View Single Post
  #3   Report Post  
TRE
 
Posts: n/a
Default

If the visitor sheet has multiple entries for each date, because each person
signs in with the day, try using a pivot table with count in your data area
and date as a row heading. Or, if one line in the visitor book can have more
than 1 visitor (e.g. a group is signed in), use sum in the data area. The
pivot table can also be sorted by decreasing number of visitors.

"Natarajan Ganesan" wrote:

I have imported the site vistor data into a spreadsheet. I wish to sort the
dates by number of visits for each day. So I would probably end up counting
the visits for each day. What function in Excel allows me to do this?