Find similar words in column A, report quantity in column B
Hello everyone,
I need to know if there is a way to do this:
I have 2 columns, A & B
I need a formula that can find Similar names in Column A. For example, there are 600 entries in Column A (all different company names). Now i need a formula that can search through all these names and find cells that have the word VISA in it and report the quantity number to a cell in column B. So if there are 75 entries for the company VISA then report 75 in a cell in column B.
Thank you for your help.
Cheers
Last edited by ADSK; 06-06-2009 at 10:56 AM. Reason: Resolved
=COUNTIF(A1:A600,"*visa*")
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Your formula works perfect. Thank you
Please, make thread [solved]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks