Good afternoon bgrish3

John Walkenbach has a rather clever solution here : http://spreadsheetpage.com/index.php...s_not_deleted/

He also gives a rather nice commentary as to how it works.

HTH

DominicB