Removing File.
Removing File.
Last edited by ohanish; 03-27-2015 at 04:42 PM.
I see that you are using full column references. This might be convenient but it is something that can eat up the computing resources.
I would change some of the references in your formula to mixed relative and absolute so that you can copy down and across. This formula has also limited the ranges instead of having whole column ranges.
Formula:Please Login or Register to view this content.
The formula in your table comes down to this (not using the intermediate formula).
Formula:Please Login or Register to view this content.
I'm not familiar enough with your workbook to see how you would use this and unfortunately, I don't have the time to figure out how you can make use of this table.
Last edited by newdoverman; 03-26-2015 at 04:36 PM.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Thanks. I see that I over thought this entire thing now.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks