sorry you are not getting my point. If i put your formula then when d5 changes all E column will be change. I want a formula which shows every new indicator from d5 in column E. if the data changes 1000 times then E columns 1000 rows should be filled.