Function returning value with assigned binary value

[tennentslager]

I'm looking for a function that would return a value which has a binary characteristic assigned to it. More specifically, a function that would only return the values with 1 assigned to them (i.e. male employees) into the male employee list but disregard any female (i.e. 0) employees

Employee	Male			Male employees
John	1			John
Jane	0			Martin
Martin	1			Fred
Marta	0			Jim
Fred	1			Jack
Francesca	0			Johnie
Jim	1
Jack	1
Johnie	1
Lara	0

<tbody>
</tbody>

thanks a lot in advance!

 

[AhoyNC]

Is this what you are trying to do?
Formula in E2 is an array formula that must be entered with CTRL-SHIFT-ENTER. Drag formula down as needed.

If you have Excel ver. 2010 or later you can use the formula in G2 which doesn't require CTRL-SHIFT-ENTER. Copy this formula down as needed.

Excel Workbook
	A	B	C	D	E	F	G
1	Employee	Male			Male employees	6	= # of Males
2	John	1			John		John
3	Jane	0			Martin		Martin
4	Martin	1			Fred		Fred
5	Marta	0			Jim		Jim
6	Fred	1			Jack		Jack
7	Francesca	0			Johnie		Johnie
8	Jim	1
9	Jack	1
10	Johnie	1
11	Lara	0
Sheet

 

[tennentslager]

Yeah that works perfectly, cheers

 

[AhoyNC]

You're welcome. Thanks for the feedback.