View Single Post
  #20   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default When found add it to the last and display total in Msgbox

Hi again,

Am Mon, 15 Sep 2014 00:49:25 -0700 (PDT) schrieb L. Howard:

Am aware zero based and 1 based exist, but easily prone to miss use them.


did you try the array formula from my first answer?


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional