Good day friends need help for this case, for clear explanation please take a look at the file, and need formula solutions
Thank you in advanced
Good day friends need help for this case, for clear explanation please take a look at the file, and need formula solutions
Thank you in advanced
Hi
shift 2 in F4 and below
=IFERROR(INDEX(B$3:B$10,AGGREGATE(14,6,ROW($3:$10)-2/(COUNTIF(A$3:A$10,B$3:B$10)=0),ROWS($1:1))),"")
shift3 in G4...
=IFERROR(INDEX(C$3:C$10,AGGREGATE(14,6,ROW($3:$10)-2/((COUNTIF(A$3:A$10,C$3:C$10)=0)*(COUNTIF(B$3:B$10,C$3:C$10)=0)),ROWS($1:1))),"")
regards
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
Thank you @Canapone for the help
Hi
thanks for providing feedback. I'm working on Excel 2010, Excel 365 would offer easier solution.
Another approach is using Power Query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks