+ Reply to Thread
Results 1 to 2 of 2

How to sort a column to read off of 2 other columns

  1. #1
    Registered User
    Join Date
    09-08-2016
    Location
    Texas
    MS-Off Ver
    MS 2007
    Posts
    56

    How to sort a column to read off of 2 other columns

    If I have column H needing to read off of column D but I need the word in column C to fill in column H what would be a formula for that? Below I did my best to show a sample, Keep in mind it can go off of COLOR or WORD or both on column D. Each one of the 7 words has its own color filled cell, so repeated words will have same colored cells. Thank you.


    C D H
    1 Sand 1
    2 Metal 2
    3 Dirt 3
    4 Rock 4
    5 Fire 5
    6 Water 6
    7 Oil 7
    8 Sand 8
    9 Metal 9
    10 Dirt 10

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    6,726

    Re: How to sort a column to read off of 2 other columns

    Welcome to the forum

    Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

+ 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. Replies: 1
    Last Post: 03-29-2018, 07:58 AM
  2. [SOLVED] Sort columns B,C,D based on column B then loop to next 3 columns and repeat till last colu
    By Andy15 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-09-2017, 05:35 PM
  3. Formula to read code in Column D, then apply color to columns a, b, c?
    By Lorann in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-28-2014, 07:10 PM
  4. Replies: 2
    Last Post: 01-15-2014, 09:31 AM
  5. Replies: 5
    Last Post: 04-25-2013, 11:50 PM
  6. Replies: 5
    Last Post: 08-17-2012, 06:03 AM
  7. how do I separate 1 excel column to read city, state, zip columns
    By usndiv in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-26-2006, 05:40 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