Index small if....

[vasim]

INDEX('Report'!$B$1:$B$25000,SMALL(IF(('Report'!$M$1:$M$25000="Health")*('Report'!$P$1:$P$25000="Open"),ROW('Report'!$B$1:$B$25000)),ROW()))


I want to add an or condition wherby, if in P col is Accept as well - taken in account. any help please.


something like....


INDEX('Report'!$B$1:$B$25000,SMALL(IF(('Report'!$M$1:$M$25000="Health")*('Report'!$P$1:$P$25000="Open")+'Report'!$P$1:$P$25000="Accept"),ROW('Report'!$B$1:$B$25000)),ROW()))

 

[Faseeh]

Hi Indian,


You have already added a condition in IF() so you can follow the similar logic, try this:


INDEX('Report'!$B$1:$B$25000,SMALL(IF(('Report'!$M$1:$M$25000="Health")*('Report'!$P$1:$P$25000="Open")*('Report'!$P$1:$P$25000="Accept")),ROW('Report'!$B$1:$B$25000)),ROW()))


Kindly adjust the braces as needed.


Thanks,

 

[vasim]

Thanks Faseeh,


I changed up my mind...prepared a Pivot, used offset to define range, and used the named range as formula, to populate table...


Thanks

 

[Faseeh]

Good to know that you solved it!


Faseeh