# numeric

1. ### Find last row with a numeric value in a range

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...
2. ### Extracting a "non numeric" character from with a numeric value

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 "-"...
3. ### Show text in pivot table

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,
4. ### enter a numeric value and date in a cell.

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...
5. ### Conditional Formatting to Highlight a Numeric and Percentage Change

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...
6. ### change from calculating vertically (each cell in Column) to horizontally (row)

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...
7. ### How see both numeric and percentage deltas in a pivot table

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...
8. ### Have a cell evaluate a number

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...
9. ### alpha numeric format with dashes

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...
10. ### Unable to aggregate numeric or currency fields

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...
11. ### Extract Numerical Data

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...
12. ### Excel Macro - Using IsNumeric and Cell IsEmpty as a condition

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...
13. ### Creating random, unique numeric strings

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)
14. ### VBA to add text character when number entered

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...
15. ### Return the maximum of A,B,C,0,1,2,3

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...
16. ### Adaption of formula to return the second number in a string

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...
17. ### Formula Help - Numeric Alpha Combination

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...
18. ### Set Pivot items on multiple (numeric value) cells

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...
19. ### Problem with Alpha Numeric Values

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...
20. ### Assign empty string to numeric variable

I have a form in which I assign some values With Me Let lBudgetID = .txtBudgetID.Value Let lMonthNo = .txtMonth.Value End With but if the fields txtBudgetID and txtMonth are empty, the code will fail since it's not possible to convert empty strings to numeric variables. How can I...

### This Week's Hot Topics

• VBA (Userform)
Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
• List box that changes fill color
Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
• Remove duplicates and retain one. Cross-linked cases
Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
• VBA Copy and Paste With Duplicates
Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
• Macro
is it possible for a macro to run if the active cell value is different to the value above it
• IF DATE and TIME
I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...