Results 1 to 3 of 3

search multiple columns and count number of rows the keywords appear

Threaded View

  1. #1
    Registered User
    Join Date
    01-22-2013
    Location
    los angeles, ca
    MS-Off Ver
    Excel 2007
    Posts
    2

    search multiple columns and count number of rows the keywords appear

    i attached a sample set of data.

    theres a list of keywords associated with a product.

    I want to count how many "steering wheels" and 'shift knobs" were sold in each month. But since the data is spotty I can't just search a single column. When I'm searching multiple columns its return a result for each of the time it finds the word. Each row should only be counted once.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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