+ Reply to Thread
Results 1 to 12 of 12

Find values that appear in various columns

Hybrid View

  1. 04-18-2014, 10:41 AM #1
    Marvin85
    Marvin85 is offline
    Registered User
    Join Date
    07-24-2013
    Location
    new york
    MS-Off Ver
    Excel 2003
    Posts
    62

    Find values that appear in various columns

    Hey guys,

    I have 6 columns containing Agency IDs of different years. I would like to know which agencies appear in all the years. That is which agencies were funded for all the years. How can I do this? perhaps Vlookup?

    Thank you in advance.


    Best,
    Marvin
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-18-2014, 10:59 AM #2
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2504 Win 11
    Posts
    24,705

    Re: Find values that appear in various columns

    See attached.
    Attached Files Attached Files
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
    Reply With QuoteRegister To Reply
  3. 04-18-2014, 11:53 AM #3
    Marvin85
    Marvin85 is offline
    Registered User
    Join Date
    07-24-2013
    Location
    new york
    MS-Off Ver
    Excel 2003
    Posts
    62

    Re: Find values that appear in various columns

    test_1-1.xlsxBro I notice some errors in the formula. For example agency AK0001 appear in 2007 however it says NO in the formula. Please see attached. Thank you...
    Reply With QuoteRegister To Reply
  4. 04-18-2014, 12:01 PM #4
    Haseeb Avarakkan
    Haseeb Avarakkan is offline
    Forum Guru
    Join Date
    05-24-2011
    Location
    India
    MS-Off Ver
    365
    Posts
    2,243

    Re: Find values that appear in various columns

    Hello Marvin,

    AK0001 in K2 have some spaces. Remove those spaces then should be OK.
    Regards,
    Haseeb Avarakkan
    __________________________________
    "Feedback is the breakfast of champions"
    Reply With QuoteRegister To Reply
  5. 04-18-2014, 12:03 PM #5
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2504 Win 11
    Posts
    24,705

    Re: Find values that appear in various columns

    deleted. Wrong response

    Edit: Haseeb has found the issue.
    Last edited by alansidman; 04-18-2014 at 12:06 PM.
    Reply With QuoteRegister To Reply
  6. 04-18-2014, 12:07 PM #6
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Find values that appear in various columns

    @Marvin85

    you have 7 spaces in cell K2, so the value is no the same with cell B2.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.
    Reply With QuoteRegister To Reply
  7. 04-18-2014, 12:10 PM #7
    Marvin85
    Marvin85 is offline
    Registered User
    Join Date
    07-24-2013
    Location
    new york
    MS-Off Ver
    Excel 2003
    Posts
    62

    Re: Find values that appear in various columns

    Thank you all... you are the best. Is there a way to systematically eliminate spaces? Thank you!
    Reply With QuoteRegister To Reply
  8. 04-18-2014, 12:48 PM #8
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,432

    Re: Find values that appear in various columns

    Try the TRIM function.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    NB:     as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  9. 04-18-2014, 01:05 PM #9
    Marvin85
    Marvin85 is offline
    Registered User
    Join Date
    07-24-2013
    Location
    new york
    MS-Off Ver
    Excel 2003
    Posts
    62

    Re: Find values that appear in various columns

    Thank you.. bro!
    Reply With QuoteRegister To Reply
  10. 04-18-2014, 01:13 PM #10
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,432

    Re: Find values that appear in various columns

    Quote Originally Posted by marvin85 View Post
    thank you.. Bro!
    lol!
    Reply With QuoteRegister To Reply
  11. 04-18-2014, 01:15 PM #11
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Find values that appear in various columns

    @marvin85

    Please add to whom you responding.

    By the way AliGW is a girl instead of a boy.

    So bro is mispelled in this case.
    Reply With QuoteRegister To Reply
  12. 04-18-2014, 01:16 PM #12
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,432

    Re: Find values that appear in various columns

    Marvin knows this, Oeldere - he was referring ironically to another thread in which I took part earlier this afternoon.
    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. [SOLVED] Find count of Unique or Duplicate Values based on Concatenated values in 2 columns
    By bdicarlo1 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-03-2014, 12:42 AM
  2. vb find code to find values from specific columns in excel and upload values of same row
    By swapbhay in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-19-2013, 08:30 PM
  3. How to find closest values in multiple columns and return adjacent values.
    By Patrician in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-28-2013, 01:47 PM
  4. [SOLVED] Using range.find to find two specific values in two columns
    By mhrub in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-31-2012, 01:02 PM
  5. Need to know how to find like values in 2 different columns
    By walwril in forum Excel General
    Replies: 1
    Last Post: 04-21-2009, 12:20 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1