Hi all,
Thanks for taking the time to try and help me out. I basically have an excel sheet with a list of towns on it, and a 'yes/no' column for each of the rows containing towns. What I would like to do is (on a separate sheet, or a separately linked workbook if possible) create a formula which checks to see if an of the towns i have listed have a yes or no by them; and if yes - copy the town name into a column of its own. I have attached a mock up table showing what i described above if anyone could help!
Many thanks for all your time.
Josh
Example:
<tbody>
</tbody>
...and because rows 3 and 4 are 'yes' I would like the exact text in those cells to show up on a separate sheet.
Thanks for taking the time to try and help me out. I basically have an excel sheet with a list of towns on it, and a 'yes/no' column for each of the rows containing towns. What I would like to do is (on a separate sheet, or a separately linked workbook if possible) create a formula which checks to see if an of the towns i have listed have a yes or no by them; and if yes - copy the town name into a column of its own. I have attached a mock up table showing what i described above if anyone could help!
Many thanks for all your time.
Josh
Example:
town | confirmed |
london | yes |
manchester | yes |
birmingham | no |
<tbody>
</tbody>
...and because rows 3 and 4 are 'yes' I would like the exact text in those cells to show up on a separate sheet.