SHOWING DATA WITH CRITERIA "active"

[muhammad susanto]

hi all,

i have set data this below :

item1	out		item3 (desired result)
item3	active		item2 (desired result)
item8	idle
item2	active
item4	off
etc...	idle

<tbody>
</tbody>

only criteria "active", data shown....(item3) and stairs up (item2)

it's possible??

thanks very much...

m.susanto

 

[Weazel]

maybe something like....

Excel 2012

	A	B	C	D
3	item1	out		item3
4	item3	active		item2
5	item8	idle
6	item2	active
7	item4	off
8	etc...	idle

<tbody>
</tbody>

Sheet2​

Array Formulas Cell Formula D3 {=IF(ROWS($D$3:D3)>COUNTIF($B$3:$B$8,"active"),"",INDEX($A$3:$A$8,SMALL(IF($B$3:$B$8="active",ROW($A$3:$A$8)-ROW($A$3)+1),ROWS($D$3:D3))))} <tbody> </tbody> Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}. Note: Do not try and enter the {} manually yourself

<tbody>
</tbody>

 

[Aladin Akyurek]

D2, control+shift+enter, not just enter, and copy down:

=IFERROR(INDEX($A$2:$A$10,SMALL(IF($B$2:$B$10="active",
    ROW($A$2:$A$10)-ROW($A$2)+1),ROWS($D$2:D2))),"")

 

[muhammad susanto]

Weazel and Aladin, you are GREAT....

It's really awesome answer............

thanks you very much..[SOLVED]