View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robert Hinson Robert Hinson is offline
external usenet poster
 
Posts: 2
Default multiple values in one cell

is it possible to put more than one value in an excel cell
and then querie the cell for the different values? Say the
cell has 2 and 4 in the cell and I could do a countif
(a2:a100,2) and countif(a2:a200,4)? separated by commas
will not do it is there a way?