Results 1 to 8 of 8

Find a value looking in two columns

Threaded View

  1. 05-21-2015, 09:25 AM #1
    ghostexcel
    ghostexcel is offline
    Registered User
    Join Date
    04-14-2014
    Location
    London
    MS-Off Ver
    Excel 2013
    Posts
    28

    Find a value looking in two columns

    Hi all,

    I have two columns (please see the attached file)

    Would like to find a formula that looks in both column A and B and find only the value in the column A that have only one number in column B; in this example is going to be the value C, as in the column B all the value for C are 0 (there is no any value C with number 1 related)

    Many thanks
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
« 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. Find Duplicates across 2 pairs of columns (2 columns against 2 columns)
    By erjfly2013 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-09-2015, 06:52 PM
  2. [SOLVED] .Find Help - Search only in specific columns (or ignore other columns)?
    By NewYears1978 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-25-2014, 11:32 AM
  3. [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
  4. Find duplicates based on two columns then combine columns to one row??
    By hschreppel in forum Excel General
    Replies: 1
    Last Post: 02-13-2012, 08:08 PM
  5. Excel 2007 : Using Match to find Find Matches Across 3 Columns
    By boohah in forum Excel General
    Replies: 2
    Last Post: 03-02-2009, 12:15 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