excel autofill not working with formula

Try removing all filters and dragging again. Here is the easiest shortcut solution to solve this problem. Compa…