View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Charley Kyd[_2_] Charley Kyd[_2_] is offline
external usenet poster
 
Posts: 30
Default 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