I have an excel sheet with lots of data and I have autofilter enabled. When I add this formula to my sheet, and I click on the autofilter arrow to filter the data and when it changes to that specific data my formula is gone. It only stays when I am not filtering the data. Is there any way that I can make my formula stay on the sheet regardless if I filter the data or not. Thanks for all your help. I hope I explained this clearly.