Results 1 to 13 of 13

Search for similar cells in column and set corresponding value

Threaded View

  1. #1
    Registered User
    Join Date
    02-12-2014
    Location
    home
    MS-Off Ver
    Excel 2010
    Posts
    8

    Search for similar cells in column and set corresponding value

    Hi all,

    I have a list of codes in column A, I fill columns B,C,D with "x", depending on the situation.
    I need a program that finds similar codes in column a and fills in the corresponding cell like in the attached image so I don`t have to search previous inputs to set the same value.

    I do not want to use formulas because they take a lot of time to calculate, I have 9000+ codes to search through.

    Thank you!
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] colorize rows with similar sorted cells in column
    By Mally in forum Excel General
    Replies: 8
    Last Post: 08-12-2013, 12:18 PM
  2. filter only one cell from various similar cells in a column
    By marvinlajiant in forum Excel General
    Replies: 2
    Last Post: 07-27-2011, 10:14 PM
  3. Find and highlight similar cells in a column
    By martinez_pedro in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-12-2011, 10:03 AM
  4. Replies: 2
    Last Post: 04-02-2009, 01:55 AM
  5. [SOLVED] [SOLVED] Copying cells with similar column values
    By mohd21uk via OfficeKB.com in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 05-15-2006, 04:35 AM

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