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

    • For these last 7 years of ownership, I've always had to use a small scissor jack under one of the front tow hooks to raise the front just enough so my low-profile jack fits under to reach my subframe jack point. I'm beginning to get annoyed of always having to do this. Are there any lower low-profile jacks that fit under the gtr lip on a dropped car?
    • Seat of the pants assessment of the new intake: The car is way less "doughy" when hitting the loud pedal, especially off idle when stopped or in traffic, I did use a cheapo lazer thermal thingo to measure the temp around where the pod filter got its air, it was between 55 - 60°C, in saying this the car was shut off and not moving, so the OEM intake pipe was not supplying any fresh air to where the pod was when the car was at least moving A weird bonus was induction noise on the throttle in the cabin increased a bit,  I was worried that I was actually going to lose some of that induction noise I love so much, outside though, when I got the daughter to do a WOT drive by pass for me, the induction noise has increased alot when on the throttle, not quite ITB doort, but well up there I'm extremely happy with the results and have been exploring the country roads in the region  As for house mods: 1.New front fence is up and is awesome, it really upgraded how the joint looks from the street, and the added security is nice 2. Electricians have replace some interior lights, and with more lighting in the garage, a few new motion detecting lights out the front above the garage, front room, and at the front door, which I have already found heaps helpful coming and going, also now has fancy pants CCTV all round the house The only hold point for power though is the solar and batteries due to supply issues, although this will happen over the next few weeks 3. I have done a heap of landscaping out the front and I'm almost ready to do a new small retaining wall with some nice blocks to replace the brick and cemented in rocks around the raised garden beds cemented in river stone "was the fashion at the time" the house was built. I currently have a pallet of retaining wall blocks and 2 bulka bags of 20mm blue metal to replace the wood chip that is in the raised garden beds around the house 4. I now have 3 big raised garden beds for out the back to grow some vegetables, about 70cm high, 200cm long and 100cm wide 5. My 2 compost bins are already pretty full with brown, green and kitchen waste from the landscaping I'vedone so far, but they will probably take a few months to break down, so anything else that gets chopped, trimmed, and kitchen waste will just start filling the base of the raised garden beds to about 30cm before I start throwing 40cm of good compost, and stuff, for the vegetables to grow in, I'll need a few ton of compost and soil, but the local supplier can sent me bulka bags of the stuff Basically the logs, wood chips and a few strategically placed rocks for drainage, will give the beds some good organic materials down low to break down over time, and they will hold moisture during the warmer months to save the water in my big arse water tank if we don't get alot of rain So, all in all, the car and house mods are going well, and I'm really enjoying being retired, I sleep in too 0700 and slowly plod around inside until I feel like actually doing anything, and only work in the yard for as long as want, which has actually been alot over the last few weeks,  although when you look at it, it seems that not a huge amount of work has been done,  until I look at the before I started the work pics Happy days and good times indeed 
    • hahaha yeah. Plan is to get side skirts and probably just rear pods. But going to do them one-by-one. I've got a set that I really like from RHDJapen, but that one isn't shipped to AU. So need to find someone who can get it for me
    • Here's an idea, answer the questions I asked you as they are trying to work out WHY the LSD will be binding up in a straight line.
×
×
  • Create New...