Results 1 to 6 of 6

Compare and replace colomuns with names

Threaded View

  1. #1
    Registered User
    Join Date
    12-21-2022
    Location
    Belgium
    MS-Off Ver
    2016
    Posts
    14

    Compare and replace colomuns with names

    As a result, I want the names in column A (with matching value in B) in column C. An additional problem is that there are more names in column A than in column C.
    These extra names may be removed. So the important thing is that e.g. A: Aberasturi J. & B:4; A: J. Aberasturi & B: 4 becomes.

    Thanks in advance!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Replace present formula names with reference data sheet names list
    By Khaldon in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-05-2021, 09:41 AM
  2. [SOLVED] Compare two names list and compare other column aftrerwards
    By badboynads in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-25-2013, 12:46 PM
  3. Function to write Data to DB from specific rows and colomuns Plus specific Timestamp
    By Mudhafar.M in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-18-2013, 08:01 PM
  4. [SOLVED] I need to compare student quiz submission names/grades against a master list of names.
    By NoxExcel in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-15-2013, 08:00 PM
  5. [SOLVED] change colour of the adjacent colomuns
    By durga_ikon in forum Excel General
    Replies: 8
    Last Post: 05-10-2012, 08:26 AM
  6. Replace bad names from a list of good names
    By realniceguy5000 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-15-2009, 01:39 PM
  7. Replies: 0
    Last Post: 02-23-2006, 01:33 PM

Tags for this Thread

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