multiple values in one cell

  • Thread starter Thread starter Robert Hinson
  • Start date Start date
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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
Can a formula do this? 1
check the value in cell 1
Code to Concat a row in loop 2
If value occurs more than once then delete all of them 8
Multiple rows into one cell 8
Cell Count Between Value 13
Move multiple values in single Cell To Cells of there own? 3

Back
Top