find inactive users

[mutedf8]

hello,

please help me to find the inactive users in "sheet3"

Sheet1 contains active set of users
Sheet2 contains full set of users

[azumi]

Perhaps put this on C5 and ENTERED as ARRAY

=IFERROR(INDEX(Sheet2!$C$4:$C$18,SMALL(IF(COUNTIF(Sheet1!$D$5:$D$14,Sheet2!$C$4:$C$18)=0,MATCH(ROW(Sheet2!$C$4:$C$18),ROW(Sheet2!$C$4:$C$18)),""),ROW(A1))),"")

then copied down until as blanks

[mutedf8]

Perhaps put this on C5 and ENTERED as ARRAY

=IFERROR(INDEX(Sheet2!$C$4:$C$18,SMALL(IF(COUNTIF(Sheet1!$D$5:$D$14,Sheet2!$C$4:$C$18)=0,MATCH(ROW(Sheet2!$C$4:$C$18),ROW(Sheet2!$C$4:$C$18)),""),ROW(A1))),"")

then copied down until as blanks

hello, thank you. i tried to create it again on new excel. but it seems some error.

[kersplash]

Use Ctrl-Alt-Shift to enter the formula.

[mutedf8]

Use Ctrl-Alt-Shift to enter the formula.

thanks! learning a lot here!