You must press the control, shift, and enter keys at the same time.

Also, lookup "array formulas" in Excel's Help for an intro.


mcarrington wrote:
Thanks Aladin, the formulas seem to be on the right track. However, I
am having a couple of issues. The only date that is pulled up is the
first one on the list. The formula seems ot be just taking the min
date on the list, instead of the first date of buy or sell. Also, does
confirming by using control+shift+enter do? To my knowledge I've never
used that command and it doesn't appear to do anything when I tried it.
Thanks again for you response.

Megan