|
In response to
"Excel Question Inside"
by
Dano
|
sort by email address, then make a new column next to the email address
Posted by
JaxSean (aka JaxSean)
Feb 19 '09, 08:05
|
say the new column is column B, start in B2 and do:
=if(a2=a1,1,0)
this matches the email in A2 to A1 to see if they match. if they do, then it puts a 1. If not, a 0. Then you can either scan it yourself, or COPY the entire new column, the PASTE SPECIAL (as Values) overwriting the formula and just leaving the 1's and 0's. Then sort by that column.
|