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