Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 10th 07, 10:37 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2007
Posts: 1
Default 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!!!!!!!!!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
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


All times are GMT +1. The time now is 01:11 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017