Forum Discussion
sorting a column of words
Hello,
I have a long list (3138 and growing) of words in column A that I have copied & pasted into column D. Every time I try to sort this column A to Z there are two cells at the end with " FALSE" in them. The words have been spell checked and approved. What's causing the two FALSE entries and how can I sort the words correctly?
Thank you.
Bill Cochran
2 Replies
Bill Cochran I suspect that the words in column A come from an IF formula, where two of them result in FALSE as you did not include a value for the if_false part.
Sorting a list from A to Z including FALSE (=0) will put them at the bottom of the list.
- Could you please upload an example?
