Platinum
New Member
I have this spread sheet that has the names of all the employees int he company I work for. It is lastname, firstname format. I need to compare them to e-mail addresses we have which is [email protected]
So I had to use formulas to extract the names the way I wanted it to be. Bottom line is I got what I need, but now I need to sort it alphabetically and I can't. I'm thinking because the actual cells are just formulas and that's why.
Is there a way I can sort the values the formulas retrieve alphabetically?
So I had to use formulas to extract the names the way I wanted it to be. Bottom line is I got what I need, but now I need to sort it alphabetically and I can't. I'm thinking because the actual cells are just formulas and that's why.
Is there a way I can sort the values the formulas retrieve alphabetically?