Hi,

Create a pivot table. Drag Name to the row area and Account to the column
area. In the data area, drop the account (once again).

Hope this helps.
--
Regards,

Ashish Mathur
Excel MVP
(www.ashishmathur.com)


"bletch23" wrote:

Hi,

I'm trying to create spreadsheet that utilizes data in two different rows.
The spreadsheet is meant to track types of accounts assigned to a number of
associates I work with.

The first row logs the name of the employee who receives the account. To the
right of this in the second row is logged the type of account received, as an
example we could use 'simple', 'medium' and 'hard'. With this in mind, the
table could look like something like this:

Matt Simple
Matt Medium
Jennifer Simple
Jennifer Hard
Michael Hard
Matt Simple
Jennifer Medium, etc.

My question is, how do I generate a function that not only:
1. Logs the number of accounts assigned to each employee
2. But also has three columns which log the type of account (simple, medium,
or hard)

I'm having a difficult time finding a formula that will search for the
employee name, check the type of value on the row to the right, and then log
the data. Any ideas? Any help would be greatly appreciated!