+ Reply to Thread
Results 1 to 4 of 4

Formula to look across column and pull values into desired table.

  1. #1
    Forum Contributor
    Join Date
    02-06-2013
    Location
    Maryland
    MS-Off Ver
    Excel 2010
    Posts
    1,000

    Formula to look across column and pull values into desired table.

    Looking for formula to look into "Table A2:C30 and return values in E2:G30 If condition is satisfied. Formula will look across column (for example, A1:C1, if all values are the same (meaning duplicate), it should return only one (1) into E1. For this example,
    HTML Code: 
    For Row 9,
    HTML Code: 
    If all values are unique across column, formula should return each unique value in E, F and G table. For example,
    HTML Code: 
    See attached file.

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Formula to look across column and pull values into desired table.

    Formula for E2 =IF(A2=0,0,A2)

    Formula for F2 =IF(OR(B2=0,B2=A2),0,B2)

    Formula for G2 =IF(OR(C2=0,C2=A2,B2=C2),0,C2)
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Forum Contributor
    Join Date
    02-06-2013
    Location
    Maryland
    MS-Off Ver
    Excel 2010
    Posts
    1,000

    Re: Formula to look across column and pull values into desired table.

    mehmetcik: Formula is not working as desired. The formula should look into Table A2:C30. If all values are the same across A1:C1, the formula should return one (1) unique value into Outcome 1 heading. if there are two (2) unique values across A2:C30, the formula should return the first unique into column E and then spit out the second unique into F. Hope this helps.

    Thanks.

  4. #4
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,481

    Re: Formula to look across column and pull values into desired table.

    Try in E2:
    Please Login or Register  to view this content.
    F2:
    Please Login or Register  to view this content.
    Both ...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

    G2:
    Please Login or Register  to view this content.
    Drag all down.
    Attached Files Attached Files
    Quang PT

+ 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. how many times value exists for a vales in pivot table + chart
    By magicb in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 12-08-2018, 02:49 PM
  2. Replies: 3
    Last Post: 09-26-2018, 03:28 PM
  3. [SOLVED] What formula will search through a table and add up desired data
    By jbarano1 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-12-2015, 05:13 PM
  4. [SOLVED] A formula to remove duplicate vales from one column while keeping all other information.
    By hitower74 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-11-2015, 03:17 AM
  5. pull data from two sheet and paste into master sheet with desired column's only
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-13-2014, 03:39 AM
  6. [SOLVED] need formula to this logic, A column number B column blank then C column desired name
    By vengatvj in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 11-02-2013, 10:30 PM
  7. [SOLVED] Excel formula to get the desired value from the table
    By nasirchaudhary in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-14-2013, 09:24 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