I have a file in Excel sorted by address1 (Column G) and last name (Column C). If the first five positions of column g are equal and the first five positions of column c are equal, I would like to add 1 to column V. If not I would like to make column V = 1.
This is used to identify members that are possibly in the same household and delete all but the first member.
Can someone give me the code for Column V.
The file will be presorted by Column G (Address 1) Column C (last name) and lastly column F (descending age).