Working on a financial report.
Trying to grab all rows and transactions amounts except for one group.

MPAC contains a total of all transactions as well as each individual. Looks like this:

Bld $xxxxx
MPAC $xxxxxxx
MPAC: 1 $xx
MPAC: 2 $xx
etc.
Ele $xxxxx

I only want Bld and Ele, etc. I do not want any MPAC, I thought about trying Instr but I think I may be using it incorrectly.

There are thousands of #s for MPAC so doing a <> does not seem efficient.

Any suggestions?