Results 1 to 11 of 11

compare 2 different numbers and copy the last 3 digits.

Threaded View

  1. #1
    Registered User
    Join Date
    11-16-2012
    Location
    Mos Eisly
    MS-Off Ver
    Excel 2007
    Posts
    39

    Exclamation compare 2 different numbers and copy the last 3 digits.

    Hi can someone help me with this:
    It's difficult to explain so I will just give an example with what I need as end result:
    A
    123456
    987123
    456963

    B
    123965
    987582
    456123


    I need in C
    123456-965
    987123-582
    456123-963 (hier you see I began with the number in B than the 3 digits from A because the number 456123 < than the 456963 in A)

    in the attachement I've uploaded an example, the red column C is what I need
    Attached Files Attached Files
    Last edited by Aranell; 06-27-2013 at 06:50 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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