integers

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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