R Rachel7 Feb 12, 2009 #1 I need to extend the formula to exclude multiple values, empty cells & zero values in the range. Can anyone help?
I need to extend the formula to exclude multiple values, empty cells & zero values in the range. Can anyone help?
R Rachel7 Feb 12, 2009 #3 Hi Pete, It's 'SMALL', Bernard (on the other post, I didn't mean to post it so many times) has given me a vba code, but I'll need to read up on vba before I can use it. Maybe I need to resolve the answer using multiple stages of formulae???
Hi Pete, It's 'SMALL', Bernard (on the other post, I didn't mean to post it so many times) has given me a vba code, but I'll need to read up on vba before I can use it. Maybe I need to resolve the answer using multiple stages of formulae???
