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 'thi...
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?