increasing

Hi, Is this possible to detect this kind of sequence in 250k-750k row data. 1) Count start at least the sequence of up-down 2) Stop the count if next value is not in squence of, increasing(up)-decreasing(down)-increasing(up)-decreasing(down),.... , example: i- up-down->down ii-...

Hey Everyone, I have a spreadsheet that has 4 formulas in the last 4 columns at the end of the spreadsheet, it's an increasing spreadsheet(4900+ Rows increasing daily when refreshing a query) these formulas have been manually filled down, but I wanted to automate it into a macro since we...

Hi Hope someone can assist, looking for a calculation to give a precise value. I have this table <colgroup><col style="mso-width-source:userset;mso-width-alt:2779; width:57pt" width="76" span="2"> <col style="mso-width-source:userset;mso-width-alt:4534;width:93pt" width="124"> <col...

https://www.dropbox.com/s/i2bstjil8pgkbha/Master%20Estimate.xlsx?dl=0 Please see spreadsheet I am trying to set up The H12 cell is showing the correct result but I have had to manually pick the required cell from the Estimate tab. This is 30 rows down from the H11 cell. What formula would do...

Hello! I'm in search of a formula that can be copied and pasted (or pasted special) for increasing a number by different percentages (10%, 20%, 30%, etc). I know how to do it if I type out the formula in each cell, but I need a shortcut. Here's an example: Suppose the number 10 is in A1. I want...

I need solution for increasing Nested-If limit more that 07 Please help

Hi, I would like to dragdown the below data which have been typed in Z1, Z2, Z3 cells respectively and get it relatively increasing... #Sheet1!A1 #Sheet1!C1 #Sheet1!E1 Can someone please help me? Thanks alot... :)

Hi I’m trying to drag and fill and range of cells to add one to a cell from another sheet. Cell A1 =DATES!E6 Cell B1 =DATES!E6+1 Cell C1 =DATES!E6+2 Etc But when I drag and fill it is increasing the cell reference rather than the increment. Any help would be appreciated