I have attached a file. I need to create a new sheet (sheet 2) that will return Column A of sheet 1 (Name) if Column B (Value) = "yes". However, I do not want to skip lines if the value = "No".
The desired results are shown in sheet 3. How do I write a formula in Sheet 2 that will do this.
thanks.
Bookmarks