Forum Discussion
Searching for two things at once in excel.
Hello! I hope someone will be able to help me. I have a very long list of data in excel. There are basically two columns, the first has a list of numbers (usernames) and the second has a list of 'things' that username has.
The first search i performed was using countif to generate a list in order of the amount of entries per username from most-least, easy!
I want to now find out if the usernames are associated with specific 'things', so I want be able to search for a username from column 1, and then search for the presence of a 'thing' in the adjacent cell to a cell that has that username next to it.
So basically, I want a formula that will allow me to search for username within a column if information, but then check if the adjacent column to the username found, has a specific 'thing' present. There will only be one entry of a thing per username, so no duplicates per username.
I hope that makes sense to anyone. I would appreciate any help in making this possible.
attached a file giving an explanation of what im after
9 Replies
I would suggest COUNTIFS(), Matthew.
Hello! thank you for the reply so quickly. Would a countifs allow me to check the adjacent cell? eg- search username in column1, and search if cell adjacent to username contains 'thing'. Thats basically what i want to do, for a lot of usernames!
If there was a way of searching for every time one cell appeared, and take that cell and the cell adjacent into a different area of the spreadsheet/different sheet, that would be my ideal scenario!
I believe I missunterstood what you were trying to do.
A simple way is to filter the two columns.
But why would you copy the result to another place?
