I would like to have a formula in the "SOLUTION COLUMN" that recognizes these 9 records are the same entity. I could then aggregate the data by that solution column.
Would anyone know how to write a formula that try to do that? Test to columns won't work because there is other data in the file that is similiiar but not so clear cut. Thanks.





Code Name Address City State Zip Code SOLUTION COLUMN
68978 BARNETT WHITE BEAR CHRYS JEEP 3430 HIGHWAY 61 N SAINT PAUL MN 55110 BARNETT WHITE BEAR
68978 BARNETT WHITE BEAR CHRYS JEEP DODGE 3430 HIGHWAY 61 N SAINT PAUL MN 55110 BARNETT WHITE BEAR
62082 BARNETT WHITE BEAR CHRYSL 3430 HIGHWAY 61 N SAINT PAUL MN 55110 BARNETT WHITE BEAR
68978 BARNETT WHITE BEAR CHRYSLER 3430 HIGHWAY 61 N SAINT PAUL MN 55110 BARNETT WHITE BEAR
60466 BARNETT WHITE BEAR CHRYSLER 3430 HIGHWAY 61 N SAINT PAUL MN 55110 BARNETT WHITE BEAR
44435 BARNETT WHITE BEAR CHRYSLER JEEP 3430 HIGHWAY 61 N SAINT PAUL MN 55110 BARNETT WHITE BEAR
62082 BARNETT WHITE BEAR CHRYSLER JEEP DODGE 3430 HIGHWAY 61 N SAINT PAUL MN 55110 BARNETT WHITE BEAR
60466 BARNETT WHITE BEAR CHRYSLER JEEP DODGE 3430 HIGHWAY 61 N SAINT PAUL MN 55110 BARNETT WHITE BEAR
45509 BARNETT WHITE BEAR C-J 3430 HIGHWAY 61 N SAINT PAUL MN 55110 BARNETT WHITE BEAR