Excel Lookup Formula

Associate
Joined
3 Feb 2003
Posts
1,771
Location
Sydney, Australia
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)
 
Back
Top Bottom