Reciprocal range?
Suppose I have two ranges:
AllChildren = $B$1:$B$6
AllSons = $B$2, $B$4
And suppose that the children who aren't sons are daughters. **Without
looping** is there a way to return the range...
$B$1, $B$3, $B$5:$B$6
....for the daughters?
Thanks.
Charley
|