+ Reply to Thread
Results 1 to 3 of 3

Count duplicate values from multiple colums and rows

  1. #1
    Forum Contributor
    Join Date
    07-04-2013
    Location
    United States
    MS-Off Ver
    Excel for Mac -V 16.33 -- Office 365
    Posts
    252

    Count duplicate values from multiple colums and rows

    I am trying to count the number of cells with the same value, but which are spread out over several different rows and columns. See cell A8 on tab "Product Forecast Details" in the attached excel.

    Test3 Beta Inventory System v2.1.xlsb

    Thanks in advance.

  2. #2
    Registered User
    Join Date
    10-10-2015
    Location
    Houston
    MS-Off Ver
    2013
    Posts
    26

    Re: Count duplicate values from multiple colums and rows

    How about this

    =SUMPRODUCT(--(LEFT('Sales Rep Forecast Input'!G8:G27,LEN(B8))='Product Forecast Details'!B8))

  3. #3
    Forum Contributor
    Join Date
    07-04-2013
    Location
    United States
    MS-Off Ver
    Excel for Mac -V 16.33 -- Office 365
    Posts
    252

    Re: Count duplicate values from multiple colums and rows

    Perfect. Thank you. The only additional thing I needed to do was expand the number of rows and anchor in the range.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Remove duplicate names from 2 colums / multiple rows
    By quikgun15 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-05-2014, 03:49 AM
  2. Replies: 1
    Last Post: 03-28-2013, 01:48 PM
  3. Duplicate Values Multiple Rows to be Highlited
    By vanther in forum Excel General
    Replies: 4
    Last Post: 01-09-2013, 12:42 AM
  4. Getting values from multiple rows and colums
    By BILAL336 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-10-2012, 05:35 PM
  5. Replies: 8
    Last Post: 04-12-2012, 08:02 PM
  6. Best way to parse colums and rows w/ multiple values separated by comma?
    By Sutukh19 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-28-2009, 04:37 AM
  7. [SOLVED] Count on multiple values with duplicate rows
    By Carla in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-22-2005, 05:30 PM

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