Data Organization

[workindan]

Hello, new to the forums, thanks for taking the time to look over this.

I'm looking to organize a set of data using either a pivot table or other summarizing/reporting method. Here is a breakdown of what I'm organizing:

Department, Name, Audit Type, Week of Audit
The only thing is that each person's audits vary without pattern. For example, one week Joe might have audit type B and A, then the next week audit type C, the following week none at all, then the fourth week audit type D only...etc. The data recorded for each audit is Pass or Fail. They happen weekly for each individual.

So the question is, with a several departments, a dozen people per department, and the varying audits with p/f conditions - what's the best way to organize a year's worth of this data as time goes by, and then to summarize/report? I'd thought of laying out a massive column sheet for the user to plug into (color coded for ease of use, since it would be huge) and then using vba or countif to tally up the pass and fail for each person, but that seems really bulky and ugly. Or there's a pivot table, which seems tricky with the varying data fields per person.

Thoughts? The help is greatly appreciated!

Thanks,
Dan

[royUK]

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!