Frankly, it's so easy to screw up a record in an excel spreadsheet, I wouldn't use it to record layaways... unless you're also keeping paper records as a backup. But if you can describe what you're trying to do, I may be able to help you with the formula. I would recommend you use a database program such as Access for this, but it's been probably 15 years since I last used it so I can't help you there.
Recording serial numbers, on the other hand, is a great use for excel, since you are not going to be changing the data for a customer once entered. But it still requires care to make sure you are not accidentally writing over the wrong record. |