MohitMathur1234
Member
Hi,
I am preparing a sheet where I want user's tasks come on user's sheet from master sheet.
I used formula :
=IFERROR(INDEX(Master!$B:$D,MATCH($B$1,Master!$D:$D,0)+IF(COUNTIF(Master!$D:$D,$B$1)<=(ROW($B12)-1),"",(ROW($B12)-1)),1),"")
but I am facing problem, when I repeat the User's name in master sheet, so defined task of user is not getting correct.
Please find the attached file for more details.
Please help to correct the formula.
I am preparing a sheet where I want user's tasks come on user's sheet from master sheet.
I used formula :
=IFERROR(INDEX(Master!$B:$D,MATCH($B$1,Master!$D:$D,0)+IF(COUNTIF(Master!$D:$D,$B$1)<=(ROW($B12)-1),"",(ROW($B12)-1)),1),"")
but I am facing problem, when I repeat the User's name in master sheet, so defined task of user is not getting correct.
Please find the attached file for more details.
Please help to correct the formula.