Prev: Receive data in column with pull down
Next: i enter value in one column the next column existing value turn 0
From: Rich Stone on 12 May 2010 06:37
First time in the Excel Section... Be gentle please!

I have a spreadsheet which lists all visits by all clients. With this
information, I wish to create a report that lists the most frequent visitors.
I think that the best way to do this is to group the client visits so I can
see how many visits each client has made and then sort the clients by this
number of visits. I really don't know where to start on this!

Any help please?
From: ozgrid.com on 12 May 2010 06:41
Hello,

Probably a PivotTable
http://www.ozgrid.com/Excel/excel-pivot-tables.htm



--
Regards
Dave Hawley
www.ozgrid.com
"Rich Stone" <RichStone(a)discussions.microsoft.com> wrote in message
news:6CD2E06A-CBEF-473A-9C65-4F9798AC5816(a)microsoft.com...
> First time in the Excel Section... Be gentle please!
>
> I have a spreadsheet which lists all visits by all clients. With this
> information, I wish to create a report that lists the most frequent
> visitors.
> I think that the best way to do this is to group the client visits so I
> can
> see how many visits each client has made and then sort the clients by this
> number of visits. I really don't know where to start on this!
>
> Any help please?

From: Rich Stone on 12 May 2010 09:21
Thanks for your reply. Could you possibly explain how I would do this? I'm
afraid my excel skills don't stretch too far in this aspect and I've never
used pivot tables.
From: Glenn on 12 May 2010 09:55
Rich Stone wrote:
> Thanks for your reply. Could you possibly explain how I would do this? I'm
> afraid my excel skills don't stretch too far in this aspect and I've never
> used pivot tables.

Besides the link already provided by Dave, you can also look here for
introductions to PivotTables:

http://peltiertech.com/Excel/Pivots/pivotstart.htm

Check them out and see if you can work it out. They are not that difficult.
Otherwise, without a lot more information about your worksheet layout, it would
be difficult to help further.
From: Rich Stone on 12 May 2010 10:58
Thanks for the link, but I'm still in the dark on how this will help me. As
you suggested, here's some more info...

The spreadsheet is basically a table with the headings of:
- Visit date
- Client reference
- Client name
There are over 1000 clients included in the table with up to 20 visits per
client in some cases.

There are two steps I need to take. Firstly, count how many visits are
recorded per client. Secondly, list the top 10% of the most frequent
visitors. It sounds so simple but I am really struggling!
 |  Next  |  Last
Pages: 1 2
Prev: Receive data in column with pull down
Next: i enter value in one column the next column existing value turn 0