You can see what models used each label, and how long a model was made. I tend to be a visual person, so organizing by color makes it easier to see for me.Īfter breaking the numbers out into model numbers, I figured I would take it a step further and break it out into Labels. I also use Conditional Formatting to automatically add a color to cells based on what Yamaha model number I enter. The only time I have to edit the chart is if I add a new model to the other sheets. ![]() These functions allow the chart to be automatically updated (live) because it’s using data from other sheets in the file. I found the COUNTIF and COUNTIFS functions in MS Excel allowed me to count cells in a range based on certain criteria such as model number, text, or even count cells that have anything in them. ![]() Being slightly obsessed with numbers, I was curious about the distribution of 1729 serial numbers and 267 date codes I’ve collected.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |