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

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

Quote:

Originally Posted by Aatish

You can bring one over under show/racing use. Have to keep it under 2500 a year.

Bring one over, store it for 8 years. Profit on price increase.

You have rekindled my determination to own one of these things.

I had already given up on it and was thinking about settling with a 33 or 32.

Aatish · 10-13-2016, 02:16 PM

Quote:

Originally Posted by duck fat

You have rekindled my determination to own one of these things.

I had already given up on it and was thinking about settling with a 33 or 32.

R34 is on my list for sure. Maybe in a couple years. Was thinking Supra, but said "F that".

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

Quote:

Originally Posted by Biorin

No! Fuck Vlookup! Index/Match is GREATLY superior. I feel strongly about this.

I think you need to involve Indirect to pick up across different sheets, though.

ASAP Tools help me do this, or do I have to actually LEARN something?

RJ_ · 10-13-2016, 02:24 PM

Quote:

Originally Posted by UncleWede

Like I said, I could do this no problem in dBaseIII. I'll start looking at vlookup now. That lets me merge the contents into a third sheet?

Something like this:

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

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

...and Crimson Red

Biorin · 10-13-2016, 02:26 PM

Quote:

Originally Posted by RJ_

Something like this:

Ooh I think I misunderstood what he wanted. That's a good way to show it. I still stand by Index/Match - the vlookup column counting/changing is ridiculous.

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

Quote:

Originally Posted by RJ_

Something like this:

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

suntanlinus · 10-13-2016, 02:26 PM

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!

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.

10-13-2016, 02:29 PM	#40557
UncleWede Long Time Admirer, First Time Owner 18067 Rep 9,380 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	#40558
M3 Number 86 Major General 3221 Rep 6,218 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	#40559
bimmette YouTube.com/TvTara 6454 Rep 4,715 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	#40567
Mr Tonka is probably out riding. 6058 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

		BMW X5 and X6 Forum (F15/F16) > BIMMERPOST Universal Forums > Off-Topic Discussions Board
What's that? You wanna chit chat? Welcome to the whore thread!