Creating a sub-list, based on certain criteria that automatically updates with no spaces

Hi everyone,

I am trying to see if there is a way to create a sub-list from a set of data. For example if I have different numbers in cells A1:A10 with certain labels in cells B1:B10 such as "BB", "AB", "FAST", etc. and I want to create a sub-list from that data that only contains the numbers that are labeled "BB" with the ability for the list and sub-list to update daily.

I want the sub-list to be in D1 and to fill the column with no spaces in between numbers for all numbers in the orignally list that are labeled "BB".

Ex.

A1: 12 B1: BB
A2: 10 B2: AB
A3: 45 B3: BB
A4: 60 B4: FAST
A5: 70 B5: AB
A6: 72 B6: AB
A7: 23 B7: BB

I want column D to fill as follows with no gaps between numbers:

D1: 12
D2: 45
D3: 23

Any ideas?????

Wow, that worked, you're a genious. Thanks a lot for the help.

So yesterday this worked great, but for some reason today when I try it again and hit control + shift + enter it keeps the same reference for each cell for the last part of the finction: ROWS(D$1:D1). Yesterday it updated as it should putting this in the second cell:ROWS(D$1:D2). Any idea why it won't update?

Ok, nevermind, I confused myself. Today I was selecting all cells at once (d1:d7) and then entering in the formula and hitting control + shift + enter, where yesterday I just entered it into the first cell and then dragged and dropped.