+ Reply to Thread
Results 1 to 4 of 4

compare two col and place result in cell

  1. 01-23-2016, 09:02 AM #1
    gilnic
    gilnic is offline
    Registered User
    Join Date
    12-01-2015
    Location
    ballarat
    MS-Off Ver
    2013
    Posts
    85

    compare two col and place result in cell

    Hello,
    Hoping I can have some assistance with my project please. I am working with Excel formulas.
    In my sheet, Col A changes the data as each race becomes ready, and consists of anywhere between say 5-30 names in the format- 2. Red as per attached sheet.
    I prepare a list of names and place them in Col AK. These names are pruned from the races.
    Now what I would like to be able to automate is when a name appears from the list in ColAK
    in ColA to enter “YES” in cell AL1.This process to then continue as each new race appears.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 01-23-2016, 09:05 AM #2
    etaf
    etaf is offline
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.84 (24041420))
    Posts
    8,757

    Re: compare two col and place result in cell

    Put
    =IF(COUNTIF(A:A,AK1)>0, "yes", "no")
    into AL1
    and copy down the sheet
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
    Reply With QuoteRegister To Reply
  3. 01-24-2016, 01:07 AM #3
    gilnic
    gilnic is offline
    Registered User
    Join Date
    12-01-2015
    Location
    ballarat
    MS-Off Ver
    2013
    Posts
    85

    Re: compare two col and place result in cell

    Hello etaf,
    Thank you for prompt response and solution.
    Reply With QuoteRegister To Reply
  4. 01-24-2016, 05:37 AM #4
    etaf
    etaf is offline
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.84 (24041420))
    Posts
    8,757

    Re: compare two col and place result in cell

    your welcome - thanks for the rep
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. MACRO to ping IP addresses and place result in adjacent cell
    By RC4G in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-12-2015, 09:03 PM
  2. Lookup and place result in specific cell
    By kjones600 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-09-2014, 12:46 AM
  3. [SOLVED] trying to write a vba that will copy a formula result and place it in another cell as text
    By Shellybelly in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-02-2014, 08:12 AM
  4. place in cell X1 a result subject to conditions
    By crinkly36 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-23-2010, 06:56 AM
  5. automaticly place the person in 1st, 2nd, 3rd etc. place according to the result of t
    By sync in forum Excel General
    Replies: 2
    Last Post: 06-24-2007, 10:16 AM
  6. [SOLVED] Compare cell = one result
    By Aaron Saulisberry in forum Excel General
    Replies: 7
    Last Post: 01-23-2006, 12:55 AM
  7. [SOLVED] Place a formula result in a different cell
    By Patrick Simonds in forum Excel General
    Replies: 1
    Last Post: 12-23-2005, 02:10 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1