Scuzzbopper

u/Scuzzbopper


r/excel•

I have three columns.

In column A are unique record numbers for individual requests.

In column B are the dates that each request was submitted.

In column C are the dates that each request was executed.

I would like to make a chart that shows the number of records submitted and executed on a weekly basis as two separate bars, then I would like to have a third bar that shows the total number of records that have been submitted either in that week or previously but are still not executed.

I have been trying to set this up in a pivot table with some success but I can't quite figure it out. Honestly I'm not sure if a pivot table is the right way to this.

Using Excel 2016.

Sample data below

11


r/excel•

I actually have two related questions.

I am currently using the following formula to compare 2 cells that contain dates and report TRUE if they are sequential and FALSE if they are not.

=IF(B2>C2,"FALSE",IF(B2=C2,"TRUE",IF(B2<C2,"TRUE")))

I would like to modify the above formula to account for blank cells and not report FALSE if B2 is blank and C2 has a date.

I want to create another formula that compares 6 cells and reports TRUE if they are all sequential and FALSE if they are not, like this: B2<C2<D2<E2<F2 = TRUE. I would also like this formula to account for blank cells and not report FALSE if there are any blanks in the series, it should only report FALSE if a date

120

r/excel•

I have a cell with a series of dates that are not separated like this:

05/04/201605/05/201605/05/201605/10/201605/12/201605/03/201605/12/201605/13/201605/16/201605/18/201605/19/201605/25/201605/25/201605/26/201605/27/2016

I would like to find the oldest date in the list. I feel like I'm close with this formula:

=MIN(MID(A4,FIND("/",A4,1)-2,10))

But the formula is not complete as it just returns the first date in the cell. I'm not sure how to write the rest of the formula so it sort of "loops" through the cell and finds the oldest date.

Any suggestions?

313

r/excel•

I regularly have to edit a report that is produced by a database that fills hundreds of cells with numerous dates that are not separated by commas. I want to use a macro (or something) to delete all but the oldest date in each cell.

The data looks like this: 04/19/201605/04/201605/05/201605/12/201605/12/201605/17/201605/17/201605/19/2016

I want it to just be this: 04/19/2016

The dates are not always sequential. Sometimes the oldest date might be in the middle like this: 05/04/201605/05/201605/12/201605/12/201604/19/201605/17/201605/17/201605/19/2016

Any help is greatly appreciated!

12


r/patientgamers•

I've had a GameFly account for 6 years and I always get new releases a few days after they come out using the following method.

  1. Assuming that you have the "one out at a time" plan, make sure you send your current game back so that GameFly receives it at least a week before the release date of the game you want. This creates the situation where they have owed you a game for an entire week. Normally they would just send out the next game in your queue immediately upon receiving the one you sent back but then, the magic happens...

  2. Make sure that the new release game you want is and has been the only game in your queue for that entire week.

  3. Boom.

I usually get an email on Monday say

3616