+ Reply to Thread
Results 1 to 2 of 2

unique list from date fail

  1. #1
    Forum Contributor
    Join Date
    10-18-2017
    Location
    london
    MS-Off Ver
    2007
    Posts
    152

    unique list from date fail

    Hi my friends

    I want to extract unique list from column J (contain difrent date)
    I try more four formula and macro .... nothing work

    where is the error?

    thanks
    Attached Files Attached Files

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: unique list from date fail

    Please try at P3
    Date contains time, Use INT to get rid of time.

    =IFERROR(SMALL(IF(INT(N(+$J$3:$J$101))>MAX(P$2:P2),INT($J$3:$J$101)),1),"")

    Press Ctrl+Shift+Enter
    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] Get the Max value / date from a list of different unique numbers
    By richard.lim85 in forum Excel General
    Replies: 2
    Last Post: 09-05-2019, 10:23 PM
  2. [SOLVED] Looking to get a dynamic unique list based on date
    By Gunblade in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-15-2019, 04:13 AM
  3. [SOLVED] help list unique values within a date range
    By XL. in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-12-2016, 03:14 PM
  4. [SOLVED] unique date list jan feb march
    By XLalbania in forum Excel General
    Replies: 14
    Last Post: 12-11-2015, 05:30 PM
  5. [SOLVED] Create unique list based on date
    By solmyr in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-22-2014, 07:31 AM
  6. [SOLVED] Need a formula for pass/fail based on no. of Y answers but automatically fail if 3a is N
    By Researcher1111 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-15-2013, 10:20 PM
  7. [SOLVED] Get unique items and decide whether they are pass or fail
    By netha in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-30-2013, 02:33 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