+ Reply to Thread
Results 1 to 5 of 5

How to sort the data in column B into positive and negative numbers according to column A

  1. 11-20-2022, 08:53 AM #1
    metrostar
    metrostar is offline
    Forum Contributor
    Join Date
    08-25-2020
    Location
    Taiwan
    MS-Off Ver
    MS 365+win 10(64bit)
    Posts
    185

    How to sort the data in column B into positive and negative numbers according to column A

    How to divide the data in column B into column C and column D according to column A

    Any help would be appreciated!
    Attached Files Attached Files
    Last edited by metrostar; 11-20-2022 at 09:10 AM.
    Reply With QuoteRegister To Reply
  2. 11-20-2022, 09:05 AM #2
    Glenn Kennedy
    Glenn Kennedy is online now
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,299

    Re: How to sort the data in column B into positive and negative numbers according to colum

    Delete ALL expected answers.

    =B2+MID($A2,2,255)*{1,-1}

    copied DOWN.
    Attached Files Attached Files
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
    Reply With QuoteRegister To Reply
  3. 11-20-2022, 09:07 AM #3
    Glenn Kennedy
    Glenn Kennedy is online now
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,299

    Re: How to sort the data in column B into positive and negative numbers according to colum

    Or... simpler still... delete all expected results.

    In C3:
    =B2:B10+MID(A2:A10,2,255)*{1,-1}

    job done.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 11-20-2022, 09:09 AM #4
    metrostar
    metrostar is offline
    Forum Contributor
    Join Date
    08-25-2020
    Location
    Taiwan
    MS-Off Ver
    MS 365+win 10(64bit)
    Posts
    185

    Re: How to sort the data in column B into positive and negative numbers according to colum

    Thank you Glenn Kennedy , You are amazing
    Reply With QuoteRegister To Reply
  5. 11-20-2022, 09:17 AM #5
    Glenn Kennedy
    Glenn Kennedy is online now
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,299

    Re: How to sort the data in column B into positive and negative numbers according to colum

    You're welcome!
    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] How to calculate Negative and positive numbers in the same column
    By savio in forum Excel General
    Replies: 12
    Last Post: 04-22-2018, 05:11 PM
  2. Ranking Positive and Negative Numbers in a Column
    By tim.morley in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-09-2018, 10:43 AM
  3. [SOLVED] Pairing negative and positive numbers if the have the same reference in another column
    By lctwigg in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-22-2016, 06:46 AM
  4. Highlight positive and negative numbers based on data from another column
    By kris26 in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 08-04-2014, 08:57 AM
  5. [SOLVED] Find consecutive 15 positive or negative numbers in a column
    By Sarangsood in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-19-2013, 05:26 AM
  6. How do I change a column of 500 numbers from positive to negative
    By JKB in forum Excel General
    Replies: 2
    Last Post: 09-28-2005, 12:05 PM
  7. [SOLVED] Any way to convert column of numbers from positive to negative?
    By Sue in forum Excel General
    Replies: 3
    Last Post: 03-24-2005, 03:06 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