What's that? You wanna chit chat? Welcome to the whore thread!

shoei · 10-13-2016, 02:28 PM

Quote:

Originally Posted by duck fat

Quote:

Originally Posted by ///M Power-Belgium

Why you didn't bought one ?
Or sell your ///M3 , the S65 has bad bearings anyway and buy the Skyline ?

The R34 is very taboo in California. There was a whole scandal where a company was illegally importing them and were eventually seized and crushed. So these models are very much on the radar for the cops. The only ones, at the moment, that can be legally imported and registered are the 32s because they fall under a special 25 year exemption. By the time the 34s are old enough to fall under this exemption, I'm sure all of the good ones will be stored away by some rich bastard long before it could be registered and that's assuming the 34s can get registered.

You register it in maple syrup land... Best way around it... And yeah, good ole MotoRex...

Banana Hammock · 10-13-2016, 02:28 PM

Quote:

Originally Posted by UncleWede

Separate tables contain the names and the reference is just to that table? I can't guarantee the UID is ALWAYS in both tables.

A VLOOKUP will return a #N/A if it can't find a corresponding UID. It acts more like a LEFT JOIN than a INNER JOIN.

UncleWede · 10-13-2016, 02:29 PM

Index on UID
If UID in table 2, copy Name to table 1 Name
next

M3 Number 86 · 10-13-2016, 02:29 PM

Excel shit and no one tagged me?

Index match is superior. You can ask do lookup with a match if you don't want to count columns.

You can indirect for anything, sheets, cells, rows, columns, etc. it's pretty awesome.

bimmette · 10-13-2016, 02:30 PM

Who is suntanlinus???

Banana Hammock · 10-13-2016, 02:31 PM

Quote:

Originally Posted by shoei

You register it in maple syrup land... Best way around it... And yeah, good ole MotoRex...

How does one go about registering a car in the United States of Canada?

Quote:

Originally Posted by M3 Number 86

Excel shit and no one tagged me?

Index match is superior. You can ask do lookup with a match if you don't want to count columns.

You can indirect for anything, sheets, cells, rows, columns, etc. it's pretty awesome.

Your Excel Spider Sense seems to be working well.

ASBSECU E93 · 10-13-2016, 02:31 PM

Quote:

Originally Posted by suntanlinus

Quote:

Originally Posted by ASBSECU E93

suntanlinus - I am partial to Space Gray as well....

...and Crimson Red

That red though......space grey never gets old!

Yea - red

Banana Hammock · 10-13-2016, 02:33 PM

Quote:

Originally Posted by bimmette

Who is suntanlinus???

Someone who really likes to sun tan?

bimmette · 10-13-2016, 02:37 PM

Quote:

Originally Posted by duck fat

Quote:

Originally Posted by bimmette

Who is suntanlinus???

Someone who really likes to sun tan?

And has sun tan lines too? Hmmm

UncleWede · 10-13-2016, 02:37 PM

Quote:

Originally Posted by bimmette

And has sun tan lines too? Hmmm

Named Linus irl

Banana Hammock · 10-13-2016, 02:39 PM

Quote:

Originally Posted by bimmette

And has sun tan lines too? Hmmm

Mmmhmm. It's a clever way of saying "Sun tan line us!"

///M Power-Belgium · 10-13-2016, 03:00 PM

Quote:

Originally Posted by Aatish

She is well. Wants to bake cookies.

Cookies ? Ohhhh .. Christ ! C'mon Bhai !

I think it's time my friend to let flow your animal instinct to the hot stuff ...
The next video shows you how to do it , so please watch and listen + consider the video as an education for your real wild thing .

Mr Tonka · 10-13-2016, 03:15 PM

@ASBSECU E93 see, I was in Ft Myers and didn't visit JT. Do you feel better now?

:

Biorin · 10-13-2016, 03:33 PM

Quote:

Originally Posted by Mr Tonka

@ASBSECU E93 see, I was in Ft Myers and didn't visit JT. Do you feel better now?

:

Justin Timberlake lives in Fort Myers!? How rude to not drop by.

bimmette · 10-13-2016, 03:34 PM

Quote:

Originally Posted by Biorin

Quote:

Originally Posted by Mr Tonka

@ASBSECU E93 see, I was in Ft Myers and didn't visit JT. Do you feel better now?

:

Justin Timberlake lives in Fort Myers!? How rude to not drop by.

Cry me a river.

Mr Tonka · 10-13-2016, 03:38 PM

Quote:

Originally Posted by Biorin

Justin Timberlake lives in Fort Myers!? How rude to not drop by.

No, i stopped by and sang a few songs with Justin. It's jtodd_fl that got stiffed today. Well, not stiffed.... cause i didn't stop.

Is this where i add "#nohomo"?

Aatish · 10-13-2016, 03:39 PM

Don't you want to bring SexyBack?

Mr Tonka · 10-13-2016, 04:25 PM

Quote:

Originally Posted by Aatish

Don't you want to bring SexyBack?

Do you mean you're going to shave yourself again?

Yes, please bring that back.

suntanlinus · 10-13-2016, 04:52 PM

who's suntanlinus? this guy, in chicago, somewhat new to the forum, I feel like I'm too much of a noob to be in here....

Aatish · 10-13-2016, 04:52 PM

Ok do it, but MKSixer is helping.

UncleWede · 10-13-2016, 04:54 PM

Quote:

Originally Posted by suntanlinus

who's suntanlinus? this guy, in chicago, somewhat new to the forum, I feel like I'm too much of a noob to be in here....

sink or swim. If you are here in 48 hours, you learned to swim.

shoei · 10-13-2016, 04:59 PM

Quote:

Originally Posted by duck fat

Quote:

Originally Posted by Aatish

That's tastefully done up!

Indeed.

All you really need on a GT-R is a nice set of coilovers and TE37s.

Today...

10-13-2016, 02:29 PM	#40549
UncleWede Long Time Admirer, First Time Owner 18326 Rep 9,410 Posts Drives: G01 X3 M40i Dark Graphite Join Date: Jun 2005 Location: Oxnard, CA iTrader: (0)	Index on UID If UID in table 2, copy Name to table 1 Name next
	Appreciate 0

10-13-2016, 02:29 PM	#40550
M3 Number 86 Major General 3232 Rep 6,217 Posts Drives: black m3 Join Date: Mar 2015 Location: pasadena iTrader: (1)	Excel shit and no one tagged me? Index match is superior. You can ask do lookup with a match if you don't want to count columns. You can indirect for anything, sheets, cells, rows, columns, etc. it's pretty awesome. __________________ dadmobile IG: @M3number86 youtube: track vids
	Appreciate 1 Biorin2784.50

10-13-2016, 02:30 PM	#40551
bimmette YouTube.com/TvTara 6433 Rep 4,714 Posts Drives: like I stole it! (11 m3 E93) Join Date: Nov 2013 Location: Vancouver iTrader: (0)	Who is suntanlinus??? __________________ Watch my DIY mods at: YouTube/TvTara Follow me on Instagram at: TvTara1
	Appreciate 0

10-13-2016, 03:15 PM	#40559
Mr Tonka is probably out riding. 6057 Rep 2,292 Posts Drives: Something Italian Join Date: Feb 2009 Location: Sweatypeninsula iTrader: (0)	@ASBSECU E93 see, I was in Ft Myers and didn't visit JT. Do you feel better now? : Attached Images __________________ "There is no greater tyranny than that which is perpetrated under the shield of the law and in the name of justice. -Charles de Secondat"
	Appreciate 0

10-13-2016, 03:39 PM	#40563
Aatish Lofty 3471 Rep 849 Posts Drives: i4 M50, 991.2 C2, RRS Diesel Join Date: Dec 2013 Location: ORD <> ATX iTrader: (0)	Don't you want to bring SexyBack?
	Appreciate 1 Banana Hammock3738.00

10-13-2016, 04:52 PM	#40565
suntanlinus Private 20 Rep 68 Posts Drives: 335is coupe space grey/coral r Join Date: Mar 2016 Location: Chicago iTrader: (0)	who's suntanlinus? this guy, in chicago, somewhat new to the forum, I feel like I'm too much of a noob to be in here.... __________________ ST
	Appreciate 1 bimmette6432.50

10-13-2016, 04:52 PM	#40566
Aatish Lofty 3471 Rep 849 Posts Drives: i4 M50, 991.2 C2, RRS Diesel Join Date: Dec 2013 Location: ORD <> ATX iTrader: (0)	Ok do it, but MKSixer is helping. __________________ F30 335 (FBO and BM3 OG) 991.2 C2 Range Rover Sport Diesel I4 M50 (coming soon)
	Appreciate 0