I have a login username spreadsheet for my company. Certain of the columns will be filtered to populate spreadsheets elsewhere (for example, spreadsheets for specific staff listing their usernames would only return columns for name, web link, username and how to reset password). Column A is Login Name, B is Website, C is how to obtain credentials, D is how to reset password and then Columns E onward are employee names.
I’m trying to filter this username sheet to another spreadsheet, so the data is specific to an employee. So say I have Person A, B and C. They have a login for Portals A, B and/or C. I’d like set up a login spreadsheet for person B that lists all of the logins and their usernames. It shouldn’t include the usernames of other employees.
I think the filter to do the following:
First, find the column that says “Person B”, and then return those rows where that column with “Person B” as the header is populated with a username (i.e. not null). But also only return Columns A, B, D and the username column for “Person B”. In other words, find Person B’s username column, return each row with usernames entered but only return column A (name of login), column B (website location), column D (how to reset password) and the username column.
How do I do this? Please help! Thanks!