numeric

Hi, I am trying to split Alpha Numeric data into separate columns but not having any luck. Can someone Help with this. What I would like it to look like <tbody> Reference A30 A 30 A30_1 A _ 1 A30_1_2 A _ 1 _ 2 A_30 A _ 30 A_30_1 A _ 30 _ 1 A_30_1_2 A _ 30 1...

I'm trying to find the last row with a numeric value in a range (R8:X57). I tried this: =MIN(ROW(R8:X57))+ROWS(R8:X57)-1 The result was 57 instead of 11 since the rows 12 to 57 have no values, but do have formulas. I tried =LOOKUP(2,1/(LEN(R:X)>0),ROW(INDIRECT("1:65536"))) the result is 7...

I'm looking for a formula that can take out a "non numeric" character from within a number. For example: Values in column A are 123456-1 123456-2 123456-3 123456-4 123456-5 123456-6 123456-7 123456-8 123456-9 123456-10 I want to covert them so that they show in column B without the "-"...

Hi, I s it possible to show text values in a pivot table as opposed to numeric. I need to display numbers but also some titles (text) in the pivot table. I need it to go in the value box as text from the table not a numeric value. Hope that makes sense. Thanks,

Is it possible that I can enter a numeric value and a date in the same cell, but only the numeric value is taken for calculations. say, Cell A1 has "100", and Cell B1 has 25 - 03-09-17 in it . What I need in cell C1 is 100-25 = 75. (the result 75 only). 25 is the sale done on 03-09-17, and now...

Hi All, I am trying to create a condittional format to highlight cells that meet the following criterir. If the cell is greater then or equal to 50 (any number I choose) and greater than or equal to 10%. I have started with =if(and(a1-b1>=50, I just don't know how to finish the formula off. I...

Hello I have this working code that calculates from row 2 to 1000 on column L and skips 4 columns to P then T and so on... skipping 4 columns at a time up to column 176 (PT) but I see it is taking too long to calculate Here is the code that works vertically now Sub CALC2_() Dim rng As...

I have a data set for annual budget planning - 50 clients with multiple line items per client (i.e. Account Management, Project Management, Licensing, Freight etc) i'm comparing last year budget to this year's budget and want to show both the numeric delta and the percentage deltas for each...

Hello, I hope someone can help to solve this riddle... In my workbook I have a data feed that populates a single cell for volume. (500 K to 5+ M). I divide that number by seconds in a day. (23,400 seconds per day)/ (3,000,000)= 128 per second This trade per second number can fluctuate...

Hi I'm trying to obtain this format TT-T#-T# and I'm using this formula but when I tested it failed to follow the pattern in text and numbers, it only kept the 2 dash 2 dash 2 format...

Hi All, I have a large spreadsheet and am just learning Power View and PowerPivot - I have a load of numeric and currency fields in my spreadsheet, but only one (the unique identifier) is coming up with the sigma sign next to it meaning that I can aggregate the data. I want to be able to...

Is there a way to extract numerical data and have it hold its value? I can write a program to extract: 12 pucks, 456 sticks, 7890 fans to 1234567890 123-456-7890 to 1234567890 but here is the actual outcome I am looking for: 123 345 7890 123 345 7890 I would...

If IsNumeric(ThisWorkbook.Sheets("sheet1").Cells(RowCounter, "A")) = True Then Call Method End If InitialRow = InitialRow + 1 Next MsgBox ("The End") End Sub Hi All, Above is the Code if the Column A has a Character go to Next line Works Perfect. BUT it Exits...

Hi guys, I need your help! I'm creating a Text 2 Win contest where consumers will have to text in a unique 7 digit code to a phone number. How do I create 60,000 unique 7-digit codes in excel? (numbers 0-9)

Hi all, So this is a strange one and must be solved by using VBA. Any help is much appreciated. Plain and simple, when a numerical character is entered into a cell I want the result to add "Group " before the number. So if someone enters 100, the result is "Group 100". If the number has been...

I am doing a document register where each document starts at Revision A. Once that document is revised, it becomes Revision B, then C, and so on. Once the document is formally approved, the revision number system changes to 0, and when Revision 0 is modified it becomes Revision 1, and so on. Is...

Hello Where there is an entry in Cell A3 like "10th to 14th Floors" I am using the formula below to return the first numeric value from A3, in this case "10" =LOOKUP(50,--("0"&MID(A3,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A3&"0 123456789")),ROW($1:$10)))) This works just fine, but I have been...

Hi All, I really would appreciate some help with a formula. I am trying to extract 4 characters which will be sitting together in a string, however, the particular 4 characters I am looking for will be sitting as a NUMBER/LETTER/LETTER/NUMBER. For example, from the string below I am trying to...

Hi, I am struggling with a macro to set multiple pivot items based on multiple cells. I have tried different codes but they don't work as they should be. In this case, I would like the macro to set the months based on cells "'Validatie'!AQ2" and "'Validatie'!AQ3". These cells contain numeric...

I have large number of Alpha-numeric values in which i need to lookup other values. For example, the values are sorted from A1A - A1D - How would I make excel to find the value of A1B which is within the range given. Below i Have a sample of the data: Your help is very much appreciated...