The really interesting part of this problem is not the count anomaly,
but compacting a list to remove empty values i.e. as the author says
Mind you, what I really want is for column d to say
oranges
grapefruit
lemon
lime
starting in cell d1 with no spaces between the fruit.
Any thoughts on this problem?
On Nov 14, 2008, at 12:59, Cabaniss Roy F wrote:
Was messing with a spreadsheet and openoffice and came across
something
I thought of as really odd. It certainly could be my coding but I
think
I am doing things right
I have a list of fruit (any kind of list will do) and some
classification schmata (in this case if the fruit is citrus as
noted by
the c besides them in column A. The third column selects the fruit if
it is a citrus (as noted by column A)
apples
c oranges oranges
blueberry
pomegranite
kiwi
c grapefruit grapefruit
c lemon lemon
c lime lime
cranberry
blackberry
raspberry
so the formula in column 3 looks like
=IF(A1="c";B1;"")
but when I counted column c I came up with 11, not the 4 I expected.
=counta(c1;c11) Am I doing something wrong or is this normal?
Mind you, what I really want is for column d to say
oranges
grapefruit
lemon
lime
starting in cell d1 with no spaces between the fruit.
--
Dr. Roy F. Cabaniss
University of Arkansas at Monticello
http://cabanisspc.uamont.edu
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
