Results 1 to 8 of 8

Unique Number of Values based on Date Columns

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-27-2007
    Posts
    156

    Unique Number of Values based on Date Columns

    I have a 4 column Spreadsheet

    Column A is a Name
    Column B is a Date
    Column C is a Date
    Column D,E have two specific dates one in D2 and one in E2 (start and end)



    I need to know if there is a way that I can have Excel look through all of the rows (could be thousands) and if the date in column B is greater than the date I have entered in D2 AND the date that I have in column C is less than the date that I have in E2 tell me how many unique Names I have in column A. End result of the formula will be an integer value


    Sample Worksheet is attached.
    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. [SOLVED] Find count of Unique or Duplicate Values based on Concatenated values in 2 columns
    By bdicarlo1 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-03-2014, 12:42 AM
  2. Count Unique values in Column based on values in other columns
    By dmschave in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-17-2014, 11:06 AM
  3. [SOLVED] Filter for Unique Values based on Two Columns
    By jfried11 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-07-2014, 09:48 AM
  4. Return number of unique values based on values in other column
    By Medir in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-26-2013, 11:17 AM
  5. Replies: 1
    Last Post: 11-16-2013, 05:18 AM
  6. Count Unique Values based on 2 columns
    By hecgroups in forum Excel Programming / VBA / Macros
    Replies: 33
    Last Post: 02-14-2012, 11:27 AM
  7. count unique values in columns based on date values
    By cclntn in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-29-2010, 06:16 PM
  8. Look across values in 12 columns, return the number of unique values
    By NukedWhale in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-21-2009, 05:18 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