Index for changing values

[Ali3435]

Hi, I'm hoping to find a formula that returns every matching instance of my catalogue number from a set of data, but which also resets for every new catalogue number. The formula I'm using so far is:

{=INDEX(Table1,SMALL(IF(Table1[Catalogue_Number]=E12,ROW(Table1[Catalogue_Number])),ROW(1:1))-1,17)}

But the second ROW needs to reset to 1 for each new catalogue number. Part of the data is below, but continues for ~500 rows with ~200 different values. As you can see the first 2 results work, but then it tries to find the 3rd smallest value for the next catalogue number.

Catalogue
Number SNB
HD238 18385
HD238 23329
HD239 #NUM !
HD239 #NUM !
HD244 #NUM !
HD246 #NUM !
HD248 #NUM !
HD248 #NUM !
HD249 #NUM !
HD249 #NUM !
HD249 #NUM !
HD251 #NUM !
HD251 #NUM !
HD251 #NUM !
HD251 #NUM !
HD253 #NUM !
HD253 #NUM !
HD254 #NUM !
HD254 #NUM !
HD254 #NUM !
HD254 #NUM !

Any help would be much appreciated!

 

[Ali3435]

Fixed it, entered a new column with =COUNTIF(E$12:E12,E12) and changed the ROW(1:1) to the value of that cell