Results 1 to 11 of 11

Sort the values depends upon first three segment

Threaded View

  1. 07-30-2016, 11:43 AM #1
    johnmacpro
    johnmacpro is offline
    Forum Contributor
    Join Date
    02-28-2016
    Location
    australia
    MS-Off Ver
    2019
    Posts
    194

    Sort the values depends upon first three segment

    Dear expertise

    I have data which is splited as minus and plus values along with MICR Code. on both side

    i want sort the values both side from largest to smallest on both side, but same values repeat values are there but same MICR code.

    i want match TE008-145788-109-E1207-008R-USD-INR & TE008-145788-109-E1307-008R-USD-INR first three segment value

    if atleast two segment match then sort value to exact MICR code
    TE014-145794-125-E1213-008R-USD-INR = 720995
    TE014-145794-115-E1313-008R-USD-INR = -720995

    Find the attachment
    Attached Files Attached Files
    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. Have a large lookup that depends on 2 values...
    By CallumWebley in forum Excel General
    Replies: 6
    Last Post: 04-22-2016, 07:22 AM
  2. [SOLVED] VBA Code replace old values to new values depends upon column values
    By johnlara in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-09-2015, 08:19 AM
  3. Ms access Vba Save Data to xl depends upon 1 table pick & Depends 2 Upon fiterDate
    By breadwinner in forum Access Programming / VBA / Macros
    Replies: 14
    Last Post: 05-29-2014, 10:59 PM
  4. vba code to replace old values by new value depends upon 2 col values
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-27-2014, 03:22 AM
  5. [SOLVED] Fill the values & replace the old values by vba code depends upon 2 col
    By johnodys in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-27-2014, 03:11 AM
  6. [SOLVED] vba to Replace Old values by new values depends upon cell values in AC:AC col
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-25-2014, 08:15 AM
  7. [SOLVED] Need vba or formula help to set values depends upon 3 conditions values in 3 col
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-17-2014, 12:34 PM

Tags for this Thread

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