Results 1 to 4 of 4

index/match formula for duplicate values not working

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    01-16-2012
    Location
    England
    MS-Off Ver
    MS 365 Version 2501 64-bit
    Posts
    1,465

    index/match formula for duplicate values not working

    Attached has thirty one dummy part numbers and delivery dates in Part Number order in sheet1.

    Sheet 2 needs the list in Date order, updated automatically when new entries are made on the Part Number sheet.

    Achieved that with array formula in Col B: {=SMALL('Part Order'!B:B,1)},{=SMALL('Part Order'!B:B,2)}, etc.

    Problem is that some dates have multiple parts, but Index/Match duplicates the first Part Number for that date.

    Thought following formula would do it by adding row numbers, but it generates blanks:

    {=IFERROR(INDEX('Part Order'!A1:A31,SMALL(IF('Part Order'!B1:B31=B2,ROW('Part Order'!B1:B31)-ROW($E$1)+1),ROWS('Part Order'!A1:A31))),"")

    Any solutions, suggestions or alternatives welcome as ever.

    Ochimus
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Index Match duplicate values without gaps or repeat values?
    By russwongg in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-26-2018, 09:27 PM
  2. [SOLVED] Sum duplicate values returned by array formula INDEX(MATCH(LARGE(IF)))
    By TFiske in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 12-02-2017, 07:18 PM
  3. Match and Index with Duplicate values
    By shortracer5 in forum Excel General
    Replies: 1
    Last Post: 09-09-2016, 05:25 AM
  4. Index Match & Duplicate values
    By Shaulyt in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-13-2016, 05:23 PM
  5. [SOLVED] Sum Duplicate Index-match-match Values
    By djh30 in forum Excel General
    Replies: 3
    Last Post: 01-06-2015, 11:27 PM
  6. Index Match with Duplicate Values
    By js2178a in forum Excel General
    Replies: 2
    Last Post: 09-28-2014, 02:21 AM
  7. [SOLVED] Index, Match & And function doesn't seem to be working when there is duplicate data
    By penexcel in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-26-2013, 07:08 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