Sum & difference between multiple values in single cell
Hello again,
I have 4 coloumns: IN , OUT, IN-OUT &IN+OUT. In each coloumn there are multiple values. For example, IN has 23:44;33 as values. OUT has 22;21;13 as values.
Now, what I would like to do is A SUM between these values but also A DIFFERENCE between them. Can you help me?
Thank you so much!
Last edited by iuliandonici; 04-14-2011 at 12:19 AM. Reason: The problem has been solved
Are the entries always made of 3 numbers of 2 digits each?
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Re: Sum & difference between multiple values in single cell
Please excuse me, didn't think to mention this. No. Sometimes, in a single cell can be up to 50 numbers and each one of them can have up to 7 digits.Originally Posted by NBVC
This will require a User Defined Function (UDF)
Add this UDF to your VB editor (Alt+F11, Insert|Module) and paste:
Then in E7 enter formula:
Please Login or Register to view this content.
Then confirm the formula with CTRL+SHIFT+ENTER not just ENTERPlease Login or Register to view this content.
in F7:
Then confirm the formula with CTRL+SHIFT+ENTER not just ENTERPlease Login or Register to view this content.
both formulas can be copied down if necessary.
Last edited by NBVC; 04-13-2011 at 10:30 AM.
@NBVC: IT WORKS! Thank you so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks