christianbiker
Active Member
- Joined
- Feb 3, 2006
- Messages
- 365
Greetings all,
The following formula works great using one column, however is it possible to use it with multiple columns. Here is my current formula:
=IF(COUNTIF(DATABASE!$J$1:$J$500,"Active")>=ROWS($1:1),INDEX(DATABASE!$A$1:$A$500,SMALL(IF(DATABASE!$J$1:$J$500="Active",ROW($1:$500)),ROW(1:1))),"")
Here is what I tried, but couldn't get to work:
=IF(COUNTIF(and(DATABASE!$J$1:$J$500,"Active",DATABASE!$K$1:$K$500,"Yes")>=ROWS($1:1),INDEX(DATABASE!$A$1:$A$500,SMALL(IF(and(DATABASE!$J$1:$J$500="Active",DATABASE!$K$1:$K$500,"Yes"),ROW($1:$500)),ROW(1:1))),"")
I thought this would work more like a sumproduct formula however I am using text, not numbers.
Any assistance would be appreciated...
Chad
The following formula works great using one column, however is it possible to use it with multiple columns. Here is my current formula:
=IF(COUNTIF(DATABASE!$J$1:$J$500,"Active")>=ROWS($1:1),INDEX(DATABASE!$A$1:$A$500,SMALL(IF(DATABASE!$J$1:$J$500="Active",ROW($1:$500)),ROW(1:1))),"")
Here is what I tried, but couldn't get to work:
=IF(COUNTIF(and(DATABASE!$J$1:$J$500,"Active",DATABASE!$K$1:$K$500,"Yes")>=ROWS($1:1),INDEX(DATABASE!$A$1:$A$500,SMALL(IF(and(DATABASE!$J$1:$J$500="Active",DATABASE!$K$1:$K$500,"Yes"),ROW($1:$500)),ROW(1:1))),"")
I thought this would work more like a sumproduct formula however I am using text, not numbers.
Any assistance would be appreciated...
Chad