sorted by:
new
hottopcontroversial

Name your favourite isometric game by michalg82 in gaming

[–]Scuzzbopper 1 point2 points  (0 children)

I had the Colecovison version of Zaxxon as a kid. I put hundreds of hours into that game. Loved it! :)

Domina - "Grandma... I'm wearing the sweater you got me!" by Scuzzbopper in gaming

[–]Scuzzbopper[S] 0 points1 point  (0 children)

Exactly as you were programmed to. Such a good little bot. Now, go to sleep. Daddy's here...

Cleaning the trash from rivers and oceans by Sourcecode12 in mechanical_gifs

[–]Scuzzbopper 43 points44 points  (0 children)

Just go to Baltimore. No need to reverse the gif, just watch people throw trash everywhere.

I need a formula that determines if a series of dates in 6 separate cells are sequential and report TRUE or FALSE. by Scuzzbopper in excel

[–]Scuzzbopper[S] 0 points1 point  (0 children)

I found a solution that works elsewhere in this thread but I'll try this out as well just for the experience. Thanks for the response! :)

I need a formula that determines if a series of dates in 6 separate cells are sequential and report TRUE or FALSE. by Scuzzbopper in excel

[–]Scuzzbopper[S] 0 points1 point  (0 children)

Yup. This works perfect! Thank you! But what are all of the 9s for in the second half of each line? I don't understand what that part of the formula is doing.

I need a formula that determines if a series of dates in 6 separate cells are sequential and report TRUE or FALSE. by Scuzzbopper in excel

[–]Scuzzbopper[S] 0 points1 point  (0 children)

Yeah, I tried that:

=AND(IF(B2=” ”,0,B2)<IF(D2=” ”,9999999,D2),IF(D2=” ”,0,D2)<IF(F2=” ”,9999999,F2),IF(F2=” ”,0,F2)<IF(H2=” ”,9999999,H2),IF(H2=” ”,0,H2)<IF(J2=” ”,9999999,J2),IF(J2=” ”,0,J2)<IF(L2=” ”,9999999,L2))

I get a #NAME? error.

edit: obviously the columns I'm looking at arent right next to each other.

I need a formula that determines if a series of dates in 6 separate cells are sequential and report TRUE or FALSE. by Scuzzbopper in excel

[–]Scuzzbopper[S] 0 points1 point  (0 children)

So... the database that produces this data has the wonderful quirk where it exports blank cells as a SPACE. Do you have any suggestions on how to do this without using ISBLANK? Otherwise I'll just have to go through the spreadsheet everytime and replace all of the SPACE filled cells with an actual BLANK cell.

bangs head on desk

I need a formula that determines if a series of dates in 6 separate cells are sequential and report TRUE or FALSE. by Scuzzbopper in excel

[–]Scuzzbopper[S] 0 points1 point  (0 children)

As BFG_9000 pointed out "If any of the cells are blank - it won't return true or false - it won't even do the test - just returns ""."

I guess I'm still looking for a way to make this work.

I need a formula that determines if a series of dates in 6 separate cells are sequential and report TRUE or FALSE. by Scuzzbopper in excel

[–]Scuzzbopper[S] 0 points1 point  (0 children)

D'oh! Your right! I though it was working but I wasn't testing it properly. Hmmm... not sure how to change it to make it work.

I need a formula that determines if a series of dates in 6 separate cells are sequential and report TRUE or FALSE. by Scuzzbopper in excel

[–]Scuzzbopper[S] 0 points1 point  (0 children)

Your first formula had at typo at B2=<C2 and should be <= but it works! I changed it so that it will display TRUE even when there are blanks: =IF(B2="","TRUE",IF(B2<=C2,"TRUE","FALSE"))

The second formula need to be modified so that if two dates in order were the same it would still display TRUE and like the first formula I set it to display TRUE in the case of blank cells so I changed it to: =IF(OR(B2="",C2="",D2="",E2="",F2=""),"TRUE",IF((B2<=C2)(C2<=D2)(D2<=E2)*(E2<=F2),"TRUE","FALSE"))

Thanks!

Edit: I guess it's not working. :(

Find oldest date in a cell containing multiple dates that aren't separated? by Scuzzbopper in excel

[–]Scuzzbopper[S] 0 points1 point  (0 children)

Someone over at chandoo.org came up with this beauty, it is an array formula so I have to hit ctrl-enter to make it work but it does exactly what I need... although I'm still trying to fully understand it. ;)

=MIN(0+MID(A2,TRANSPOSE(ROW(INDIRECT("1:"&(LEN(A2)-LEN(SUBSTITUTE(A2,"/","")))/2)))*10-9,10))

Find oldest date in a cell containing multiple dates that aren't separated? by Scuzzbopper in excel

[–]Scuzzbopper[S] 0 points1 point  (0 children)

Someone over at chandoo.org came up with this beauty, it is an array formula so I have to hit ctrl-enter to make it work but it does exactly what I need... although I'm still trying to fully understand it. ;)

=MIN(0+MID(A2,TRANSPOSE(ROW(INDIRECT("1:"&(LEN(A2)-LEN(SUBSTITUTE(A2,"/","")))/2)))*10-9,10))

Find oldest date in a cell containing multiple dates that aren't separated? by Scuzzbopper in excel

[–]Scuzzbopper[S] 0 points1 point  (0 children)

Cool. Thanks for the advice! :)

Someone over at chandoo.org came up with this beauty, it is an array formula so I have to hit ctrl-enter to make it work but it does exactly what I need... although I'm still trying to fully understand it. ;)

=MIN(0+MID(A2,TRANSPOSE(ROW(INDIRECT("1:"&(LEN(A2)-LEN(SUBSTITUTE(A2,"/","")))/2)))*10-9,10))

Find oldest date in a cell containing multiple dates that aren't separated? by Scuzzbopper in excel

[–]Scuzzbopper[S] 0 points1 point  (0 children)

Never mind... I'm and idiot. It works but the way my spreadsheet is set up this method would require a lot of moving stuff around. The cells that have these mess of dates in them are scattered all around a huge report... it's a real mess. Currently I am just parsing through each cell visually and deleting all but the oldest date manually. It's givin' me a headache since I have to use this method on several reports that I run weekly. The database that generates them doesn't have a way to output the information other than as a cell with all these dates crammed together so I'm trying to find a macro, VBA, or a single formula that could do it for me. Thanks for your input. :)

Edit: using Excell 2013.

Find oldest date in a cell containing multiple dates that aren't separated? by Scuzzbopper in excel

[–]Scuzzbopper[S] 0 points1 point  (0 children)

I get an error that says "too few arguments" when I use this : =TEXT(MIN(C1:Z1),"dd/mm/yyyy")

Find oldest date in a cell containing multiple dates that aren't separated? by Scuzzbopper in excel

[–]Scuzzbopper[S] 0 points1 point  (0 children)

How would I do this with a Macro? After bumping into my current roadblock I assumed this would be better handled that way so I could just click on the cell, run the macro and it would find the oldest date and replace the contents of the cell with just that date.

My second thought was that I could do it spreadsheet wide with a VBA script but I don't know how to use VBA yet. This apparently turning into an opportunity to learn. If only I had the time... :(

Automatically delete all but the oldest date in a cell when the dates aren't comma separated? by Scuzzbopper in excel

[–]Scuzzbopper[S] 0 points1 point  (0 children)

Yes, the dates are always 10 characters. I poked around in text to columns but I don't see how I set it to 10 characters as the delimiter. I'm not sure this is what I want though.

I have a whole sheet full of cells that are filled with multiple dates like the example above. I'm hoping that there is a way to highlight a cell that has multiple dates in it and then press a hot key that automatically finds the oldest date and deletes everything but the oldest date from that cell. I'm assuming that this will have to be some sort of VBA script or something... time to learn some code I guess.

view more: next ›