richardsmith
New Member
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 number' is not unique, I need the first entry to have a value associated but not the additional ones.
I can only get it to show zero value if the 'job number' appears more than once, which I dont want.
ie:
job value
12345 512 <-keep this value, even if the same'job number' is entered again
12345 0
12346 303
I have date field too, if this helps anyones formaula...
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 number' is not unique, I need the first entry to have a value associated but not the additional ones.
I can only get it to show zero value if the 'job number' appears more than once, which I dont want.
ie:
job value
12345 512 <-keep this value, even if the same'job number' is entered again
12345 0
12346 303
I have date field too, if this helps anyones formaula...