this kind of list i'm working with:
basically end game able list alphabetical order, removing 0's , removing duplicates. i'm sure there way without having manually struggling think of best way go it. great, cheers!
if one-time/ rare thing, can use "remove duplicates" function found under data ribbon > data tools > remove duplicates. select column , rightclick, , click sort. this, automation should used if repetitive task data consistently comes in same form. otherwise, learning apply manual excel tools make quicker in long-run.
Comments
Post a Comment