On Jun 19, 6:05 pm, " wrote:
I would much rather use a simplier solution that doesn't use multiple
cells on the spreadsheet to calculate the information I need to
breakdown the List. Has anybody seen a simple solution to this other
than using macros. I don't care if I have to pay for it, I just want
to know if a solution exists.

Thanks,
-Jeff

There are 4 choices as far as I can see.

1) Use multiple formulas. One formula cannot exist in multiple cells,
or create formulas in other cells.
2) Use macros. Lots of different ways.
3) Use a Filter. (which is easier to repeat when inside a macro)
4) Sort/copy/paste.

Also, DGET would likely be simpler than your array formula above.
Although it needs a criteria area to be set up, just like a Filter
does.