+ Reply to Thread
Results 1 to 2 of 2

Formula that swiches data from colum B to colum A if colum B has lower value

  1. 02-03-2022, 10:58 AM #1
    Darbas1
    Darbas1 is offline
    Registered User
    Join Date
    02-03-2022
    Location
    Klaipeda
    MS-Off Ver
    2013
    Posts
    1

    Exclamation Formula that swiches data from colum B to colum A if colum B has lower value

    What formula would change data from colum B to colum A if colum B has a lover value than colum A
    Reply With QuoteRegister To Reply
  2. 02-03-2022, 10:59 AM #2
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,863

    Re: Formula that swiches data from colum B to colum A if colum B has lower value

    Welcome to the forum.

    Do you mean this?

    =IF(B1<A1,A1,B1)
    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.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    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. search for a tacking number in Colum A, and past todays date in Colum B
    By paulsheker in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-12-2020, 12:48 PM
  2. Formula Help matchin colum a with colum b to display colum c
    By dbe82 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-08-2013, 10:11 PM
  3. copy and paste colum K to colom R and skip filled cells colum R
    By jdrmer in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-13-2012, 10:30 AM
  4. Keeping a sum colum correct after inserting a colum of data in fro
    By hazel in forum Excel General
    Replies: 3
    Last Post: 10-19-2005, 05:05 PM
  5. RE: Look up data in colum a and find match in colum b
    By Jess in forum Excel General
    Replies: 1
    Last Post: 03-22-2005, 10:13 AM
  6. Check data on colum A and find match on colum b
    By Chris(new user) in forum Excel General
    Replies: 3
    Last Post: 03-20-2005, 01:07 PM
  7. [SOLVED] Look up data in colum a and find match in colum b
    By Chris(new user) in forum Excel General
    Replies: 1
    Last Post: 03-19-2005, 05:30 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1