The above formula needs to only work with non zero or blank cells.![]()
Please Login or Register to view this content.
How can it be modified to do that ?
I tried :but did not work.![]()
Please Login or Register to view this content.
The above formula needs to only work with non zero or blank cells.![]()
Please Login or Register to view this content.
How can it be modified to do that ?
I tried :but did not work.![]()
Please Login or Register to view this content.
Last edited by coreytroy; 12-02-2012 at 09:43 PM.
array formula - ctrl+shift+enter not just enter
Formula:
Please Login or Register to view this content.
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Thanks vlady, perfect.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks