[
Hi is it possible to add to this so that it returns the unique list in order? the column i need contains dates.
=IFERROR(INDEX($A$2:$A$18,MATCH(0,COUNTIF($E$1:E2,$A$2:$A$18))),"")
many thanks for looking
[
Hi is it possible to add to this so that it returns the unique list in order? the column i need contains dates.
=IFERROR(INDEX($A$2:$A$18,MATCH(0,COUNTIF($E$1:E2,$A$2:$A$18))),"")
many thanks for looking
Last edited by michelle 1; 06-23-2016 at 08:50 AM.
You get better result on your question if you add a small excel file, without confidential information.
Please also add the expected results manualy in your file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Yes, it's possible.
What order do you want, ascending or descending?
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
HI tony, i am after ascending i would like the earliest to latest date.
many thanks
Try this...
Data Range
A B C D E 1 2 6/12/2016 ------ ------ ------ 3 6/27/2016 6/1/2016 4 6/4/2016 6/2/2016 5 6/12/2016 6/4/2016 6 6/2/2016 6/12/2016 7 6/18/2016 6/15/2016 8 6/21/2016 6/16/2016 9 6/15/2016 6/17/2016 10 6/18/2016 6/18/2016 11 6/18/2016 6/21/2016 12 6/27/2016 6/24/2016 13 6/24/2016 6/27/2016 14 6/1/2016 15 6/17/2016 16 6/12/2016 17 6/16/2016 18 6/4/2016
This formula entered in E3:
=MIN(A2:A18)
Format as Date.
This array formula** entered in E4:
=IFERROR(1/(1/MIN(IF(A$2:A$18>E3,A$2:A$18))),"")
** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.
Format as Date.
Copy down until you get blanks.
Hi Tony,
That works perfectly, thankyou so muh for your help with this one.
Michelle
You're welcome. Thanks for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks