I have 2 sheets, on 1 it is a list of states in column A.
On 2 it is filliable and people place there name in column A and what state the will be working in in collumn B.
I want sheet 1 to autofill in column b a list of people according to the state they are are in on sheet 2. So I can see who is where.
I thought this was right but it says invalid =iferror(join(",",filter(Sheet2!A:A,Sheet2!B:B=A1)))
Bookmarks