Originally Posted by xld
Regards,
--------------------------------------------------------------------------------------------------------
Shrivallabha
--------------------------------------------------------------------------------------------------------
Using Excel 2016 in Home / 2010 in Office
--------------------------------------------------------------------------------------------------------
Great articles about basic Sumproduct....Thanks but 1 question about this, the code- =A2:A20="test" in B2 will give true/false or #Value error ?
That formula isn't anything to do with SUMPRODUCT, if it isn't to do with it i'll move it to the general Excel forum.
Regards,
Simon
Please read this before cross posting!
In the unlikely event you didn't get your answer here try Microsoft Office Discussion @ The Code Cage
If I have seen further it is by standing on the shoulders of giants.
Isaac Newton, Letter to Robert Hooke, February 5, 1675 English mathematician & physicist (1642 - 1727)
Posting Permissions
Reply With Quote
