If this is your first visit, then welcome! Be sure to
check out the FAQ by clicking the
link above.Register here
so that you can post in the forums or comment on the articles.
Not sure exactly what you are trying to achieve (do not get the co-mingling of Revenue and costs?) however based on what I think you think you want have...
Just caught your post, Not real clear yet on what you exactly want, have a look and let me know where you need it tweaked/overhauled....
Using a UDF
Function TAFraction(data As Range)
Dim arr, a
Dim x As Long, y As Long
arr = data.Value2
Thanks so much. I have not found the solution yet.
Here is the file attached called "Sample File". The first view...
I think that you getting confused what the calculations you are doing actually mean. I always think its best to look at a simple example, make sure you...