+ Reply to Thread
Results 1 to 4 of 4

how to choose data from two different columns and put it in a 3rd column

  1. #1
    Registered User
    Join Date
    10-01-2014
    Location
    jordan
    MS-Off Ver
    office 2010
    Posts
    2

    how to choose data from two different columns and put it in a 3rd column

    hello.
    I need to know how to automatically compare the data from two different columns and choose the bigger value and automatically put it in the 3rd column

    example:

    column A has a data of 1,2,3,5,3,1 ((each number in different cell)
    column B has a data of 2,2,3,6,1,2

    i need the column C to get the bigger data value automatically and get

    2,2,3,6,3,2


    is there is a possible way to have it ?

    thanks in advance

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: how to choose data from two different columns and put it in a 3rd column

    Hi, and welcome to the forum.

    =MAX(A1:B1)
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    10-01-2014
    Location
    jordan
    MS-Off Ver
    office 2010
    Posts
    2

    Re: how to choose data from two different columns and put it in a 3rd column

    Thanks for rhe fast response.

  4. #4
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: how to choose data from two different columns and put it in a 3rd column

    You're welcome.

+ 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. Replies: 6
    Last Post: 11-28-2010, 07:52 PM
  2. Insert specific Data from SQL Server, Choose columns
    By leitethomas26 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-29-2009, 05:16 AM
  3. Compare 2 columns and choose one and enter answer in third column
    By Betsy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-30-2006, 01:20 PM
  4. [SOLVED] Choose data from a particular column based on a specific value
    By markx in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  5. Choose data from a particular column based on a specific value
    By markx in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM

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