Forum Discussion
Solved
Cant use FILTER function
Hi, i want to make an table like the video below but the FILTER function doesnt seem to work in my excel sheet. Im able to choose the "array", but when i want to select the "include" i get an error m...
You're probably using comma as decimal separator, so you should use semicolons ; between the arguments of the function:
=FILTER(A6:J33; A6:A33=K10; "")
You're probably using comma as decimal separator, so you should use semicolons ; between the arguments of the function:
=FILTER(A6:J33; A6:A33=K10; "")
Thank you so much Hans! Im still pretty new at Excel so learning every day 🙂