|Peter Greene 🇨🇦||02/12/2021 01:55:02|
|356 forum posts|
I couldn't really see what your formula did for me Michael .... but then I readily admit to being as thick as three short planks when it comes to spreadsheets.
I really thought there would be a simpler answer. There is an existing function (on the right click button) which says "Delete entire row" .... it's what I use to do it manually - either one row at at time or CTRL or SHIFT select for multiple rows. (And in all honesty, it doesn't take that long - it's just tedious).
I thought there might be a way of checking a cell and invoking the aforementioned function if the cell is empty.
| Edited to kill the stupid smiley things "
(Wouldn't it be nice if we could do inline responses? Real ones I mean.)
Edited By Peter Greene on 02/12/2021 01:57:34
|Michael Gilligan||02/12/2021 07:06:26|
19604 forum posts
Column B shows your current stock-count
Column C is the quantity that you like to have in stock
Column D makes the decision whether you should buy more
Column E tells you how many to buy [to restore your preferred stock-level]
If you print it out, complete with the blanks, then ; when the Supermarket has a special offer … you can easily make an informed decision ‘on the hoof’
Edited By Michael Gilligan on 02/12/2021 07:07:14
7924 forum posts
And if really keen, Michael's approach can be extended by adding more columns, such as:
Column F - Due-Out (quantity booked for later consumption, such as tomorrows dinner.)
Column G - Future Requirement (quantity known to be required in future, such as Xmas Turkey)
Column H - Due-In (quantity ordered in advance but not delivered yet)
Column I - Lead Time (time taken between reordering and actual delivery)
Column J - Shelf Life (time after which the item goes bad, such as Milk)
and many more...
I write lists on the back of an envelope and forget to take them with me...
Please login to post a reply.
Want the latest issue of Model Engineer or Model Engineers' Workshop? Use our magazine locator links to find your nearest stockist!
You can contact us by phone, mail or email about the magazines including becoming a contributor, submitting reader's letters or making queries about articles. You can also get in touch about this website, advertising or other general issues.
Click THIS LINK for full contact details.
For subscription issues please see THIS LINK.