07-16-2015, 06:29 AM
Thanks Gintaras, I have implemented your suggestion and it works fine.
However, isn't that a waste of computer processing and resources?
I mean, if we were able to choose just exactly the non-empty cells into array then we would not be processing to check 'if non-empty'...
1) Maybe you could include a '<used>' flag in cellsToArray for a particular column/row.
2) Also if you could include a 'compareArray' or 'ifInArray' function as well in QM that acts as an abstraction and therefore expedites development time; as businesses often needs to compare data a lot.
Thanks Again.
Philip
However, isn't that a waste of computer processing and resources?
I mean, if we were able to choose just exactly the non-empty cells into array then we would not be processing to check 'if non-empty'...
1) Maybe you could include a '<used>' flag in cellsToArray for a particular column/row.
2) Also if you could include a 'compareArray' or 'ifInArray' function as well in QM that acts as an abstraction and therefore expedites development time; as businesses often needs to compare data a lot.
Thanks Again.
Philip
Best Regards,
Philip
Philip