View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Raj Raj is offline
external usenet poster
 
Posts: 130
Default Macro summarizing count below an array of data

Hi there

Just wondering... is there a macro or any other way to count the number of
rows in an one-column-wide array after adding in a blank row after each set
of similar values in the array. If there are limitations in the macro, I can
pre-sort the array to have the similar rows together and also have blank rows
inserted after every group of similar cells. Also, the whole on-column-wide
array may have multiple groups of similar cells.

Thanks very much.

Raj