Can someone tell me if there is a function that will lookup all similiar text within a cell even if the cell contains other data within the cell.
example.
Lets say, Column A contains the names, ages and location of over 200 people, and I wanted to count how many people in the column are 35 years of age.
Data all looks like this.
Jeff Jones, 35, San Diego, CA
Can this be done?
Bookmarks