Excel: Formula or Macro to Extract Account Numbers

I have account numbers in Col D in Sheet TB and decriptions in Col G I would like a formula or macro to extract the account numbers where the description New Car Sales appears in Col G on Sheet Extract Your assistance in this regard is most appreciated

This question generated 20 answers. To proceed to the answers, click here.

This thread is current as of March 11, 2014.

For more resources for Microsoft Excel