# integers

1. ### Fill values top down

B2:B9 is +ve Integers C1 is Value Output Required in D2:D9 as TO FILL VALUES STARTING D2 & Considering range B2:B9 TOP DOWN Thanks in advance Sheet1 <colgroup><col style="FONT-WEIGHT: bold; WIDTH: 30px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH...
2. ### Can VBA grab multiple integers from a string?

I have a string which will include text, numbers and punctuation. It's free text so it's never constructed in a consistent fashion. Within that string, there will occur 4x 5-digit integers. Sometimes the integer will be preceded by a space or a symbol (like " 12345" or ":12345" or "-12345" etc)...
3. ### What does Ctrl+` do?

I was working in one workbook when I meant to switch to another one using Ctrl+tab, but I hit the key just above the tab my mistake -- the one the the "`" and the "~". All of the cells in that sheet turned into something that looks like text. The date cells show integers (the serial numbers)...
4. ### Calculating a percentage of two integers

Hi, I'm trying to work out some VBA to calculate the percentage of two integers..... not sure if I am doing the right thing. I have these two lines counting rows not blank Stat = Application.WorksheetFunction.CountA(Sheets("EMAIL TOOL").Range("G:G")) - 1 lstat =...
5. ### Column Calculation

It's early morning here and brain not in gear. In Excel, I need a formula to generate an integer depending upon the column number. Starting at column 3, the integers are simply 1,2,3. Column 3 : Integer 1 Column 5 : Integer 2 Column 7 : Integer 3 and so on. I'll be embarrassed when I see it...
6. ### Foreach style loop in Excel, no VBA?

Hi, I am working in Excel Online and am wondering if there is a good way to implement a foreach loop. I do not believe Excel Online currently supports VBA macros, but if you know how I can add them, I'd be willing to work with them. I have two columns of data, A and B. A contains names, B...
7. ### Extracting Integer from DateTime values

Hi all, Hopefully its just a quick solution needed here: I have a table column that contains imported datetime values. I have formatted them as 'dd-mmm-yy', and am trying to extract counts that fall between different date ranges. However, I've noticed that the values are not truly integers...
8. ### How can add best two integers from different three sheets

How can add best two integers from different three worksheets. I have three sheets PWT1,PWT2,PWT3. How i can add best two integers of same cell oo three diffent sheets. I have used following formula but it not works...
9. ### Help adjusting existing macro that creates a comma separated string

I was passed down this macro that joins a list of entries in column A, into one continuous string separated by a comma and makes it 10 digits longs. If it is shorter than 10 it adds zeroes to the front. I don't really see what this macro is doing enough to tweak it, but essentially what I want...
10. ### How to get the VBA to calculate in loops or run more efficiently

Hi All I have a really large range that requires mapping and recalculation and is taking a long time to recalc, any suggestions and ideas on how to make this more efficient? was thinking a loop or defining integers but i am really unfamiliar with this function. mapping is on 20457 rows and 34...
11. ### Sort four integers

Hi, I have four integers stored in four variables. I need to sort these, and in a descending order put into appropriate cells (A1, B1, C1, D1). However, there also can be a string instead of one integer I managed to find the integers, and store them into variables. I also managed to identify...
12. ### Add cells from different tabs which contain integers, ignoring text

I have a workbook with several tabs. In the front sheet (sheet 1) I want to add up the total of cell A5 from every tab. Every tab pulls data from the master sheet (Master sheet) using the below formula. =IF(ISBLANK('Master sheet'!AA5),"",'Master sheet'!AA5) This is causing the problem as...
13. ### Identifying rows that sum up to the largest total

<tbody> Row # Value 1 385 2 -732 3 244 4 457 5 436 </tbody> Is there a formula in excel that would identify the consecutive values that yield the highest sum ? In this simple example adding rows 3 to 5 will give you the highest total which is 1,137. I have a list of nearly 1,000...
14. ### SUMPRODUCT/COUNTIFS array formula works perfectly, but it's slow and killing my processors!!

Hi all, I found an array formula that I adapted into my Excel 2013 workbook. My version entered as an array formula reads as follows: {=SUMPRODUCT(IFERROR((\$B\$2:\$B\$1667&\$F\$2:\$F\$1667=\$B2&\$F2)/COUNTIFS(\$S\$2:\$S\$1667,\$S\$2:\$S\$1667,\$B\$2:\$B\$1667,\$B2,\$F\$2:\$F\$1667,\$F2),0),\$S\$2:\$S\$1667)} It works...
15. ### SUM rounded number instead of real number (result of a formula)

Hi Everyone, Hope you can help me with this one. I have several results of several formulas combining functions as IF, SUM, *, -, %, etc... I need those results to be integer numbers, without decimals, so I've decreased the decimals (Home menu/number format) The problem is that based on those...
16. ### Integer tick mark values not set by the decimal axis minimum value.

Hi everyone, sorry I think this must be a really simple thing to sort out but for the life of me I can't seem to figure out how to do it (or word the question accurately enough to get a good response from Google!): I've got a pretty simple xy scatter graph with two Y-axes. On the primary...
17. ### Integer tick mark values not set by the decimal axis minimum value.

Hi everyone, sorry I think this must be a really simple thing to sort out but for the life of me I can't seem to figure out how to do it (or word the question accurately enough to get a good response from Google!): I've got a pretty simple xy scatter graph with two Y-axes. On the primary...
18. ### trouble with do loop

Hi, for a given integer n I perform the following steps until I get to 1 if n is even then then next step is n/2 if n is odd then the next step is 3*n+1 for example. starting with 3 goes: 3-10-5-16-8-4-2-1 We say that 3 has a length of 8 Now I've written the following code: Sub...
19. ### Loop help

Last question for today...I hope. I want to find the last row with data and call that value from the loop in my vlookup formula (bold red), as opposed to current hard coded values. These amount of rows will be different each time I run. Here is my code: Sheets("VSC to FGA").Select...
20. ### Putting Column Headings in Forumlas

Hi, I want to place this forumla "=IF(INT(B3/\$U\$1)=(B3/\$U\$1),1,0)" across my worksheet. Now, I'm okay when dragging down as it works fine with the B3 changing to B4 and the U1 staying as U1. However, I would like it so that when I drag it horizontally, the U1 becomes V1. I want it so that...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back