Scenario: I have one table with lots of records. In one row I have Initials, and in another row I have Department. The order is random.
Problem: In other places in the workbook I want to use individual ranges with all the initials in a given department, etc. using the index() excel function.
Trying to write the function in semi VBA and semi plain english:
public function range.if(rng as range, criRng as range, cri as string)
for each c in rng
if c in criRng = cri then include c in output
range.if = output