[Aatish]

E46 factory color options were legendary

[UncleWede]

Originally Posted by Biorin

Can we get some more information? Are you saying, for example, Column A has unique identifiers 1-10, and you want to create one sheet with identifier 1, one sheet with identifier 2, etc?

Both sheets have something akin to SSN. I need to group by that, to match up the person's name (sheet A) with their address (sheet B), based on SSN.

[///M Power-Belgium]

Originally Posted by duck fat

I need to take my pants off first so I don't make the same mistake twice.

Oh my god: http://www.goo-net-exchange.com/used...001/index.html

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

[RJ_]

Originally Posted by UncleWede

Both sheets have something akin to SSN. I need to group by that, to match up the person's name (sheet A) with their address (sheet B), based on SSN.

This is basically a vlookup based on the unique ID, is it not?

[shoei]

Originally Posted by anglo

It's hard to capture but looks really good in person.

Le Mans is nice, but this is easily my favorite blue... This and Tanzanite...

[UncleWede]

Originally Posted by RJ_

This is basically a vlookup based on the unique ID, is it not?

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?

[Banana Hammock]

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.

[UncleWede]

Originally Posted by duck fat

By the time the 34s are old enough to fall under this exemption.

No more falling off, currently. That's why my son's 77 beetle has to keep FI engine and be smogged STILL.

[suntanlinus]

Tanzanite blue wins right behind space grey

[Aatish]

Originally Posted by duck fat

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

[Biorin]

Originally Posted by RJ_

This is basically a vlookup based on the unique ID, is it not?

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?

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.

[Banana Hammock]

Originally Posted by UncleWede

No more falling off, currently. That's why my son's 77 beetle has to keep FI engine and be smogged STILL.

Sorry I was in a rush when I wrote that. The 25 year states that the car can be imported but the car still has to be registered. In order to register the car, it still has to pass smog.

[///M Power-Belgium]

Originally Posted by Dang3r

Those yellow colors make me puke
Yas Marina is a nice color but nothing comes above Blue Estoril II

Most people get tired quickly from any kind of yellow ...

But I need to say my friend his yellow Gallardo is a eyecatcher , but he says he regrets yellow ...
He has a quality body shop for German performance cars and 2 weeks ago he said to me...Maybe I will paint the Gallardo in Miami Blue from the Turbo-S..
What do you think Philippe ?
I said to him ...It's your car and so your dicision , because I really don't know and it's really personal .Actually every color!

[Biorin]

Originally Posted by RJ_

That does sound generous. No way my hourly teaching rate matches yours. If I ever find myself broken down in your neck of the woods I'll keep that in mind.

I think you should go with steelies, baller on a budget style. It's sad that you're going to miss out on driving season.

I can teach you violin, taxes, and driving like a lunatic (my coworker said coffee runs with me are like being in Formula 1). Those things don't come cheap.

Anything with hubcaps will do.

[Banana Hammock]

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]

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]

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_]

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]

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

...and Crimson Red

[Biorin]

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]

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]

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!