Recent content by richardsmith

thank you. incoming.... I have found out a few things, like I'm not the best excel user...

thanks, it works. however I am running a macro to insert a new line with my formulas on it, when I insert a new line with this formula it goes to the 0 value before a second job number has been inserted.... my worksheet is a bit busy, would it be easier to email it so you can see what I mean?

hi, this has been doing my head in for a couple of days now... hopefully a clever excel whizz will know the answer.... I have a column that a 'job number' is entered into, this is alphanumerical. where the 'job number' is unique I want a value to be associated with it. where the 'job...