How to filter rows and columns simultaneously

**RUDYwien** · 03-22-2021, 12:30 PM

I have a table with 78 columns and 7.115 rows. To make it easier I will attach only a little example of my original file :-)

I need to filter some values by row and column in order to have the value of the correspondent cell.

EXAMPLE.png

In this example I just want to filter "PLATFORMBBB + Afghanistan + AVAILABLE + NUMBERS MARCH" and to have the value in the cell L16 (213.966)
This value must be displayed as shown in the file attached.

I tried to use the FILTER function with multiple criteria but it gives me back the whole row 16 and not only the value into the column NUMBERS MARCH.
Please have a look at Excel sheet attached: "Example + Results"

**Glenn Kennedy** · 03-22-2021, 02:13 PM

You can use:
=INDEX($F$2:$F$37,MATCH(1,INDEX(($B$2:$B$37=B44)*($C$2:$C$37=C44)*($E$2:$E$37="Available"),0),0))

Note the spelling of Platform in B44, however, (not Platfrom)!!

**Fluff13** · 03-22-2021, 02:21 PM

With filter

Formula:

Please Login or Register  to view this content.

**RUDYwien** · 03-23-2021, 05:06 AM

Thanks Glenn and Fluff!

Glenn: I'll try to apply this to my "master file". Thanks for the spelling advise as well

Fluff: I didn't think about applying double filter. Good idea

**Glenn Kennedy** · 03-23-2021, 05:22 AM

You're welcome.

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

**Fluff13** · 03-23-2021, 09:54 AM

Glad to help & thanks for the feedback.

How to filter rows and columns simultaneously

LinkBack

Thread Tools

Rate This Thread

Display

How to filter rows and columns simultaneously

Re: How to filter rows and columns simultaneously

Re: How to filter rows and columns simultaneously

Re: How to filter rows and columns simultaneously

Re: How to filter rows and columns simultaneously

Re: How to filter rows and columns simultaneously

Thread Information

Users Browsing this Thread

Similar Threads

Simultaneously Get Pivot Data Having Multiple Filter Values

[SOLVED] In Excel how can I filter multiple columns SIMULTANEOUSLY?

[SOLVED] Freezing several columns and several rows simultaneously

Macro to hide both rows and columns simultaneously based on data in cells.

How to use advanced filter simultaneously in few sheets

Autofill columns and rows simultaneously

How do I lookup values from rows and columns Simultaneously

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions