Apologies, I have looked all over for this and cannot find. My range is B15:Z500. Filter column is K. In cell K9 I need a formula to always show the first value of the of the first VISIBLE cell in column K. Please advise me how to do this. Excel 2003 Thanks, Odie.