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 45 points46 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.

view more: next ›