Sorting Formulas

[BillJunior]

I have a table that has a column in it with the following
formula:
=IF(A2="","",LOOKUP(A2,PlayerNames,Position))

It will display an empty cell if there is no name in
column A, if there is it will display the players
position. The problem is when I go to sort the players I
want to sort them by their position. When you do the sort
it puts the blank cells that have the formula in them in
the top rows (regular empty cells still stay at the
bottom of course) but I want the rows with data in them
up top. I dont seem to see an option to tell excel to
ignore formulas in cells so is there some way around this?

Thanks,

BillJunior

 

[hcj]

Try:
=IF(A2="","x-position
not found",LOOKUP(A2,PlayerNames,Position))

This would force the no-finds to the bottom of the list
because of the leading x.

 

[BillJunior]

Thank you for the idea, but I would prefer not to have
words in the columns if I do not have to. Any other
suggesstions are always welcome.

BillJunior

 

[Ron Rosenfeld]

Thank you for the idea, but I would prefer not to have
words in the columns if I do not have to. Any other
suggesstions are always welcome.

Have you tried using AutoFilter to filter out the "blanks"?


--ron