+ Reply to Thread
Results 1 to 4 of 4

Find unique names in a column based on a date range

  1. #1
    Forum Contributor
    Join Date
    02-09-2007
    Location
    UK
    MS-Off Ver
    2019 & 365
    Posts
    304

    Find unique names in a column based on a date range

    Solved. Thanks for assistance once again, stay safe all.

    *****

    Hi All,

    I need a few formulas that look at a date range (entered into two cells by a user) and then scan a list of names (that are on rows with dates in the same row) and returns the unique names that are found.

    Then another formula that looks at the monetary values of them rows based on the names.

    Example attached as I probably have not explained it brilliantly!

    The cells in blue are where I need the formulas – I have manually entered in the results I would expect to assist.

    Thanks BVG
    Last edited by Badvgood; 06-08-2020 at 09:46 AM. Reason: Solved

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,077

    Re: Find unique names in a column based on a date range

    In A4 copied down
    =IFERROR(INDEX(Responces!$C$2:$C$20,MATCH(0,COUNTIFS(A$3:A3,Responces!$C$2:$C$20)+(Responces!$F$2:$F$20<$B$1)+(Responces!$F$2:$F$20>$D$1),0)),"")

    This is an array formula & needs to be confirmed with Ctrl Shift Enter.
    You can then use a sumifs formula for the other two columns.

  3. #3
    Registered User
    Join Date
    06-04-2018
    Location
    Europe
    MS-Off Ver
    Office365
    Posts
    78

    Re: Find unique names in a column based on a date range

    in A4 use Fluff13 formula and in B4 use this formula:

    =SUMPRODUCT((Responces!$F$2:$F$20>=$B$1)*(Responces!$F$2:$F$20<=$D$1)*(Responces!$C$2:$C$20=$A4)*(Responces!H$2:H$20))

    Then drag the formula down and then to the right.

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,077

    Re: Find unique names in a column based on a date range

    I'd stick with a sumifs
    In B4 copied down & across
    =SUMIFS(Responces!H:H,Responces!$C:$C,$A4,Responces!$F:$F,">="&$B$1,Responces!$F:$F,"<="&$D$1)

+ 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: 3
    Last Post: 09-18-2018, 06:49 PM
  2. Replies: 3
    Last Post: 08-29-2018, 10:08 PM
  3. Find unique number of values in a column based on criteria
    By Grilleman in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-19-2016, 12:29 PM
  4. [SOLVED] Find unique cells in column -> Sum another column based on multiple criteria
    By mjoc9 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-20-2015, 09:29 AM
  5. Find unique names in certain range.
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 07-22-2014, 04:00 PM
  6. [SOLVED] Define new range names based on existing range name offset 1 column to right
    By jprlimey in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-03-2014, 07:53 PM
  7. Replies: 1
    Last Post: 01-06-2006, 09:35 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