+ Reply to Thread
Results 1 to 2 of 2

How to sort by cell color with the cell to the left sorting with?

  1. #1
    Registered User
    Join Date
    03-22-2017
    Location
    Westlake Village, CA
    MS-Off Ver
    2016
    Posts
    24

    How to sort by cell color with the cell to the left sorting with?

    I have a workbook with 3 columns:
    Column A (LEN = 11)
    Column B (LEN = 12)
    Column C (LEN = 12-1)

    So I did a data compare with C and A....looking for any duplicates. Column B and C are an exact match, minus the far right digit (=LEFT(B2,LEN(B2:B7120)-1))

    So instead of manually going thru each match and deleting the value in Column B, I would just like to sort by the colored cells in Column C, but have the adjacent cell in Column B sort with it.

    Any help appreciated. Thanks!

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    6,017

    Re: How to sort by cell color with the cell to the left sorting with?

    You should post your actual values, or at least a picture of what you have, and show how you want the data sorted....
    Bernie Deitrick
    Excel MVP 2000-2010

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Sort used range to left of named cell
    By delaing in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 04-06-2016, 05:47 PM
  2. Replies: 3
    Last Post: 07-01-2014, 01:51 PM
  3. [SOLVED] Formula to add a value to a cell, based on cell to the left's color
    By hellinabucket in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 12-11-2013, 01:55 AM
  4. [SOLVED] How to use custom sort while sorting left to right for entire dynamic used range
    By herbie226 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-05-2012, 11:58 PM
  5. Color code cell with case statement and datestamp cell(s) to the left
    By garricko in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-26-2010, 08:37 PM
  6. Sorting by Cell Color, Font Color or Cell Icon in Excel 2007
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 11-19-2007, 12:23 PM
  7. [SOLVED] is it possible to sort the data by cell shading or cell color?
    By L.T. in forum Excel General
    Replies: 3
    Last Post: 07-17-2006, 03:24 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