View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bactfarmer bactfarmer is offline
external usenet poster
 
Posts: 9
Default multiple entries per cell to save on table size?

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