A Microsoft Excel forum. ExcelBanter

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.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

MULTIPLE ENTRIES IN ONE CELL



 
 
Thread Tools Display Modes
  #1  
Old October 10th 07, 10:37 PM posted to microsoft.public.excel.misc
BOATS
external usenet poster
 
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!!!!!!!!!
Ads
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

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 08: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 02:30 AM.


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