Separate the boys from the girls?
Your Solution is exactly what I was looking for and it works great. The
Control+Shift+Enter instruction was something new to me. I was not sure how
to make it work as I did not want to type the formula, but paste if directly
from your post instead. I was not successful to just paste and then use
Control+Shift+Enter but I found if I paste the function into the cell, then
delete any part of the formula and then retype it as though I had typed the
entire thing I then could use Control+Shift+Enter to activate it in the cell.
(There is no doubt an easier way)
I knew it was right when I got the curly brackets around it. I also
discovered it is not too smart to try to put the formula where it interfered
with the area list in this case A1:A20.
After I worked out those small details I had great success. I appreciate
the time you took to help me out with it. This will help me get started
learning about Array Formulas.
Quin
|