Hello all, I hope you can help me. I am a bit of a novice when it comes to complex formulas. I am trying to write the formula (see image) to achieve the text below it but its just not accepting my arguments.
Can anybody assist?
formula_img.png
Hello all, I hope you can help me. I am a bit of a novice when it comes to complex formulas. I am trying to write the formula (see image) to achieve the text below it but its just not accepting my arguments.
Can anybody assist?
formula_img.png
You get better result on your question if you add a small excel file, without confidential information.
Please also add the expected results manualy in your file.
P.s. we need new glasses to read your attachement.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Hi, thanks for your reply. I cant upload any files on here, only images?
Maybe this will help? Slightly zoomed 17-06-2017 15-46-20.png
To Attach a File:
1. Scroll down to the window below your post Additional Options
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.
Yes we can see it, but
add in your file manualy the result.
Show us the related cells so we can see what is going on.
but where do we find the data in your file, to get the result/I did add manually the result? The related cells are A2 and B2. Attached again.
Which cells are related?
Cells A2 & B2 are the only cells required in the formula.
So all you want is to concatenate A2 & B2?
Formula:Please Login or Register to view this content.
v A B C 1 Account Date 2 name 7/10/2017 name20170710
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
No, there is other text which needs to be concatenated into the formula. The text will always stay the same, its the contents of cells A2 & B2 which will change.
form.png
can't respond on this one.
I can't add the formula in this item. Internet does not allow me.
See the attached file.
Last edited by oeldere; 06-17-2017 at 02:02 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks