I don't know what I'm doing wrong but this simple function isn't working.
I'm trying to do:
Please note everything in DefCol is a formula...Please Login or Register to view this content.
I don't know what I'm doing wrong but this simple function isn't working.
I'm trying to do:
Please note everything in DefCol is a formula...Please Login or Register to view this content.
Maybe
Please Login or Register to view this content.
I've looked at that method but it's really inefficient for me, basically if it finds a value returned from the formula in that range it needs to do something different to if it doesnt find anything...
What type of data is returned by the formula?
Numbers (0.304) for example.
Two methods that come to mind
Please Login or Register to view this content.
The first method uses an array formula within the code so with a large range could be slow to process.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks