Hi
Corresponding to the range against date data picking row to column without duplication.
DATA:
Type IN Date OUT Date
FORD 01/04/2015
FORD 02/04/2015
FORD 02/04/2015 02/04/2015
FORD 04/04/2015
FORD 06/04/2015
FORD 06/04/2015
FORD 06/04/2015
FORD 08/04/2015
FORD 09/04/2015
REQUIRED FORMAT:
TYPE DATE:
FORD 01/04/2015 02/04/2015 04/04/2015 06/04/2015 08/04/2015 09/04/2015 12/04/2015 20/04/2015
file attached.some one help its really appreciate.
P3=IFERROR(INDEX(Data!$B$2:$B$58,MATCH(0,COUNTIFS('Required Format'!$O3:O3,Data!$B$2:$B$58)+IF('Required Format'!$I3<>Data!$A$2:$A$58,1,0)+IF(Data!$C$2:$C$58<>"",1,0),0)),"") with CTRL+SHIFT+ENTER and drag over the cells and down.
Formula:
Please Login or Register to view this content.
Last edited by shukla.ankur281190; 09-24-2015 at 12:50 AM.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
shukla.ankur281190
It was amazing and superb tricks.
Glad to help you out
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks