1. C

    Check Digit

    Trying to do a 10 digit mod 10 check digit with a weight of 7,5,3,2...can you assist me. Thanks.
  2. B

    help with dates in VBA

    I'm relativity new to VBA. I am hopeful someone can help me with the below macro. The Macro takes a day of the week like Monday or Tuesday and converts it to a real date based on whats imputed. It works the way I want other than, I need it to be formatted as a 2 digit month 2 digit day and 4...
  3. G

    VBA code to count based on conditions in cells

    Hi, I am looking to automatically generate a unique identification number for each row in my spreadsheet. A few components of the number will be passed into the spreadsheet from another source. But, I need help creating two different parts of the ID. The first is a 3 digit number that will...
  4. P

    copy/paste 16 digit number

    When pasting numbers Excel converts any digits after 15 digits to "0" so 1234567812345678 becomes 1234567812345670 I need to cut and paste from an email. Is there a way to paste so the 16th digit shows correctly (without going manual) Perhaps with a auto prefix of comma? Thanks
  5. T

    Using VLookup to overwrite existing value used to do the lookup

    Hi all, My data is like this: In one column (normally D, but could move) I have a 3 digit country code Stored on another sheet, in A:B, I have a digit country code (A) and a 2 digit corresponding code (B) I want part of my macro to lookup the 3 digit code and replace it with the 2 in the...
  6. L

    upto 1, 2, 3 digits

    Hi I went to Format Cell -> Fraction and I saw the first 3 options. 1) Upto 1 digit 2) Upto 2 digits 3) upto 3 digits I entered in a cell this value 1.1 and formatted 3 cells as above, so i got this <colgroup><col><col><col><col></colgroup><tbody> upto 1 digit upto 2 digits upto 3 digita...
  7. G

    Gnatt Chart with Countif & ????

    Column A is 5 digit Order Number Column B is Customer name Columns C thru O are X’s or 0 depending on which stage Order is in. Using VBA to set conditional formatting for C thru O columns With ThisWorkbook.Worksheets(1).Range("C3:O3") .FormatConditions.Delete .FormatConditions.Add...
  8. D

    converting a 6 digit string into a 3 character string

    First post. Need to get LUN ID from a Disk UID initial DISK UID is a string of around 20 odd characters. I only need the last 6 which i can do. but then i need to convert that 6 digit string into a 3 character string. like so initial 6 digit string 3 4 4 5 3 4 only intrested in characters 2...
  9. P

    Underline a specific part of a text string using VBA.

    Hey all, Currently I'm working on a question that i'd like to look like this: <tbody> What is the value of the underlined digit in 8512? </tbody> The digit i'd like to underline is in cell X6 and the text string is in cell C9 (the formula for which is ="What is the value of the underlined...
  10. A

    Select the text after the space after the last digit in the cell?

    I have to solve the question above to avoid manually splitting 1000 lines. I'm not quite sure if the part about the last digit is possible however. Can that be done somehow? I think I can manage the rest if I knew how to get the index of the last digit in a cell. Some address in some city #50...
  11. Z

    Keep leading zero

    I have some vba code that saves a file to a specific folder based on the month. The month is set by the user as a two digit format (01, 02, etc) and set as a variable in my vba code. However, when I run the code the file doesn't save, and I've found that it has to do with the fact that the...
  12. S

    Formula Help

    Hi everyone, I would like to find a formula that will calculate how may cells back when a digit appeared. For example, A1 = 2 B1 = 2 C1 = 2 2-2-2 9-7-0 8-1-3 1-4-3 7-3-5 9-2-9 6-6-8 2-0-7 1-4-8 7-7-2 Step1: Count how many cells back until the 1st digit 2. In this example the 1st 2 is 5...
  13. S

    Formatting messed up dates that bled into another column

    Hello, I have a huge spreadsheet that mixed in date numbers from one column to another <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px"...
  14. T

    Data Validation - 5 Digit Number with exclusion list

    Hi All, I'm looking for a data validation formula that can achieve the following: Only allow the input of a 5 digit number Don't allow the input of the 5 digit numbers in a list (The list is in cells F5020:F5045) Any help is much appreciated Thanks Tom
  15. T

    Using Index function with multiple criteria

    I am currently using the following formula to extract from the columns below on the left containing various 3 digit numbers: {=IFERROR(INDEX(B$1:B$21,SMALL(IF($B$1:$B$21=$H$3,ROW($B$1:$B$21)),ROW(1:1))),"")} So in the first example I am looking for the value of 1 for the first digit and...
  16. L

    Unique List From 2 Columns

    Hello, I have a full list of 5 digit numbers in Column B and an incomplete list of 5 digit numbers in Column A. How can I have a unique list in Column C? These will be the missing 5 digit numbers. Can this be done with formulas? Thank you very much for your help.
  17. A

    Luhn check digit formula

    Hey guys i need some help with Luhn check digit formula, i need to make formula for 13 and 14 digits for card number validation, i tried and i search online but it won't help... If someone knows or have the formula please help, it would be much appreciated!!
  18. M

    Data entry from excel to terminal

    Hi , Needed help in inputing data from excel to terminal ,excel contains only 10 digit numbers to be Inputted into main frame any idea please
  19. L

    IF statement based on a number in a certain position in another cell

    I need to know how to write the following: =IF(3rd digit in cell J2="2","2-10051","1-10031") I do don't know how to obtain the 3rd digit. I tried researching this and tried several ways but got "error" or "false".
  20. D

    WEEKNUM - every 10 week 6 digits

    Hi, I did use weeknum on my calendar table and it was mostly correct, but also incorrect in some places. So I'll probably have to remake, but I still want to understand the issue. But the absolute strangest thing that has occured is that every 10 week (10, 20, 30, 40 and 50) is a 6 digit...

Some videos you may like

This Week's Hot Topics