Help filtering 2 columns silmutaneously.

[mkv7t]

screens.png

Sorry for the bad picture, basically I want the full lists for the value "2020" in both columns. If I put the filter on both columns, it only returns one result as its trying to match them. However each column has a lot of results from the year 2020.

I have tried to make a new column returning a true or false response to =OR(G1=2020,H1=2020) however is there another way?

Thanks a lot.

[Glenn Kennedy]

Hi there.

A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.

Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet.

[mkv7t]

Hi there.

A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.

Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet.

Thanks, Attaching an example. Appreciate the help!

[Glenn Kennedy]

Did you mean AND or OR??

This returns values where column E AND column F are 2020. There is only one matching result. Row 11.

=IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW($D$2:$D$30)/((YEAR($D$2:$D$30)=2020)*(YEAR($E$2:$E$30)=2020)),ROWS(I$1:I1))),"")

copied across and down.

[Glenn Kennedy]

If you meant OR.... either column E OR column F amend to:

=IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW($D$2:$D$30)/((YEAR($D$2:$D$30)=2020)+(YEAR($E$2:$E$30)=2020)),ROWS(I$1:I1))),"")