hello kind people
I changed column A to look like column C.
I did it manually
Problem is there are thousands of these.
Is there a function put into a helper column that can do the trick?
most appreciative of any insight!
sheet posted
[Solved] Need function to change X1 X1 X1 to X1 X2 X3
-
- Posts: 53
- Joined: Sat Mar 21, 2015 9:13 pm
[Solved] Need function to change X1 X1 X1 to X1 X2 X3
- Attachments
-
- formula for changing A into C thanks!.ods
- Changed title, was: Need a function
- (12.08 KiB) Downloaded 84 times
Last edited by AlexandraNyx on Thu Jan 23, 2020 11:23 pm, edited 1 time in total.
OPEN OFFICE 4.1.1 ON WINDOWS 7
Re: need a function
I am sorry, I do not understand what you want to do. You say you changed column A to look like column C but the two are not always equal. For example, they differ in row 5. Does it not work to put in A2 the formula
and then copy that down the whole column?
Code: Select all
=C2
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Re: need a function
Hello
D2:
E2:
Pull down
Works only if your codes have lenght 4 and only till 9 per block.
R
D2:
Code: Select all
=IF(ISBLANK(A1);1;D1+1)
Code: Select all
=IF(ISBLANK(A2);"";LEFT(A2;3)&D2)
Works only if your codes have lenght 4 and only till 9 per block.
R
- MMove 1.0.6
- Extension for easy, exact positioning of shapes, pictures, controls, frames ...
- my current system
- Windows 10 AOO, LOLinux Mint AOO, LO
-
- Posts: 53
- Joined: Sat Mar 21, 2015 9:13 pm
Re: need a function
To FJ
Thanks for the answer. 2pW represent a result. The 1 represents the number of times for this particular result. If the same result happens more than once I have to change the 1 to 2 or the number of times in a row it happened - thus, that's what C represents. Me changing A.
Thanks for the answer. 2pW represent a result. The 1 represents the number of times for this particular result. If the same result happens more than once I have to change the 1 to 2 or the number of times in a row it happened - thus, that's what C represents. Me changing A.
OPEN OFFICE 4.1.1 ON WINDOWS 7
-
- Posts: 53
- Joined: Sat Mar 21, 2015 9:13 pm
Re: need a function
To FK3
Love you brother. Works fantastic. I do have some that are over 9 but this is great. Super happy.
bless you my friend
alexandra
Love you brother. Works fantastic. I do have some that are over 9 but this is great. Super happy.
bless you my friend
alexandra
OPEN OFFICE 4.1.1 ON WINDOWS 7