C
Connie Martin
I have research Help and online. I've done a pile of reading and
experimenting, but nothing works. I know it's got to be simple, but finding
the answer hasn't been!! I have a column of numbers and text. Some cells
have numbers and some cells have one word or two words. Some numbers start
with a zero. Therefore, the whole column is formatted as "text". Each cell
represents a customer's purchase order (PO). Some PO numbers are names
rather than numbers. Some start with zero. Hence the reason for the mixed
data. I'm trying to come up with a formula that will count the number of POs
from that mixed up column. Each row is a new PO. What formula do I use?
Connie
experimenting, but nothing works. I know it's got to be simple, but finding
the answer hasn't been!! I have a column of numbers and text. Some cells
have numbers and some cells have one word or two words. Some numbers start
with a zero. Therefore, the whole column is formatted as "text". Each cell
represents a customer's purchase order (PO). Some PO numbers are names
rather than numbers. Some start with zero. Hence the reason for the mixed
data. I'm trying to come up with a formula that will count the number of POs
from that mixed up column. Each row is a new PO. What formula do I use?
Connie