Bart
Member
Registered: 19th Aug 02
Location: Midsomer Norton, Bristol Avon
User status: Offline
|
I have this Formula so far:
=LEFT(b1,1)&"1000"
(the above formula is in Cell H)
At the moment, if B1 starts with the letter W i get w1000 in H1
Is there a way to check Column H to see if w1000 exists and if so, increase the digit by 1?
|
AndyKent
Member
Registered: 3rd Sep 05
User status: Offline
|
=LEFT(A1,1)&VALUE(RIGHT(B1,4)+1)
is that what you mean?
|
Steve
Premium Member
Registered: 30th Mar 02
Location: Worcestershire Drives: Defender
User status: Offline
|
I believe you need
=LEFT(T1,T)&SMB(STFU(B4LLS)+1)
|
Bart
Member
Registered: 19th Aug 02
Location: Midsomer Norton, Bristol Avon
User status: Offline
|
oh? i thought it was
u=a(h0m0) = steve
Thanks for your contribution 
|
Ian
Site Administrator
Registered: 28th Aug 99
Location: Liverpool
User status: Offline
|
You want to check the entire column?
ie. H1,H2,H3....Hn ?
|
MikeLamb
Member
Registered: 23rd Sep 03
Location: Crowthorne Drives: Veccy SRI
User status: Offline
|
Increase what digit by1?
|
Bart
Member
Registered: 19th Aug 02
Location: Midsomer Norton, Bristol Avon
User status: Offline
|
i will try to explain again. but ive kinda gotten the formula now and it works REALLY well in excel... perfectly, does exactly what i want it to do. but for some reason sharepoint wont accept it.. syntax error.
Id like to be able to use Sharepoint to generate job numbers based on the
first letter of the customer name and then adding a predefined figure. (lets
say 1000).
At the moment, in excel, in column A i have customer and in column b i have
the following formula:
quote:
=IF(ISBLANK($A2),"",LEFT($A2,1)&COUNTIF($A$1:$A2,LEFT($A2,1) & "*")+999)
So if the customer begins with 'A' i get A1000
If it begins with B i get B1000
If i add another A i get A1001 and another B i get B1001 and so on.
So at the moment theres no chance of my duplicating the job numbers.
It works really well in excel, but it wont let me use this formula in
Sharepoint.
Im quite new to sharepoint.
Previously i had
quote:
=LEFT(Customer,1)&"1000"
Which worked in Sharepoint, it added the first letter to 1000, but was
obviously duplicating the job numbers.
I have tried importing the excel document into WSS but it doesnt appear to
copy the formula in 
Adam
|
