Thanks for the replies and appreciate the efforts. The CELL function appears to work for only a single cell, not a range or array like I need. I'll go the VBA route for a solution.