multiple values in one column?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way( separated by commas etc. ) to create a
column with 2 or three data values in them. Example 2,4,6
(IN ONE ROW OF A COLUMN) where I could querie that column
for values like COUNTIF(B3:B100,=2)
 
Hi

You can use a cell, fill it with multiple values and then use mid to say
look at the cells first 3 characters and use them in an equasion i think...

hth - im off to bed.

Rob
 
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 Help to copy information from one row at a time to another sheet 1
capture filter values from a sheet into a dropdown list in userfor 3
merging multple columns into one column (dynamically) 2
Move multiple values in single Cell To Cells of there own? 3
Transfer array element offset value to a matched value 3
Find a value in a sheet and replace it with another value if it matches 8
Combine three InputBoxes into one? 7
Import multiple workbooks to current workbook in specified row number 0

Back
Top