Jump to content
SAU Community

Recommended Posts

  • Replies 62.7k
  • Created
  • Last Reply

Top Posters In This Topic

  • chaos

    7164

  • Ska

    5791

  • BelGarion

    3645

  • Nexus9

    3590

Top Posters In This Topic

cya guys lata im going to get sum new tyres! 235/45/17 for the front. and the backs are ok. surprise!!!!

I'm getting new 235/45/17 sat $165 for Falken's ZE-326 :D But that is with the club discount through Bob Jane T-Marts.

I dont have speakers at work so it wouldn't be as effective.

Now this stupid excel formula wont work :D

What does the $ sign in an excel formula mean again.

ahhhhhh funny, soooo funny, must watch again!! :D

The dollar sign before a part of the cell reference makes that part of the reference static, ie if you move/change the cell containing the formula, that part of the formula isn't modified. If you have $A5, then copy it one cell down and right, the ref will change to $A6 - there is no $ sign in front of the row number, so it's allowed to change. Doing the same thing with A$5 will allow the A to change, so it'll change to B$5. I'm not the best at explaining things, but if you want to email the document to me I'm happy to look at it :D

VLOOKUP is used to look up a value in the leftmost column of a table, then returns a value from the same row.

So, your formula is looking for a value (whatever is in B63 of the current sheet, eg 'fred') in the leftmost column of the area between A4 and S93 on the sheet named 'main sheet' in the file '26_261204.xls'. When it finds 'fred' in this column, it returns the value in column 19 (ie column S) of that row. The 'FALSE' at the end specifies that it must be an EXACT match, rather than an approximate one.

OMG your so smart.

Sorry I had to ask my boss. I didnt want to have to but I did. The formula was right and it was looking up what it needed to in the right sections.. but while I was on leave last week one of the ladies that was doing my work changed the name of one of the guys in one of the databases so what I was telling it to look up, it couldn't find cause it was spelt different in the two databases.

It was only one entry that was stuffing up, all the rest were fine!

Thanks heaps marc. I actually understand the formula now. My boss just showed me and said "heres how you copy it across" Didn't actually tell me what it does and what it's doing.

Guest
This topic is now closed to further replies.



  • Similar Content

  • Latest Posts

    • The real question is, on some of those wild roads they call highways, how many times did a farmer in an old ute from the early 2000s blaze past you over double lines?   Tassie is a wild and really cool place, and after doing a work related road trip there January of 24, I understand why Targa Tasmania is ran there, and is so tough to do well at! We had a brand new Camry Hybrid that handled quite nicely, and thankfully weren't in an old car, because cresting some of those hills in a 100kmh zone for it to suddenly be like "surprise f**kers, this is a recommended 30kmh hard right turn" wouldn't be pretty. We weren't racing the Camry around, but we weren't slouching in the bends either. But my lord those old farmers know their old clapped out utes, and those roads, as they were absolutely hammering it!   You're also super lucky to make it up to Mt Wellingtong this time of year. It's often road closed with snow/ice! Also, I hope you hit up Salamander Road in Hobart for some insanely good food (I highly recommend the dimly lit Irish pub for a Guiness Pie, or even the bangers and mash!!!)   How long did the Ferry take to get across? I want to do a road trip of Tas on my own time, but I get horrifically sea sick, and I don't want me on the Ferry, just the car 😛
    • So far so good, about 30km on it so far and nothing out of sorts yet thankfully
    • Look at @Kinkstaah's thread on the issue.
    • Hmm not really, I'd say its race car life or modified car life when you make 3 or 4 times the power Nissan designed the car for lol. 
    • I'll let others with more breakage chime in, but I can't think of anyone who had a problem with the standard centre plate before they had a problem with the standard gears - the plate generally just gets replaced for safety when the gearset is upgraded. As for the gearsets, its not like they are OK at 600Nm and break at 601. Their longevity is a combination of how much torque you are making and how gentle you are on shifts (or not). 
×
×
  • Create New...