+ Reply to Thread
Results 1 to 3 of 3

Function to return all values that meet criteris

  1. #1
    Registered User
    Join Date
    05-13-2013
    Location
    Fort Lauderdale, Florida
    MS-Off Ver
    Excel 2011
    Posts
    46

    Function to return all values that meet criteris

    For example in Column A i have a list of dates, some repeats and values associated with those dates.

    5/16/13 7862514
    5/16/13 7736635
    5/16/13 7761248
    5/17/13 7939356
    5/21/13 7760298

    Is there a way to return The dates in Chronological order across columns with no duplicates and then have all numbers given associated with that date listed underneath?

  2. #2
    Forum Contributor
    Join Date
    07-19-2012
    Location
    Redmond, WA
    MS-Off Ver
    O365
    Posts
    133

    Re: Function to return all values that meet criteris

    I don't know of a function that will do this. There may be a macro that can be built to do this.

    Check with the VBA forum.

  3. #3
    Registered User
    Join Date
    05-17-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    49

    Re: Function to return all values that meet criteris

    How about a Pivot Table with both Dates and Values in the Column Labels Field

+ 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