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
Last edited by Aranell; 06-27-2013 at 06:50 AM.
Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
[EDIT]
We are editing out of sync...
Try this in C1, Drag/Fill down
Formula:
Please Login or Register to view this content.
Last edited by Marcol; 06-27-2013 at 06:53 AM.
Perhaps
=MIN(A1:B1)&"-"&RIGHT(MAX(A1:B1),3)
hmm both didn't work:
the first "the formula you typed contains an error"
the second just don't give me the result I need
This kind of comment doesn't help at all.Originally Posted by Aranell
Both seem to work for me
Go with Jindon, it's shorter.
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
Well let we say I have in
A
123456
and in B
123956
I get in C
123456-8
great
now I need it in VBA
I'll tray my self
OK I've manage it to work... halfway:
Cells(3, 1).Value = (Application.Min(TextBox1.Value, TextBox2.Value) & "-" & Right(Application.Max(TextBox1.Value, TextBox2.Value), 3))
I just discovered some issue, which i didn't take in considiration before...
I would write like this
TextBox?...
Please Login or Register to view this content.
I would write like this
TextBox?...Please Login or Register to view this content.
Great it works fine
about the TextBox: well actually what I want is to enter 2 numbers from a userform, and if the first digits much together than it it will be saved on a the sheet on the way like
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks