ending

  1. M

    Distributing the value of Beginning No. Median Number and Ending No.

    I have a beginning number of 110, the Ending is 150 and the Median 130. How can I distribute the beginning, Median and ending in 11 column? what is the formula to get the gaps in between 110 to 150 with a median of 130 in 11 columns?
  2. D

    How to align days of week, by week, when comparing current year to previous years?

    I need to compare sales volumes YoY by week. However I want to ensure the days of week are aligned (i.e. Sun of week x in 2017 = Sun of same week in 2016). I want the values on the X-axis to be week ending Saturday for the current year. The formula for week ending Saturday which I'm using is...
  3. J

    Copy rows to new excel book with different sheets

    Hello, I need to copy rows with different letters to separated sheets in a new excel file. Example <tbody> a 45 46 c r 44 12 d v 55 33 e v 44 22 c g 22 11 f f 44 33 d g 88 77 e </tbody> all rows ending with c need to be placed in a new workbook on a sheet rows ending with d or...
  4. R

    VBa code to subtotal by week ending date and monthly total

    Hello, Help needed in a report. The data is listed in columns as indicated below. I need to generate a report showing an end of week subtotal ending on each Thursday at close of business. The fields that I need to generate by VBA are listed below the data. I need VBA to make each column and...
  5. K

    XIRR returns 0.00% instead of a negative percentage

    Hi, I'm running a savings scenario where the ending value of my investment ends up being less than the total contributions based on monthly returns during a down market period, but the XIRR is returning a 0.00% instead of a negative percentage. In other periods, when the ending value is...
  6. C

    Syntax Error

    I am trying to write code to insert this formula into a cell but it is coming up with an error box saying that it is expecting an ending. Can anyone help? Cells(1, 8).Value = "Letter Grade" Cells(2, 8).Activate ActiveCell.Formula =...
  7. S

    Arranging numbers in a particular order

    Sir , I have a query with starting register number and ending Register number of a batch of students how can i create a report as given below (for Eg. starting reg.Number 346 and ending Reg.Number 483) REGISTER NUMBERS FROM TO 346...
  8. W

    Using sumif across multiple worksheets?

    I'd like to perform a conditional sum across multiple worksheets. Variations on the following doesn't work: =SUMIF(First:Last!D7:D126,1, First:Last!D7:D126) where first and last are the beginning and ending worksheets. Is there a way to make this or something similar work? (Excel 2010)
  9. L

    Conditional formatting based on preceding cell in a series of columns

    I have a worksheet that contains the dates /days of the month in a row header (a single row using 31 columns for each day of the month) and asset numbers in a single column on the left. Next to this column of assets is a column reserved for mileage "starting" and "ending". Since I am using...

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top