error message in Data/Sort?

Rick

New member
Joined
Jun 15, 2011
Messages
4
Reaction score
0
Points
0
Location
Marietta, GA
Excel Version(s)
16.49
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?

Tnx,
Rick
 

Ken Puls

Administrator
Staff member
Joined
Mar 13, 2011
Messages
2,521
Reaction score
6
Points
38
Location
Nanaimo, BC, Canada
Website
www.excelguru.ca
Excel Version(s)
Excel Office 365 Insider
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...
 

Rick

New member
Joined
Jun 15, 2011
Messages
4
Reaction score
0
Points
0
Location
Marietta, GA
Excel Version(s)
16.49
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.
Rick
ps Nanaimo is a lovely place to live!
 
Top