+ Reply to Thread
Results 1 to 5 of 5

Matching multiple columns and rows

  1. #1
    Registered User
    Join Date
    05-09-2013
    Location
    Stockholm, Sweden
    MS-Off Ver
    Excel 2010
    Posts
    8

    Matching multiple columns and rows

    Hey guys, really confused now and need help.

    I've got a data sheet (attached) where I get data about what actions the website admin has done row two for example what day. I want to generate a report about how many actions he is doing every day. Row 2 for example applies for the same user - which he Approved and then Edited. Now I want all actions for 2013-06-23 calculated so: how many users were Approved. how many Edited?

    I cant seem to get the Match function to work with multiple rows of same data. Any ideas?
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,587

    Re: Matching multiple columns and rows

    You want to count "User approved" ?

  3. #3
    Registered User
    Join Date
    05-09-2013
    Location
    Stockholm, Sweden
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Matching multiple columns and rows

    Quote Originally Posted by kvsrinivasamurthy View Post
    You want to count "User approved" ?
    Sorry for being unclear. I basically want to count all different actions, and how many times the action is done per day. So User edited, approved and item approved.

  4. #4
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,587

    Re: Matching multiple columns and rows

    Pl see the attached file.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    05-09-2013
    Location
    Stockholm, Sweden
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Matching multiple columns and rows

    Quote Originally Posted by kvsrinivasamurthy View Post
    Pl see the attached file.
    Works like a charm! Thank you!

+ Reply to Thread

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