• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Task come on user's sheet from master basis on user's name

Status
Not open for further replies.
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.
 

Attachments

  • Test_Timesheet.xlsx
    176.6 KB · Views: 0
Status
Not open for further replies.
Back
Top