|
Not logged in [Login - Register] |
You Are Not Registered Or Not Logged In |
Corsa Sport » Message Board » Off Day » Geek Day » Excel Formula Help.. » Post Reply
|
Bart |
posted on 7th Dec 06 at 07:59 |
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. quote: 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: 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 | |
MikeLamb |
posted on 6th Dec 06 at 20:32 |
Increase what digit by1? | |
Ian |
posted on 6th Dec 06 at 19:14 |
You want to check the entire column? | |
Bart |
posted on 6th Dec 06 at 11:39 |
oh? i thought it was | |
Steve |
posted on 6th Dec 06 at 11:37 |
I believe you need | |
AndyKent |
posted on 6th Dec 06 at 11:05 |
=LEFT(A1,1)&VALUE(RIGHT(B1,4)+1) | |
Bart |
posted on 6th Dec 06 at 10:37 |
I have this Formula so far: |