digit

Good Morning, I have been trying to write a VBA code all morning to get this table so that there is only one UPC column and one UPC check digit column for each row of data. I need to have the data in columns A-I for each row of a different UPC. There are some rows that have up to 10 different...

I have a report that I need to get the return as the facility name. I am trying to see if a formula or a macro will solve my problem. So in the sample below, I need to look up values on the First Sheet Column A (3 digit zips) and compare it with column B (3 digit zip to look up from) on the...

Good Afternoon to All... I have 2 columns, as the source information. Column # 1 consists of 6 digit numbers. Column # 2 consists of names that are associated to each number in Column # 1. I would like to key in the info of #1 (the 6 digit number) in any cell and have the name associated with...

I have a single column of values on an excel spreadsheet. The contents of each individual cell correspond to Gate Codes, and are inputted exactly like the red text below: example 1: 4 example 2: 4,6 example 3: 2,6,7 example 4: 5,12,1 Note: there will NEVER be a triple digit number - just 1-2...

I am wanting to have many ISBNs in column 1. In column 2, I want to be able to type the last 4 numbers of an isbn from the column one list and then have the whole ISBN show up in column 3.

Hi I would be very grateful for a formula that will result in the number of times a single digit - e.g. 6 - occurs in the range 001 to 500. Many thanks!

I have column "A", with a list of names, preceded by a two digit number. I need to isolate that two digit number in column "B". Thank you.

Hello, I’m looking for the total number of possibilities for a four digit entry where: 1. Available digits = 0,1,2,3,4,5,6,7,8,9. 2. Any single digit can only be used once. 3. Any combination of four digits are equal and only counted as one possibility (i.e., 0123, 3210, 1230, 2130 etc...

Hello, Using 4 digit 0,1,2,3 in the row how many set could be formed which sum could be = 14 Note: each single digit can be used 0-to14 times too. Like this example <tbody> 0 1 2 3 Sum 14 0 0 0 14 0 4 7 3 14 1 4 5 4 14 1 6 5 2 14 2 4 7 1 14 1 8...

I have a set of values all of which are comprised of one letter and one digit number like (a1,a2,a5,b2,b4,c3,c1,d4,e5,etc) in A1:F5, and I would like to sum these values (the last numeric values) in G1. I need to sum the numbers disregarding the letters. Every value has one digit number at the...

Please, can someone help me with this one: I have a cell containing a 11 digit number. I would like to give another cell a conditional formatting based upon the 3rd digit from the right in this 11 digit number, or 9th from the left if you like. The formatting should be one for odd number, and...

I know that I probably need INDIRECT function but cant get the formula right. I have a multiple tabbed workbook and the tab name is a 4 digit number. Like 1234. I have data in that 1234 tab that I want to have show up in another "master" sheet. My 4 digit numbers are in A2 thru A72 so I need...

I am trying to fathom out best way to approach data input issue I can auto populate with an employee number a whole range of metrics with lookup but it has to be in a certain format and I want an data validaton pop up saying incorrect format if not input correctly All employee numbers start...

Looking for some VBA code to help with the following need. Rows in column G contains a five digit number. Rows in column H contains a combination of text and numbers. Combinations in column H always ends with “-XXXXX”. I need to append the five digit number in column G such that the five...

Pardon my ignorance but I'm struggling with this one! I have an dataset as shown below: <tbody> A B 1 77+ 77 2 98- 88 3 66= 66 4 55+ 66 </tbody> The formula I would like to crack requires comparing the leftmost digit from column A to the leftmost digit in column B over the array and...

Hi all, I think this issue has been dealt with extensively but I am unable to find the relevant thread. I have a 20 digit number that excel is converting to zero's due to its specification. I am able to display the number by converting into text. However, I need to create logic which allows me...

All formations of suits of each two groups digit Are even / odd 0.2,4,6,8 1,3,5,7,9

Column B lists my part numbers that are 3, 4, 5 and 6 digit long, some with letters on the end. They are formatted as numbers with the exception of numbers with leading zeros (00023). I would like to sort using the first digit of the item number as such... 1000 110 110300 11040 11040S ...but i...

I want to change the formula below to give me the left 3 numbers if col A has a 6 instead of 5 digit code in it, but still return the left 2 only if there is a 5 digit code in col A <tbody> Col A Col B 15035 =IF(A1="5522",50,LEFT(A1,2)) </tbody>

I need a formula, that see in column G, if the corresponding cell in G is empty, it leaves empty, if the first digit is 4 then the formula should populate “BIL”, (no quotes), if the first digit is 7 then “NON”. So there are three condition, if it is empty, leave empty, So the formula will be...