Filtering based on expiry date and other criteria

See if this get you close. See attachment.

Please Login or Register  to view this content.

Here is a small table showing how you could do this with an ARRAY formula, no VBA needed.

	A	B	C	D	E	F	G
1	Name	Tier	Expire			1	2
2	aa	1	1		Name	Tier	Expire
3	bb	2	2		aa	1	1
4	cc	3	3
5	dd	1	4
6	ee	2	5
7	ff	3	6

F1=tier level
G1=expire months...you did not specify if you wanted to be that exact value, or <= that value, so I used =
E3=IFERROR(INDEX(A:A,SMALL(IF(($B$2:$B$7=$F$1)*($C$2:$C$7<=$G$1),ROW($A$2:$A$7)),ROWS($A$1:A1))),"")
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
then copied down and across

thank you both for your replys, the vb stuff is a bit beyond me so i have read up a bit around if errors and arrays and i think this will be the way to go.

sorry for not being completley clear but i'll have another go, i have a table that is populated by 816 different companies with infomration about the company going from column A to V

A5:A821 is a list of the tier each company is in (1-5)
F1:F821 is company name
M1:M821 is the expiration date

what i want is a new sheet (lets call it "upcoming renewals") that feeds off this table that looks at the A and M column

so i want if A is tier 1 and M is within 365 days of today, display either the full row (A to V) in the upcoming renewals sheet (so i can filter it down to importand columns).
if A is tier 2 and M is within 192 days from renewal display the A to V of that that company

then tier 3 - within 90days
tier 4 within 60 days
tier 5 within 30 days

it doesnt have to be the full row thats displayed as there are maybe 5 or 6 columns that are relevant but if possible its probably easier to display it all then filter it?

I really appriciate the help guys, this place is awesome