multiple values in one cell

R

Robert Hinson

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?
 
R

robert hinson

Thank you Frank!!!!!!!!!
it works for multiple values very well it doen't count single values
but I can overcome that easily by making it an "or" statement or by
adding a "comma zero" to the single #'s

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
 
Top