Results 1 to 1 of 1

How to find duplicate cell to apply the same changes?

Threaded View

  1. #1
    Registered User
    Join Date
    06-10-2010
    Location
    new york, ny
    MS-Off Ver
    Excel 2007
    Posts
    1

    How to find duplicate cell to apply the same changes?

    Hi,

    Please refer to the attached file for more explanation ...


    Here's some info before starting >>

    For each style# (column A),there are multiple colors, and one of them has been selected as a feature color (column E). However, names of the feature colors (column B) sometimes REPEAT because they were available in both petites and avg sizes, for instance; in these cases, different color# (column D) have been assigned to distinguish them.

    Here's what I was trying to do >>

    I already indicated 'feature' color for each style#, but I didn't know that it was listed more than once for each style#. if you look at S200868313 WHITE (C5), for instance, it says 'feature' in E5 too, but another S200868313 WHITE exists in (C7), but it doesn't say 'feature in E7.

    How can I do this besides using data filter to go and click every single style#-feature color out there?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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