Automatically update only with numbers(ifnumber-update and go to next cell)

Hello everyone,
I'm back with a problem I can't solve:
Let's say that in column A I have numbers,"Yes" and "No". I want in column B to have only the numbers from column A, in the same order without any empty ranges, and everytime I add in column A a new number, column B to update automatically with that number. Let's have an example:
A B
Yes 12
12 13
No 10
13
No
10
Yes

And if I want to add in column A:
A B
Yes 12
12 13
No 10
13 25
No 15
10
Yes
25
15
So the column be will update automatically. I already tried =IFERROR(INDEX($A$1:$A$10,SMALL(IF(ISNUMBER($A$1:$A$10),ROW($A$1:$A$10)),ROWS(B$1:B1))-ROW($A$1)+1),") but using this many times get's my file very heavy and the excel is working slow.
A solution without using macros would be great!

Thank you!

Thank you XOR LX but this is the problem...I'll have hundreds of rows and a lot o columns also
Any other ideea?

Thanks again XOR LX!

So, someone who knows VBA??

Bump no response

If your numbers are literal values not formulas you may use this:

Please Login or Register  to view this content.

Thank you again!
Attached is an example.
We can also use auxiliary columns if needed.

unfortunately the are numbers obtained with formulas.

With formulas you must use the Calculate event (or check the formula input cells):

Please Login or Register  to view this content.

Hey guys!
I think the advanced filter might work for filtering just the numbers but will it work for filtering the dynamic array?
Thanks!