Hi,
Please HELP!
I am trying to create a 2nd tab where it looks for text "OFF" in ColumnB from ColumnA, and copy "Name" in ColumnA to 2nd tab. At the same time, the function skips blank cell.
TAB 1
(ColumnA) (ColumnB)
<tbody>
</tbody>
Ideal Tab2
<tbody>
</tbody>
I tried to use IF function, but it doesn't skip blank cell.
Please HELP!
I am trying to create a 2nd tab where it looks for text "OFF" in ColumnB from ColumnA, and copy "Name" in ColumnA to 2nd tab. At the same time, the function skips blank cell.
TAB 1
(ColumnA) (ColumnB)
Name | Amount |
Anne | OFF |
Amy | |
Mike | |
Doe | OFF |
Anne | OFF |
Mike | OFF |
John | |
Doe | OFF |
<tbody>
</tbody>
Ideal Tab2
Name | Amount |
Anne | OFF |
Doe | OFF |
Anne | OFF |
Mike | OFF |
Doe | OFF |
<tbody>
</tbody>
I tried to use IF function, but it doesn't skip blank cell.