digits

I'm looking for a formula that will add each time it find the duplicate digits per column.

Hello,</SPAN></SPAN> Column "B" contains the codes, in the column "C" codes are grouped by in the friction of (1 to 2187) (2188 to 4374) and so on, numbers.</SPAN></SPAN> Example B4=100 are in the group from 1 to 2187, and the B5=3250 is in the group from 2188 to 4374 Note: to get these...

Hi, Was wondering if anyone could show me how to get this formula below to: only match the last 6 digits of the cell BA5, rather than an exact match, Is this possible using this formula below or would I need VLOOKUP...

Row has, for example these digits in different cells: 1 2 3 1 4 5 2 I need to remove duplicates and consolidate these digits like this: 1 2 3 4 5

Hi everyone, can anyone suggest me that can we convert 8 digits or 7 digits numbers to date format Like example: 12022018 to 12/02/2018 7022018 to 07/02/2018 can this be done using vba, if yes please suggest me how. Thanks in advance

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

Hello wonderful Access Aficionados, So i have this Db, which has a set of 10 numbers in the following format 1-111-1111 and the second table has the same information but the system that it comes from, does not handle "-" dashes or empty spaces which end up looking like "1 011101111" which is...

If I have a cell with two digits - how can I use the SUBSTITUTE function to add an extra character to make the cell have 3 digits? So a cell with 11 would turn in to 011 or A11 Thanks for your help!

I have a column of numbers 8 digits long (text - to display leading zeros). I need to extract digits 2 and 5-8 and place in another column (e.g., 01234567 convert to 14567) or convert the numbers in the existing column. How do I format or combine Left, Right and Mid commands (or is there a...

Hi, I would like to type a number in excel with 10 digits, and show the following Type 1000000000 But See 10.00.00.0000 Is this possible? Thanks

Hi Need some help, but not sure if the below will make sense, so here goes: Assume cell A2 has a numerical value of 1489459. I am looking to capture just the last 2 digits of that number. The RIGHT(A2,2) formula gives me the correct output, but I think this formula formats the last 2 digits as...

please, separate the quadruple of 8 digits without repetition ex = 09 18 27 36 = yes 09 19 29 36 = can not have 3 digits 9, so it has repeated deletion separate only quadruple with 8 digits singles http://www.mediafire.com/file/clyc9117hy6667a/quadrupla_loteca.xlsx/file

Hi, Below are the numbers from which I want my vlookup formula to pick only the first 3 digits. However, if there is a "0" in the beginning of the formula, I'd like it to only pick the next 2 digits after 0. Could you please help me in this formula assessment. Currently, I've used the...

Hi everyone I am looking for a formula solution to extract information from a variable string of text. In short I need to segregate 4 pieces of information into 4 different cells Original String 90896 X SMITH P/P TOMS 500A 5 752315 20 Result desired: C1 90896 D1 5 E1 752315 F1 20 1- C1 1st...

I want to enter a formula to round the result ex: =c7/a6 ( I want the result of this rounded to 4 digits) =c4*a2+c4 (I want the result of this rounded to 0 digits) I know this is probably simple but I am having a brain fart...:wink: Thanks

I have a list of numbers where the first 9 digits often repeat, while the final 2 digits often differ. I want to automatically boil this down to: Where there is duplication among the first 9 digits, return the cell with the max value in the final 2 digits. If there is no duplication, simply...

Im looking for a formula that will return those 5 digits 1,2,3,4,5 by giving me the order from the smaller to the bigger number from row B3:F3 and when there are duplicate, it would read the duplicate from left to right. Row B3:F3 is 1,1,15,5,6 which will return the digits : 1,2,4,5,3 Row...

Good Evening! I am struggling with a formula, hoping someone can point me in the right direction. In a cell I have a text string that says "#15 of 214 H.." I need to extract the two numbers into their own cells. In this example 15 and 214 respectively. However, the numbers could be as...

Hi everyone, Need help with creating a formula: Digits = 0 through 9 Cells P4 through R4 are the most recent digits Position 1, Position 2, Position 3 Trying to calculate how many rows back when all 3 digits 9, 5, 4 appeared. So using the example below. The 5 & 9 (from cell range P4 through...

In my C column I have some data which looks like this : 0(1), 1(0), 0(0), 2(1), 3(0), 0(0), etc. I'm trying to sum up the numbers on the LEFT of the parenthesis. This example would nomally return 5. I tried using this fomula: =sumproduct(--(LEFT(C1:C30),1))) but i get a #VALUE ! error. Right...