Multiple Column filter

[lamitche]

I am trying to create a macro that looks at two different columns and hides all the other data if these two match.
For example:
Say is Column A we have fruit:
Strawberries
Bananas
Watermellon
Strawberries

Say in Column B we have the amount of each fruit:
15
12
4
6
I want to filter through column A and look for strawberries but ONLY display strawberries when there are 15 of them (rather just both 15 and 6). So I need to check column B for the value as well. and then hide everything else.
I am completely stuck so any sample code would be incredibly helpful!

[davesexcel]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[jason.b75]

Moderation request removed.

[Alf]

Something like this could perhaps be of help? I assume row 1 i.e. cell A1 and B1 are headings, this will make result more readable.

Option Explicit

Sub FiltValu()

With Range("A1").CurrentRegion
    .AutoFilter Field:=1, Criteria1:="Strawberries"
    .AutoFilter Field:=2, Criteria1:="15"
End With

End Sub

Alf

[lamitche]

Here is the example if the of statement I am trying to use (or at least the logic)

IF(((I3= "Strawberries") AND( (J3=2)) OR( ((I3="Bananas") AND( (J3=8)) OR((I3="Kiwis") AND( (J3=32)) OR((I3="Blueberries") AND(J3=31)) OR((I3="Oranges") AND( (J3=4) OR((I3="Watermellon") AND( (J3=13))); "True";"False")

So if those two categories match up it would display True or False in Column K.
Eventually I do just want to hide all other data in columns I and J and just display the ones that meet these criteria.

[jason.b75]

Moderation request removed.

[Alf]

Hi jason

FDibbins closed this thread

http://www.excelforum.com/excel-prog...mn-filter.html

but the one I'm posting in is open for forum members so perhaps you should modify your comments a bit in post #6

Alf

[jason.b75]

Done Alf, FD locked that thread after I submitted the request to lock this one, methinks a bit of confusification going on

lamitche, please continue in this thread

See if this helps, scroll down to the section for 'Or criteria'

http://www.excel-easy.com/examples/advanced-filter.html

[Alf]

methinks a bit of confusification going on

Yes I guess FDiddins was a bit confused as he probably has a lot on his mind but since:

"It's human to err and divine to forgive"

let's just forgive him.

Alf