View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default multiple entries per cell to save on table size?

You can certainly do that.......however, what is this table used for? Will
you need to use formulas to extract data from this table? If so, what you
want to do will make things more difficult.

Biff

"bactfarmer" wrote in message
ups.com...
Can a single cell contain multiple possible entries to cut down on the
size of a table.

I would prefer have this
100-150 Apple
151-200 Orange
201-250 Kiwi

I would not prefer to have this
100 Apple
101 Apple
102 Apple
etc
151 Orange
152 Orange
153 Orange
etc
201 Kiwi
202 Kiwi

Thanks
bactfarmer