|If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.|
||Thread Tools||Display Modes|
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
Thnx for assistance....
Do not meddle in the affairs of dragons; for you are crunchy...
and taste good with ketchup!!!!!!!!!
|Thread||Thread Starter||Forum||Replies||Last Post|
|multiple entries per cell to save on table size?||bactfarmer||Excel Worksheet Functions||3||January 30th 07 07:41 PM|
|how do i enable multiple entries in the same cell under a label?||triptianil||Excel Worksheet Functions||2||September 14th 06 05:51 PM|
|Extracting multiple entries in a cell into their component pieces||Bob||Excel Worksheet Functions||15||June 21st 06 01:07 AM|
|How do I Select Multiple entries from Valid list for a Cell||WIDBIS||Excel Discussion (Misc queries)||1||June 29th 05 12:53 AM|
|Multiple Employee Name Entries in One Cell||Dave||Excel Discussion (Misc queries)||1||June 17th 05 03:33 AM|