+ Reply to Thread
Results 1 to 4 of 4

Match rows

  1. #1
    Forum Contributor
    Join Date
    07-29-2009
    Location
    Melbourne, Australia
    MS-Off Ver
    365
    Posts
    205

    Match rows

    I have attached a data sheet.

    I want to count how many cells are the same as the solution row for each student.

    Solution to questions are in B3-J3, all students results are to be matched to that row, results are output in column k.

    Thanks

    Q
    Attached Files Attached Files
    Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind.

  2. #2
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    1,842

    Re: Match rows

    Are you still on V2010? if you've upgraded to O365, try this in K4 and copy down:

    =SUM(--(B4:J4=$B$3:$J$3))

    I don't think this will work in 2010, but you could try entering it as an array formula (submitting it using Ctrl+Shift+Enter instead of just enter). My guess is it won't work in 2010 though.

  3. #3
    Valued Forum Contributor
    Join Date
    12-09-2014
    Location
    Trakai, Lithuania
    MS-Off Ver
    2010
    Posts
    729

    Re: Match rows

    Formula
    Please Login or Register  to view this content.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    06-22-2022
    Location
    India
    MS-Off Ver
    Microsoft office Home and Student 2019
    Posts
    26

    Re: Match rows

    You can try the following formula: =SUM((B4:J4=$B$3:$J$3)*1). Use ctrl+shift+enter after pasting the formula, since this is an array.

+ 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. If cell contains value, match with previous path and copy all data from rows that match
    By luajambeiro in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-12-2020, 02:58 PM
  2. Replies: 1
    Last Post: 08-28-2019, 02:16 PM
  3. [SOLVED] Index match match with the column number determined by two rows???
    By bridge4444 in forum Excel General
    Replies: 2
    Last Post: 08-08-2016, 04:23 AM
  4. Replies: 6
    Last Post: 09-03-2015, 09:51 PM
  5. Replies: 3
    Last Post: 08-07-2014, 06:01 AM
  6. Match similar rows from two sheets using three columns to match the "paired" rows
    By sanpedro_nz in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-04-2011, 07:15 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