digit

hello i want to create list of random and unique numbers of 8 digits between 12345678 and 87654321 but any digit should not be repeat for example 12345678 ok 21345678 ok 32145678 ok 12245678 not ok. due to repeate of 2 87654321 ok 87754321 not ok due to repeat of 7 pls help

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

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...

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...

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

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...

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...

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...

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...

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...

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...

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...

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...

Hello, I have a huge spreadsheet that mixed in date numbers from one column to another Book1AB1start dateend date210131998022120093122920040418201746222016110220195100920161312019691720171208201771101199618201985292009blankRoster Most of the time the last digit in A2 (0 or 1) needs to be...

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

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...

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.

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!!

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

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".