+ Reply to Thread
Results 1 to 3 of 3

How to use one column to guide another

Hybrid View

  1. #1
    Registered User
    Join Date
    05-10-2014
    MS-Off Ver
    Excel 2003
    Posts
    13

    How to use one column to guide another

    Hello everyone
    I hope someone can help.
    I have Column A that has street names. In Column E is a figure of how many times the street name has been asked. In column F, i put a X when I know them.
    Some times I add new data that includes duplicates in A where they have been asked again and the number in E increase. I know how to remove the duplicates and then I am left with the row with the higher value.
    I want to transfer the X from Column F into the duplicate when it matches so i don't have to go through the whole sheet to put an X in again.
    Can that be done?
    Do I make any sense?

    Many many thanks

  2. #2
    Valued Forum Contributor
    Join Date
    11-02-2012
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    564

    Re: How to use one column to guide another

    So you want to put an X mark in column B against any duplicate value of column A? Is that it?

  3. #3
    Registered User
    Join Date
    05-10-2014
    MS-Off Ver
    Excel 2003
    Posts
    13

    Re: How to use one column to guide another

    Hello
    I want to put a tick actually in Column F.
    Is that possible?
    Many thanks.
    K

+ 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. VBA Guide or resource
    By Aussiexile in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-06-2010, 01:59 AM
  2. Guide interface
    By yo250 in forum Excel General
    Replies: 1
    Last Post: 12-17-2007, 03:28 AM
  3. Please Guide Me , I Need Some Help ?
    By khanjee in forum Excel General
    Replies: 1
    Last Post: 03-20-2007, 05:37 AM
  4. [SOLVED] Guide:help
    By TONY in forum Excel General
    Replies: 4
    Last Post: 11-18-2005, 10:15 AM
  5. Guide on Functions
    By Justin in forum Excel General
    Replies: 2
    Last Post: 09-27-2005, 09:05 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