What formula do I need please?
Posted by Tim on October 17, 2001 4:41 AM
In Excel, what formula do I need to find out how many times the text "John" appears in the column?
John
Peter
Tony
John
Peter
Simon
John
Posted by George on October 17, 2001 4:52 AM
Use Countif.
Range: {Select the cells the names will appear in}
Criteria: John
The cell you put this formula into will say 3
George
