Retrieve data and create a list based on multiple criterias

[Jarke]

Hi all,

I'm trying to create a formula in which I can pull names from my big data table. One formula and I can drag it down and it fills up with all approved names (based on the criterias).

I have names in column A, values in column B and other values in column C.

I want to retrieve all names which has a value bigger than zero in column B and who also have a value bigger than 10 in column C.

How should I go about it? No expert at Index or Match yet, and have given to much energy on trying to figuring it out by myself now


Thanks alot in advance!

 

[MARZIOTULLIO]

[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD]

A​

[/TD]
[TD]

B​

[/TD]
[TD]

C​

[/TD]
[TD]

D​

[/TD]
[TD]

E​

[/TD]
[/TR]
[TR]
[TD]

1​

[/TD]
[TD]name[/TD]
[TD]value[/TD]
[TD]value[/TD]
[TD][/TD]
[TD]name[/TD]
[/TR]
[TR]
[TD]

2​

[/TD]
[TD]a[/TD]
[TD]

5​

[/TD]
[TD]

15​

[/TD]
[TD][/TD]
[TD]a[/TD]
[/TR]
[TR]
[TD]

3​

[/TD]
[TD]b[/TD]
[TD]

3​

[/TD]
[TD]

22​

[/TD]
[TD][/TD]
[TD]b[/TD]
[/TR]
[TR]
[TD]

4​

[/TD]
[TD]c[/TD]
[TD]

0​

[/TD]
[TD]

11​

[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

5​

[/TD]
[TD]d[/TD]
[TD]

4​

[/TD]
[TD]

9​

[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


e2=IFERROR(INDEX($A$2:$A$5,SMALL(IF($B$2:$B$5>0,IF($C$2:$C$5>10,ROW($A$2:$A$5)-ROW($A$2)+1)),ROWS($A$2:A2))),"")

control+shift+enter copy down

 

[Jarke]

Thank you alot mate! Works like a charm.

Keep up the great work

 

[MARZIOTULLIO]

you are welcome