+ Reply to Thread
Results 1 to 1 of 1

Rank sets of duplicates with multiple criteria using SUMPRODUCT - Alternative methods?

  1. #1
    Registered User
    Join Date
    05-13-2014
    MS-Off Ver
    Office 2016 64x
    Posts
    4

    Rank sets of duplicates with multiple criteria using SUMPRODUCT - Alternative methods?

    Hello,
    I am new to this forum and forums in general, if I break any rules please let me know.

    Question:
    For larger data sets, is there a faster alternative to the ranking formula using SUMPRODUCT in the attached file.

    The attached file contains a very helpful! formula a skilled user generously provided. The original file had my attempts using sumproduct (also learned and adapted from other posts) and keeping with those attempts, they made it work. This is a new post to follow up a solved question on another site. (from the rules I do not think this is a cross-post, but if it is let me know) http://www.ozgrid.com/forum/showthread.php?t=188322

    It ranks varying amounts of duplicates using multiple criteria. The duplicates can be unsorted, columns can be moved or added and the ranges adjust it is great. However, my machine is not the fastest and it gets very slow when the data is thousands of rows or lots of other formulas are on the same sheet. I have read there are formulas that might be faster than sumproduct and tried to convert this one but I am still learning arrays and cannot figure it out, yet. The criteria are on the Notes tab and the new data set is on the SourceData_NewSample tab. I am using Excel 2010.

    I really appreciate any help.
    Attached Files Attached Files

+ 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. [SOLVED] SUMPRODUCT, COUNTIF formulas not correctly counting based on two sets of criteria
    By justinbelkin in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-11-2013, 10:12 AM
  2. Replies: 2
    Last Post: 08-30-2013, 06:30 AM
  3. [SOLVED] alternative methods to sumproduct for comparing/matching rows
    By intothewild in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-17-2012, 07:59 PM
  4. COUNTIF Alternative for multiple criteria?
    By Dan17602 in forum Excel General
    Replies: 6
    Last Post: 03-21-2011, 12:49 PM
  5. Excel 2007 : Problem - Rank multiple criteria using SUMPRODUCT
    By josemartillo10 in forum Excel General
    Replies: 4
    Last Post: 02-23-2011, 03:37 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