The whole point of putting a list in a spreadsheet is so that you can sort it by various columns so you can easily see just how many you have of each color, size, perversion, or whatever talents you included.
It seems to me that I've done this before and somehow the numbers magically stayed with their item. I just finished making a list today and when I sorted it by color, the data in the item-number column disappeared. Hmmm, that's not good. Control-Z brings it back. I kind of suspected it was too good to be true, so I am not disappointed. I just have to figure out how to convert these formulas to numbers. Turns out it is simple enough:
- insert a column adjacent to the item number column
- select the item-number column and COPY (Control-C)
- select the new, empty column
- from the EDIT menu, select PASTE VALUES
- delete the original item number column
No comments:
Post a Comment