ending

  1. Dan Wilson

    Working with minutes and seconds

    Good day. I am running Excel 2013 on Windows 10 Home. I have a workbook with several worksheets tracking music. My goal is to take a concert (multiple songs) and track each piece of music. I have columns set up to track the starting time and ending time of a particular song within the entire...
  2. V

    Index/Match & Offset Problem

    Hi, below I created a simplified version of two worksheets I have. I'm trying to create a formula in Sheet2 that will find the 1st instance of the fund# in Sheet1 B:B, get the value to the left of it in A:A, offset that cell by the amount of rows between that cell and the 1st instance of...
  3. P

    Auto-Populate Columns Based on Cell-Lookup Result?

    STARTING POINT: <tbody> Name Beginning Change #1 Change #2 Change #3 Ending Bob Sarah </tbody> Data will be manually populated into the "Name" column above. After populating into the name column, my goal is to have the subsequent columns automatically populated based on whether...
  4. O

    Economics - Payout Date Formula, Ending Balance goes to 0 Date Formula

    Thanks in advance for any suggestions. I will let you know if any proposed solutions work. What excel formula (non-VBA) will calculate the:(1) the first date where the cumulative cash flow goes from negative or zero... to positive (i.e. Undiscounted Payback date). There is the possibility...
  5. S

    Extract cells to a different sheet

    Hello, Here is my problem. I need a formula solution for this. NO VBA. I have a single column (A:A) large (around 70000 rows, distinct) data. From that data, I need to extract some of the rows to another sheet based upon the starting and ending cell values. Here is the example for problem. In...
  6. Q

    if formula to differentiate between months

    Hello, I need some help with my data with different months across a financial year. I want to pull out ending month data, so where the date changes from one month to another eg. Sept - Oct - different month so pick the ending value shown in the column, else 0. The idea is that I want the...
  7. T

    Week Ending Date (Thursday)

    Is there an excel formula that will calculate the week ending (Thursday) date for the specified data?
  8. B

    Month counting formula between 2 dates, including months per fiscal year

    Hi, We take on contracts typically ranging from 3 months to 36 months. we always use the 1st of the month for the start and end dates. for example: Contract 1: 1/4/18-1/12/18 = duration 8 months Contract 2: 1/2/18 - 1/2/18 = duration 12 months Contract 3: 1/1/18 - 1/1/20 = duration 24 months...
  9. E

    Is there a quick way to generate a weekday calendar?

    Hello! Is there a quick way to generate a list of the weekday dates between a starting and an ending date? Without weekends? Thanks!
  10. M

    Trying to compare last years numbers to this years numbers

    Hi everyone, I have a full set of last years numbers that I am trying to compar to a set of this years numbers on a moving 4 week average. I can get the numbers for the current year using this array formula. =IFERROR(AVERAGE(INDEX('IWI Week Ending Usage Numbers'!3:3,LARGE(COLUMN('IWI Week...
  11. S

    Random Name Generator Without Ever Repeating

    Hi There, I know this has come up a billion times, but everything I have found has not solved my problem. I have a list of 50 hockey player names, a list of 10 intros, and a list of 10 ending sentences. For example: A1:A50 = player names, A60:A70 intro to a sentence ("I heard that" or "Someone...
  12. E

    Calculate Week beginning and Week ending date of CURRENT month only

    Hi Excel Gurus, I'm trying to figure out a formula that will calculate the week beginning and week ending of a specific date BUT only the current month. For example, 8/3/2018 has a week beginning of 7/29/2018 and a week ending of 8/4/2018. What formula can i use so that the week beginning date...
  13. J

    SUM IF all sheets ending with "Statistics"

    I hope I explain this okay because it's quite complicated but here goes: I have multiple sheets ending with the word "Statistics", Dave Statistics, Stuart Statistics, Alan Statistics etc (more sheets can be added at any given time) I need a formula that will... Firstly look in all sheets that...
  14. MCTampa

    Using a form to query between values

    Hello, I have a table of data where one column is called week number (from 1 to 52). I created form with "Starting Week" and "Ending Week" as individual unbound text boxes. I simply want the user to be able to filter their data between the Starting and Ending weeks. When I use the following...
  15. M

    Help with slicer week ending dates

    I have a pivot table with week ending day on it 6-Jan-18. But when I make a slicer for them they are not in descending order it is mix up. can someone help6-Jan-18 13-Jan-18 20-Jan-18 27-Jan-18 3-Feb-18 10-Feb-18 17-Feb-18 24-Feb-18 3-Mar-18 10-Mar-18 17-Mar-18
  16. A

    VBA Help: AVG by Cell Color

    I'm not sure if this is possible but I'm trying to get an average of a column of only cells highlighted in a certain color. The column has GM% of projects. The color coding I'm using is as follows: Green for current Projects Blue for up coming projects Red for projects ending soon I would...
  17. W

    Mileage Dilema

    I have a nephew that plays different country music gigs. He wasn't aware that he could claim the mileage on his truck to the IRS. There's no chance that I can get him to remember to write down his starting and ending mileage for each gig, but he posts all of his locations. What I need is a...
  18. G

    Date range

    I am trying to figure out whats wrong with this formula and why is not return a value when the Ending date is in the Middle of the month A4 is the Previous month Ending Date G27 is the End Date F27 Is the Start Date L14 is the Month Column for 12 months having the last day of each month in...
  19. Z

    Display VALUE if Condition Match

    Dear Team, Kindly help in my query, following is the explanation. <tbody> A B 1/3/2018 12:15 pm 2/3/2018 03:20 am 5/3/2018 2:15am 7/3/2018 9:00 am </tbody> <tbody> C D E F G H I 1/3/2018 2/3/2018 3/3/2018 4/3/2018 5/3/2018 6/3/2018 7/3/2018 OK OK OK OK OK </tbody> I...
  20. W

    VBA Activate open workbook with name ending as current date

    Hi, I have multiple files ending with current date, but the start of the filename is always different. For example "sun_(current date)" and "moon_(current date)" etc. The start of the file names are not known. I will have the macro file open and one of the multiple files that have different...

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