Forum Discussion
Searching for two things at once in excel.
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?
maybe all i want to do is see if there is a formula to record when two cells are next to each other. is this possible?
So, filter is no option?
Could you provide a workbook with the desired result?