Function To Build A List For A Drop Down, Excluding Blanks And Non-Matches.

[GEANZ]

Hi All,

First time posting so hope I've done this correctly and you can help!

Please see attached excel file showing what I'm trying to achieve and the result I'm getting.

Essentially I need to build a number of lists from one master list. The master list can not be changed or modified in anyway. This one master list contains numerous blanks and numerous products. I need one drop down list per product type, ie in the example "Agi-Pumps" list and the "Agi-Pump Drives" List.

You will see I have created a function that almost does what I need, just require some assistance to finish!

Many Thanks

-Ollie

[rylo]

Hi

Try this
G2: =IFERROR(INDEX(C:C,SMALL(IF(LEFT($C$14:$C$58,11)="Agi-Pump - ",ROW($C$14:$C$58),""),ROW(A1))),"")
H2: =IFERROR(INDEX(C:C,SMALL(IF(LEFT($C$14:$C$58,15)="Agi-Pump Drive ",ROW($C$14:$C$58),""),ROW(A1))),"")

Copy down as required.

HTH

rylo