Thanks Again
This formula ommits empty cells so my final report will skip empty cells and have cells that contain text or numbers stacked below each other.
Unfortunately when I enter the formula you gave me I get a notification that there is something wrong with the formula
Bookmarks