Forum Discussion
Searching for two things at once in excel.
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?
This is an example of how the actual data was given to me.
The real data is not something I can show online but the table to the right is how id like to find the cells. The actual data has thousands of rows so you can see why i'd like to hunt the data in a more automated way!