srikandi2000
Member
SOLVED (I think..)
I got it to work by using * and put the condition in bracket. I guess the missing piece was the bracket.
Dear all,
I have a problem which is similar to http://chandoo.org/forums/topic/lookup-top-10-values-in-a-table-with-conditions. My question is how do you do it for more than 1 condition?
What i am looking for is similar to Narayank91 solution on that post however I cant seem to modified it using AND or *. I guess I'm still haven't grasp the basic of array formula.
My data looks like this
School_Name No.Teacher Status1 Status2
School_1 9 Border Private
School_2 10 Urban Public
School_3 5 Rural Public
I need to look up the school name base status1 and status2.
Thanks in advance.
I got it to work by using * and put the condition in bracket. I guess the missing piece was the bracket.
Dear all,
I have a problem which is similar to http://chandoo.org/forums/topic/lookup-top-10-values-in-a-table-with-conditions. My question is how do you do it for more than 1 condition?
What i am looking for is similar to Narayank91 solution on that post however I cant seem to modified it using AND or *. I guess I'm still haven't grasp the basic of array formula.
My data looks like this
School_Name No.Teacher Status1 Status2
School_1 9 Border Private
School_2 10 Urban Public
School_3 5 Rural Public
I need to look up the school name base status1 and status2.
Thanks in advance.