Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTING
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counting | Excel Discussion (Misc queries) | |||
counting function but not double counting duplicates | Excel Worksheet Functions | |||
Counting Age | Excel Worksheet Functions | |||
Counting rows, then counting values. | Excel Discussion (Misc queries) | |||
Counting names in a column but counting duplicate names once | Excel Discussion (Misc queries) |