MULTIPLE ENTRIES IN ONE CELL
I have a sheet which includes delivery location (s). The default has one
delivery location along with the delivery date & time, time to unload, an odometer reading on arrival, and the date & time leaving the location. These data are used in several different ways elsewhere in the sheet and work fine. HOWEVER; on occasion, there will be several delivery stops ( with associated data) involved. I need to set up a way to A) show the information; B) be able to use the data in formulae. At present, all stops show in the same cell. (that's OK for "seeing") but any processing returns the #value error. I could set up a new row for each stop... (leaves mucho dead cells and formulae tend to fail). Can also put the additional stops into a table; but how to access and use for calculations..... Ideas, suggestions........................ Thnx for assistance.... REMEMBER: Do not meddle in the affairs of dragons; for you are crunchy... and taste good with ketchup!!!!!!!!! |
All times are GMT +1. The time now is 03:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com