Vba Variable Filter criteria

[Morre]

I'm currently working on a project of mine where I need my filter to exclude multiple values,

The filter will constantly change and grow with the row head of the smallest value in a range.

For instance:
First step
Filter on Column1 <> A , Then look for the minimum of Colum 2
Second step
Filter on Coulumn1 <> A and <> result of step 1, Then look for the minimum

I used an Autofilter but this can only have 2 criteria.

Any help would be appreciated

 

[guerillaunit]

You'll need to write a macro. I am a little confused by step 2. Can you explain it in more detail?

 

[Morre]

<TABLE style="BORDER-TOP-WIDTH: 0px" class=tborder border=0 cellSpacing=1 cellPadding=6 width="100%" align=center><TBODY><TR title="Post 3090265" vAlign=top><TD class=alt2 width=125 align=middle>guerillaunit</TD><TD class=alt1>Re: Vba Variable Filter criteria
<HR style="BACKGROUND-COLOR: #ffffff; COLOR: #ffffff" SIZE=1>You'll need to write a macro. I am a little confused by step 2. Can you explain it in more detail? </TD></TR></TBODY></TABLE>

I Know I will need a macro but I'm a bit stuck on the filtering part.

For step 2 I'll try to explain the total setup

In Column 1 I have about 8 row headers (A to H). these are starting in Row 2
In Row 1 I have the same 8 value's as the row headers(A to H).
In Column 2 I want to find the minimum and not being 0. This will give a value in Column 1 (rowC), then i will look for the minimum in the column which has the same header as the calculation before (C) and this minimum must be different from 0 or the value Of Row A. the result is row G
Then look for the minimum in column G and must be different from 0 row A or row C

Till all columns have a minimum.

I hope this exlains it a bit