I used to know how to do this, and now I can’t even find the answer through internet search. Apparently, I’m going senile.
Here’s what I am trying to do.
For each row, I want to create a function in column/cell AJ. The function will check for a specific text value in a cell (current row, Column E) and a different, specific text value in another cell (current row, Column F). If both are true, I want to write a specific number (“1”) into cell AJ (in the current row).
I hope I have explained this clearly.
Thanks in advance for any hints.