Do you think one of them is using gear pt. 2

CptFKNplanet said:
Straight up. Maybe he's one of those dudes that likes to watch his wife get fucked, like in pornos... I think I'll ask if I see them tomorrow.
Click to expand...

It's possible bro. Met a couple like that at a supermarket of all places. Few weeks later the guy is asking me to bang his girl :)
 
Fucking array functions in excel are pissing me off.
For some reason it keeps referencing the top cell in a range of cells, there is nothing that I can see in the formula that would do this:
=IF($C$11:$C5001=1, SUMIF($G$11:$G$5000,"<2000", $I$11:$I$5000), "0")
 
71Avido said:
Fucking array functions in excel are pissing me off.
For some reason it keeps referencing the top cell in a range of cells, there is nothing that I can see in the formula that would do this:
=IF($C$11:$C5001=1, SUMIF($G$11:$G$5000,"<2000", $I$11:$I$5000), "0")
Click to expand...

Never got great at excel and having not used it in years makes that worse
 
DreDay187 said:
Never got great at excel and having not used it in years makes that worse
Click to expand...

Excel is nuts. You can get it to do just about anything you want if you know a little coding.
THis is my crowning achievement so far:
=INDEX(X$11:X$41,MATCH(LARGE(IF(MATCH(X$11:X$41,X$11:X$41,0)=ROW(X$11:X$41)-ROW($X$11)+1,COUNTIF(X$11:X$41,X$11:X$41)-ROW(X$11:X$41)/10^5),ROWS(B$4:B4)),COUNTIF(X$11:X$41,X$11:X$41)-ROW(X$11:X$41)/10^5,0))

It's a cell that automatically ranks the value of a range of text.
Two things in excel that are very hard to code, text and color.
Excel cannot recognize either with it's native functionality, you need to actually write visual basic scripts just to get it to return the hexadecimal value for the color being displayed. If you actually want to DO something with that number, that's a whole 'nother can of worms.
 
71Avido said:
Excel is nuts. You can get it to do just about anything you want if you know a little coding.
THis is my crowning achievement so far:
=INDEX(X$11:X$41,MATCH(LARGE(IF(MATCH(X$11:X$41,X$11:X$41,0)=ROW(X$11:X$41)-ROW($X$11)+1,COUNTIF(X$11:X$41,X$11:X$41)-ROW(X$11:X$41)/10^5),ROWS(B$4:B4)),COUNTIF(X$11:X$41,X$11:X$41)-ROW(X$11:X$41)/10^5,0))

It's a cell that automatically ranks the value of a range of text.
Two things in excel that are very hard to code, text and color.
Excel cannot recognize either with it's native functionality, you need to actually write visual basic scripts just to get it to return the hexadecimal value for the color being displayed. If you actually want to DO something with that number, that's a whole 'nother can of worms.
Click to expand...

Yea see I leave that shit to my brother. He's the one that double majored in computer science and economics lol. I'm good with math and physical sciences.
 
hump-day-74.jpg


hump-day-94.jpg


hump-day-217.jpg


hump-day-234.jpg


hump-day-274.jpg


hump-day-304.jpg
 
You must log in or register to reply here.
Back
Top