There's a difference between the way excel sees really empty cells and formulas
that evaluate to an empty string.

Numbers, then strings, then empties.

And the string ="" pops to the top of the strings.

Maybe you can modify your formula to return a different value:
=if(e2="",rept("z",99),...

or even fill in the truly empty cells with formulas (="").

Neon520 wrote:

Hi everyone,

I never imagined that the formula in the column would affect the sorting
order in any way, but it does in my case.

Below is the formula in that I have in Col I, and I'd like to sort it in
Ascending order, but the result is that it sorts with all the empty rows on
top and the one with the result from the formula at the bottom. I assume it
consider the "I" in the "IF" function in the formula, but I'm not sure.

Can anyone tell me how to fix this please?

=IF(E2="","",IF(J2="X","Priority
#1",IF(ISNA(VLOOKUP(E2,PriorityList,4,0)),"No Priority
Found",VLOOKUP(E2,PriorityList,4,FALSE))))

Thank you very much,
Neon520

--

Dave Peterson