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
signature.asc
Description: This is a digitally signed message part
