View Full Version : error message in Data/Sort?

2011-06-30, 07:57 PM
I am attempting to sort 34,000 rows in descending order in column 'O'. Entered are Sort by 'Number of Lines Ordered', descending, header row. When I hit enter I get error message "The formula entered contains an error. ....". But there is no formula in the column. The column only contains numeric values.

Any ideas?


Ken Puls
2011-06-30, 09:36 PM
Any way you can upload a workbook that has the error? I think it might make it a little easier to sort this one out...

2011-06-30, 11:00 PM
Thanks, I just ran out of time here on the East coast. I'm facing a 4 hour drive tonight, so I'll get back to this next week.
Thank you for your offer to help. I am seriously confused by the problems I am having with this book.
ps Nanaimo is a lovely place to live!