How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask The-PC-Guy Your Own Question
The-PC-Guy
The-PC-Guy, Computer Manager
Category: Microsoft Office
Satisfied Customers: 1998
Experience:  20 years experience providing remote computer support
62934938
Type Your Microsoft Office Question Here...
The-PC-Guy is online now
A new question is answered every 9 seconds

1 COLUMN 588 ROWS, TRYING TO COUNT THE NUMBER OF TIMES A PARTICULAR

This answer was rated:

1 COLUMN 588 ROWS, TRYING TO COUNT THE NUMBER OF TIMES A PARTICULAR ANSWER IS REPEATED???

The-PC-Guy :

Thanks for using JustAnswer. My name isXXXXX will do whatever I can to answer your question

The-PC-Guy :

assuming you are using column A

The-PC-Guy :

you can do =COUNTIF(A:A,"some text")

The-PC-Guy :

=COUNTIF(A:A,"some text")

The-PC-Guy :

change the text to what you are trying to count

The-PC-Guy :

let me know if you have any problems

The-PC-Guy :

applying this formula

The-PC-Guy and other Microsoft Office Specialists are ready to help you