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 message. It seems like im doing something wrong in the "include" part. Can someone please help me with this 🙂 ( i have marked the contens of cell B and J so you cant see them since its sensitive information)
This is the formula im using= =FILTER(A7:J33,A7:A33=K6,"")
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 🙂
