Counting Text from Drop-down menu
You missed nothing.
I got another thread mixed up with this one.
"kookie" and I had a thread going where your code was used for adding
selections to one cell.
This one from "em" is a new one.
My mistake.
Hope I haven't left "em" out in the cold.
Gord
On Mon, 19 Jan 2009 20:08:46 -0500, Debra Dalgleish
wrote:
Thanks Gord, I must have missed another posting somewhere. <g
Gord Dibben wrote:
Debra
OP is using your DatValMultiSelect worksheet code and wants to count the
number of comma delimited MultiSelects stacked into the adjacent cell.
I suggested counting commas and adding 1
Gord
On Mon, 19 Jan 2009 19:10:20 -0500, Debra Dalgleish
wrote:
It's not clear what you're trying to do. Can you give an example of
what's in the drop down list and what you want to count?
Em wrote:
Hi,
Does anyone know the formulae for counting certain text from a drop-down
list in excel?
I have used all the different COUNT functions i can try and the only one
that was close was COUNTIF but it would not count the drop down list of text,
only the text I wrote into the cell.
Can anyone help!
Thanks, Em
|