digit

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

this is the question posted by another member in "Questions in Other Languages" https://www.mrexcel.com/forum/questions-other-languages/1099110-extract-tail-tail-combination.html that I'd translated here the last digit of any pairs of numbers in A:F matched the last digit in G, merged the...

Hi all, sorry I may not managed to correctly phrase my initial question... I have a Source Table with several columns (and hundreds of rows) from which "Code" and "Identifier" are causing troubles. In "Code" there is always a 2 digit number. (00, 01, 02 etc.) in "Identifier" there is always a 5...

I am trying to find text pattern from String. pattern I am looking for is 6 digit dot 7 digit ex: 123456.1234567 can someone build me needed code for above pattern? explaining how code would be appreciated. I downloaded 5 digit number code from www it reads .Patern = "(?:^|\D) (\d{5})...

Hello, I have this table and I am looking for a cooler way to use it as a guide and create an algorithm from it. So from the table, 1 is assigned to A, J and S. So say a word like “KELLY”, I want to add up all the characters by using their number value. That’s “Kelly” = 2+5+3+3+7 = 20. Then I...

Hello, I need help with this algorithm. I have a cell say A2 that contains a given number and I want to use these rules for it: (1). Sum all the characters up (2). If the result form the sum is more than a 1-digit number, then we sum the characters of our result up again till we get a single...

Is there a way to change the color of 1 digit in a 2 digit number in a cell? For instance if the number in a cell is 53 I want the 3 to be red and the 5 to remain black, and every time a 3 appears in my data I just want the 3 to be red. So if I type 693 I would like just the 3 to be red and...

got this frmula here and it does work as long as my numbers are smaller than.10000 =LEFT(H29,3)&"."&MID(H29,4,1) i need to have the decimal point 1 digit from the right. at ALL times HELP

This is a two part question. Have a report with an apostrophe in front of a series of numbers. The first part is to remove the apostrophethen the second part is to find a specific two digit number within the seriesof numbers. Reading the series right to left in two digit format. There is a...

Hello All, I have a set of dynamic data that is somewhat inconsistent. My objective is to pull text from the set of data based on a specific unchanging criteria. However, at times -as I've already indicated because of the dynamic data- not all of the criteria is able to be fulfilled and it ends...

Hi All, I think this should be fairly easy but I am just a bit of an issue getting a formula to work. I need to calculate a check digit for a bar code. The # is 3910037276 The instructions to figure check digit are as follows: Work with the leftmost 10 digits. Starting from the left take...

Hello Exceptional Excel Extraordinaires, I come before you to seek your guidance with this issue i'm currently struggling with and would really like to solve and or automate. I have two databases which i need to join or relate, been trying to do it in access but one of them has the...

Hi I require a little help (scrub that change little for a lot of) please, trying to write a formula where is looks at 2 non adjacent cells in one tab, and looks in another tab to see if it can find the same info, if it does then to put from the 2nd tab another cell value. So in (tab1)W1 IF...

I need to SUM a range where some of the cells contain partial text as below: 5 6 2 L5 4 SUM should be 22 taking the digit from second last cell also.

In cell a1 I have a concatenate formula with this result 1-2-10-12 I would like to break that out to col b ,col c, col d and col e showing them as separate individual numbers b1=1 c1=2 d1=10 and e1 =12 at times these numbers will change so I want to accommodate a two digit or one digit...

Hi guys, Im having some difficulty formatting a 2 digit financial year. I currently have a column for the installation date --> which contains either just a month, or a specific date and a column for financial year --> this contains this equation: =IFS([@[Inst''n...

Hi All, New here, first posting. Kinda fun. I am working with some free text data that includes one of multiple five digit numbers I need to separate out. I have found an equation from here that pulled one code, but not all. Could be up to 8 in one free text set. I am not good with VBA, so...

I have a large spreadsheet where I have one column with a 6 digit number and the next column with a single digit number. I wish to cocantenate them but need 2 zeros to the left of the 6 digit number and 1 zero to the left of the single digit number and a hyphen between the two like so. Cell in...

Do macros work with Excel Online? I have a spreadsheet that executes check digit code after the user enters that value in the cell.

Need a hand please. I'm not great with formulas in Excel.. Searched the forum with no luck with the help I need. Below describes what I need to create a check digit. Looking for a formula to do this in Excel. Thanks for looking and help. The calculation is as follows...