Sorry to be smart, but if we help, do we get the job? :)

Maybe can put it into somewhat simpler/logical language: You're looking for
the number of times that an individual has failed. Basically you need a
pivot table. :) The data range of your pivot table is determined by the last
row of data that has information... I.e., if the names column has an entry
at every row until there are no more entries, then if you determine the last
row that has any data, you can set the range of your pivot table to be from
the top of the spreadsheet to the bottom. Or just select any cell that has
data in the header, and provided that every column to the end has a header,
you can create a pivot table.

Your Row field will the name column, your Drop Data information will be a
column that has data in every row. Your Page Field will be the Pass/Fail
column.
The Drop Data should be a Count not a sum.

When the page field 'Failed' is selected, you will have a count next to each
name of the number of times that an individual failed.

If you want to see pass and fail next to each other, then drag the pass/Fail
column data into the columns field.

Voila you're done. No programming necessary, and a minimal amount of work
is to be done to accomplish your task. Work smarter, not harder.



"steven_senko" wrote:


Ok here's my issue.......

I'm going to be getting a new job at work but in order for me to get it
there's a certain formula or macro that I need to write and I'm
completely lost.

The situation is this, I work for a major computer company and every
week we get a spreadsheet that has every individual service that our
call center has setup. What I do is I go through all the information
and basically fail or pass the service based on whether process is
followed. So every week a new spreadsheet is added to the workbook
with the previous week services, now I have a constant spread sheet
called "Repeat Offenders", basically what I'm trying to do is make a
formula or a macro that will search the I collumn (pass or fail column)
from row 2 and down and the A column (the name collumn) from row 2 down
so that the the services that I deam have failed on the weekly
spreadsheets will be tallied next to the agents name on the repeat
offenders spreadsheet which will just have a list of the agents names.

I don't know what to do with this and any help would be greatly
appreciated.


--
steven_senko
------------------------------------------------------------------------
steven_senko's Profile: http://www.excelforum.com/member.php...o&userid=30417
View this thread: http://www.excelforum.com/showthread...hreadid=500849