Results 1 to 8 of 8

Is column Sorted, with possible duplicates

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    3,979

    Is column Sorted, with possible duplicates

    I've been looking all over, with no success. I want either a formula or a VBA function to determine if a column is sorted. I've attached the best candidates I've found, both a formula and function based on that formula. However, while it works well to tell me if a column is sorted, it fails if the column contains duplicates. Is there a way to determine if a column of values, which may or may not contain duplicates, is sorted alphabetically?

    I appreciate any help I can get.
    Attached Files Attached Files
    I know I'm not stupid, but I suspect I'm a lot stupider than I think I am

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Add up quantitites in Column E based on duplicates in Column A, then delete duplicates
    By eli-vergara in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-02-2016, 05:44 PM
  2. Replies: 4
    Last Post: 09-15-2014, 06:01 AM
  3. [SOLVED] How to make a sorted list Column by Column using array formula
    By turist in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-09-2013, 11:11 AM
  4. [SOLVED] Find duplicates in column A, add values from column B (possibly delete duplicates)
    By luarwhite in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-12-2013, 04:34 PM
  5. Replies: 1
    Last Post: 05-06-2013, 06:28 AM
  6. [SOLVED] have a column of random dates. want a formula for an output column of them sorted
    By James C in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-03-2013, 04:24 PM
  7. Replies: 0
    Last Post: 02-13-2006, 04:45 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1