I dont know what this would be called or what formula to use and would
greatly appreciate any help I can get.

I would like to take the example table below and get the following results.
First Last Address Previous Employer
Steve Smith 166 Home St 4

I would like one row with the like data listed and a count if possible of
the non like data.
First Last Address Previous Employer
Steve Smith 166 Home St ABC Inc
Steve Smith 166 Home St #1 Times
Steve Smith 166 Home St Any Work
Steve Smith 166 Home St Work Now

--
Chad Welch
NG&G Facility Services