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
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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks