I would like someone's help in creating a formula and instructions for the following. I have a list of phone numbers and would like a formula that would help me
1. Create a unique list of the phone numbers that appear and how many times that number appears on the list.
2. Remove the blank lines.
3. Put the answer in one column (the numbers currently appear in two different columns)
Thanks in advance.
Iris
1. Create a unique list of the phone numbers that appear and how many times that number appears on the list.
2. Remove the blank lines.
3. Put the answer in one column (the numbers currently appear in two different columns)
Thanks in advance.
Iris