How to search in Excel for matches line by line?

Question

excel

Hello. The task is this. There is a datasheet. Each cell is filled in the sheet. And I need to find two values ​​- A and B from the entire data array. But I need to find these values ​​so that both A and B are on the same line, no matter which cell. The main thing is that in one line. Who knows if this is possible?

Answer 1

1. Upload to CSV.
2. Open it in any editor that understands regular expressions.
3. Compose the desired regular expression and start the search.
It will probably take three minutes...

Answer 2

macro in vba.
But if there are not many columns with data, then you can write a formula with a nested "if".

Answer 3

Search and substitution by several conditions .