1. Select the cell where you want to display the filtered value.
2. In the formula bar, type =SUBTOTAL(3,Range) where Range is the range of cells that you filtered.
3. Press Enter to calculate the subtotal.
4. Now, use the OFFSET function to return the filtered value into a specific cell. In the formula bar, type =OFFSET(Cell,0,0) where Cell is the cell where you typed the SUBTOTAL function.
5. Press Enter to display the filtered value in the specific cell.

For example, let's say you filtered columns A, B, and C and you want to display the filtered value in cell E1. Here are the steps:

1. Select cell E1.
2. In the formula bar, type =SUBTOTAL(3,A:C) and press Enter.
3. In the formula bar, type =OFFSET(E1,0,0) and press Enter.

Now, cell E1 will display the filtered value. You can repeat these steps for the other two filtered values and display them in different cells.