Results 1 to 3 of 3

Thread: error message in Data/Sort?

  1. #1

    error message in Data/Sort?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,091
    Articles
    79
    Blog Entries
    14
    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...
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  3. #3
    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!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •