Hello,

I have a worksheet with 10 rows table X 3 columns.
Column A: Worker name
Column B: Worker salary
Column C: active/not active (1,0)

I want to define 2 ranges:
First range: all workers name from Column A (just the cells with value)
that are active.
I mean: row A value is not Null and row C value is 1.
Second range: Worker's salary for the workers in the First range.

For example:

A B C
Row1: Gil 120 1
Row2:Dan 100 0
Row3:Joe 50 1

First range will be: A1,C3
Second range will be: 120'50

How can I do this ?

Thank you for your help.
Gil D.