I have one sheet full of data (sheet titled DATA) of employees names and store numbers. I need to create a sheet for each unique store number, listing the employees names.
I have listed the store number at the top of the new sheet. For any matching store number in column A of DATA sheet, I need it to return the Employee Name in Column B of DATA sheet. And the employee names need to go on a new Sheet (STORE 1011)
My (incorrect) formula: