View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jerry W. Lewis
 
Posts: n/a
Default Zero replaces blank field when paste special is used

You're welcome; glad it helped.

Jerry

Baseball Greg wrote:

Jerry:

Excellent! Typing the new formula into the "helper spreadsheet" cells
brought my mode numbers forward to my "Summary" sheet perfectly! Thanks for
sticking with my problem and the great assistance you provided. Happy
holidays.

Greg