Results 1 to 6 of 6

Search Keyword and count results

Threaded View

  1. #1
    Registered User
    Join Date
    02-13-2014
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    11

    Search Keyword and count results

    Hey Guys,

    I need some help with searching and counting keywords in an excel document.

    In the sample attached i want to be able to search Column I (only this column) for the following keywords:
    Football
    Hockey
    Basketball
    Tennis

    and then display the count total for each of the keywords

    So i think it should return
    Football - 3
    Hockey - 2
    Basketball - 3
    Tennis -2

    Could someone do this for me on the attached excel sheet and let me know how its done.
    Cheers
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 6
    Last Post: 03-18-2014, 11:16 AM
  2. Search cell for keyword with multiple results.
    By daves_nt_here in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-21-2014, 01:20 PM
  3. Excel Macro to Count Google Search Results
    By jeffreytp in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-07-2012, 02:37 PM
  4. [SOLVED] Keyword search, copy rows to new sheet. Results far from consistent
    By Smatths in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-01-2011, 11:11 AM
  5. Replies: 1
    Last Post: 12-27-2010, 08:53 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1