There are two design errors here to overcome. A true database style
environment uses one row per data set, you've got two. You should
consider redesign into a standard format to alleviate this problem and
all future ones that stem from non-standard design.

Merged cells are for presentations. On the sheets you "work" with, you
should not employ Merged Cells since it breaks so many formulas and
closes doors to simple solutions.

If presentation is key in an excel sheet, use another sheet to gather
data together and format that sheet for presentation. Leave your raw
data in a simple, manageable layout.


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=48573