The function already skips the single blank cell between the sets of 5, but
as coded it needs a group of 5, a blank, another group of 5, another blank,
etc.


If there occasional groups of four or three, then you would need a macro to
automatically synch up on the blanks.
--
Gary's Student


"EMCUE" wrote:


how would i skip blank cells so that they aren't transposed


--
EMCUE
------------------------------------------------------------------------
EMCUE's Profile: http://www.excelforum.com/member.php...o&userid=32945
View this thread: http://www.excelforum.com/showthread...hreadid=531115