auto entry data to another field

[phuongnguyen11]

Hi everyone

I want to if I entry data range A2:D6, then range F2:G3 autofill. How to can do that.

Many thanks your help.

[#2 · Accepted solution]

@phuongnguyen11 

=FILTER(A2:B6;B2:B6<>"")

Maybe with the FILTER function. 

[#3]

ok. Thanks you