when filter function will be available?

[lezawang]

Hi
I just watched a video and ExcelIsFun author said Filter() not not available now. He manged to do a lot of stuff without using array function anymore. That is a big change.

My second question, is Microsoft going to get rid of array formula?

https://www.youtube.com/watch?v=cB6UlIwpwVc

 

[lezawang]

Another question, I did use exactly the same formula he used but did not work. When I typed the formula in the cell B2 and press enter. It only applied to the first cell (it did not copy over like what happen to him). Then I had to use autoFill to copy the formula over, but also did not work. Then I had to use absolute address like below

=MATCH($B$2:$B$5,$A$2:$A$12,0)

My question, how come for him he did not have to use absolute address? I am also using Office 365

list1	list2	new list
mike1	linda1	6
alex1	alex2	8
mary1	mary	#N/A
sarah1	alex1	2
john1
linda1
mike2
alex2
mary2
sarah2
john2

<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[Michael M]

Works fine for me......Place the formula in C2 and drag down

 

[Peter_SSs]

Another question, I did use exactly the same formula he used but did not work. When I typed the formula in the cell B2 and press enter. It only applied to the first cell (it did not copy over like what happen to him). Then I had to use autoFill to copy the formula over, but also did not work. Then I had to use absolute address like below

=MATCH($B$2:$B$5,$A$2:$A$12,0)

My question, how come for him he did not have to use absolute address? I am also using Office 365

See here for more info but an extract:

Note: Dynamic array functions are currently a beta feature, and only available to a portion of Office Insiders at this time. We'll continue to optimize these features over the next several months. When they're ready, we'll release them to all Office Insiders, and Office 365 subscribers.

 

[lezawang]

Thank you all. Now I did it in my way, using absolute reference and then autofill. I also created a new column using ISNA() function and I got False and True. Now I want to change the last column to name instead of False/True like what Gravin did in his video. Thank you very much

list1	list2	=MATCH($B$2:$B$5,$A$2:$A$12,0)	isna()
mike1	linda1	6	FALSE
alex1	alex2	8	FALSE
mary1	mary	#N/A	TRUE
sarah1	alex1	2	FALSE
john1
linda1
mike2
alex2
mary2
sarah2
john2

<tbody>
</tbody>

 

[Peter_SSs]

Is this what you are trying to achieve?

Excel Workbook
	A	B	C
1	list1	list2
2	mike1	linda1	alex1
3	alex1	alex2	linda1
4	mary1	mary	alex2
5	sarah1	alex1
6	john1
7	linda1
8	mike2
9	alex2
10	mary2
11	sarah2
12	john2
List