Hey guys,
I have a table with a column containing people's names. Where 2 people live at the same address their names are in the same cell.
I need to create a new column telling me whether there are 2 people or one person living at each address.
When there are 2 the cell always contains a "&" symbol.
Is there a way I can get an IF statement to return this for me?
Something along the lines of:
=IF(B2 like "&",2,1)
I have a table with a column containing people's names. Where 2 people live at the same address their names are in the same cell.
I need to create a new column telling me whether there are 2 people or one person living at each address.
When there are 2 the cell always contains a "&" symbol.
Is there a way I can get an IF statement to return this for me?
Something along the lines of:
=IF(B2 like "&",2,1)