Hi,
At the moment, my account number only is able to show next to my total amount. However, I want the account number is able to show next to each invoice number. Is it any excel formula can help to do this ?
File is attached as reference.
Thanks in advance !
You should posted the desired result in your workbook.
Please post it in the question in which other forummembers asked for your workbook.
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 kusidin. highlight A1:A13. press CTRL + G -> Special -> Blanks. type in:
=IF(B2<>"",A3,"")
press CTRL + ENTER
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Thank you very much, Benishiryo !!! Very useful !!
Hi @kusidin,
If you are satisfied with the responses then please mark the thread as Solved.
Thanks.
abousetta
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks