| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unsure how to set up spreadsheet
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| unsure how to set up worksheet to capture data | Excel Discussion (Misc queries) | |||
| Unsure what formula to use | Excel Discussion (Misc queries) | |||
| Unsure of which forumla to use ? | Excel Discussion (Misc queries) | |||
| Unsure of the Function, and How to Write It | Excel Worksheet Functions | |||
| Unsure about which functions to use | Excel Worksheet Functions | |||
Threaded Mode
