Hi, I seem to be having a mental block. I want to set up a spreadsheet to
track the condition of 48 knives on a piece of equipment. The equipment is
checked once a week and each knife is reported on as follows - OK, Worn,
Hole. I want to be able to analyze the data either using a chart or a pivot
table but can't seem to figure out the best way to set up the data so that it
can be pulled either by Knife # or by condition. Any suggestions?

I would use one row for each entry into the table.

Headers in row 1

Each row gets enough info to completely define that entry.

Column A--Knife indicator
Column B--Date (or date+time???)
Column C--Status/Condition

Now I have enough details to build that pivottable or just autofilter that
table.


Carla wrote:

Hi, I seem to be having a mental block. I want to set up a spreadsheet to
track the condition of 48 knives on a piece of equipment. The equipment is
checked once a week and each knife is reported on as follows - OK, Worn,
Hole. I want to be able to analyze the data either using a chart or a pivot
table but can't seem to figure out the best way to set up the data so that it
can be pulled either by Knife # or by condition. Any suggestions?

--

Dave Peterson