+ Reply to Thread
Results 1 to 8 of 8

Compare the value to Matrix and provide out as count

  1. #1
    Registered User
    Join Date
    02-18-2021
    Location
    Chennai
    MS-Off Ver
    MS 365
    Posts
    4

    Compare the value to Matrix and provide out as count

    Dear Experts,

    Compare the value to Matrix and provide out as count

    Ref the screenshot -

    Input details are section in YELLOW and based on the input, output to be updated in GREY section.
    Expected Output Logic: Count of Topics under each category to be updated against respective class

    Pls advise, Thanks
    Attached Files Attached Files
    Last edited by shankicool; 02-18-2021 at 08:21 AM. Reason: Attachment

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Compare the value to Matrix and provide out as count

    There is no screenshot. Screenshots aren't much use anyway...


    A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.

    Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Registered User
    Join Date
    02-18-2021
    Location
    Chennai
    MS-Off Ver
    MS 365
    Posts
    4

    Re: Compare the value to Matrix and provide out as count

    Glenn...
    interesting comment
    "An Excel sheet is worth 1,000 non-editable pictures." - totally agreed

    Added the worksheet to original post

    Cheers

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Compare the value to Matrix and provide out as count

    In D14, copied across and down:

    =COUNTIFS(D$3:D$10,"Y",$C$3:$C$10,$C14)

    In your sample, the columns were in the same order in both blocks. Is that the case in your real data?
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    02-18-2021
    Location
    Chennai
    MS-Off Ver
    MS 365
    Posts
    4

    Re: Compare the value to Matrix and provide out as count

    Thanks,

    " In your sample, the columns were in the same order in both blocks. Is that the case in your real data?"
    hmm.. no the columns sequence and placeholder will vary... so it has to be dynamic.. in real data, the input and output are in different worksheets and different sequence.

  6. #6
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Compare the value to Matrix and provide out as count

    D14:
    =sumproduct(($d$2:$f$2=d$13)*($c$3:$c$10=$c14)*($d$3:$f$10="y"))
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    02-18-2021
    Location
    Chennai
    MS-Off Ver
    MS 365
    Posts
    4

    Re: Compare the value to Matrix and provide out as count

    Awesome... I always amazed with the way excel can be used ... such an effective tool

    Thanks Glenn, It worked perfectly. I was complicating with Match/ Index function... shows by how naive am in excel

    Cheers again mate

  8. #8
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Compare the value to Matrix and provide out as count

    No... it's only difficult if you haven't done it before (or have done it... and have forgotten how to!!)

+ 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. Replies: 1
    Last Post: 01-27-2020, 05:57 AM
  2. Replies: 11
    Last Post: 01-19-2018, 05:43 AM
  3. Macro count items in sheet2 and provide count in embedded label in sheet1
    By jaredmccullough in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-05-2015, 11:27 AM
  4. [SOLVED] compare 2 columns provide result in 3rd column
    By snakesbee in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-29-2015, 11:34 AM
  5. compare totals and provide a result
    By Christopherdj in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-01-2012, 08:17 PM
  6. Need a formula to lookup, compare, provide result
    By dklein2149 in forum Excel General
    Replies: 1
    Last Post: 02-06-2009, 12:55 AM
  7. [SOLVED] Excel should provide the facility to compare two spreadsheets
    By ThisCantBeHappening in forum Excel General
    Replies: 0
    Last Post: 01-15-2006, 08:00 PM

Tags for this Thread

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