Create a sustainable function which can auto-fill a cell with matching two criteria with a function

I am trying to create a Google Spreadsheets record and generate numbers of table with filtered data. The image is what I am expecting: Google Spreadsheet expected result:

The first table "List" is the data with ID. The other tables are expected to filter the data.

Take the example in cell A3, the ID is PM00001, which is PwC and Facebook. What I am looking for is it will fill cell M3 automatically, since that table is PwC Facebook.

The "List" table will continue develop. So I am looking for a function sustainable for the whole column which I can put in, e.g. cell M3 and able to drag and collect the data from the List table.

Answers


You want to use the FILTER() function. In E3 put

=FILTER($A$3:$A,
        $B$3:$B = $E$1 
        $C$3:$C = E$2)

This will filter Column A for all entries where the corresponding row in Column B is equal to the platfrom in row two and the header in row 1. You can drag this to the right and Column F and G will filter too. For the other Clients you'll need to change the reference from E1 to I1 and N1 respectively.


Need Your Help

JavaScript Unknown Error in Code

javascript html

So Im making a simple guessing game and the numbers go from 1-10. The issue is whenever I guess the number right it still says that I get it wrong here is the source code for the program. (Is that ...

Spark not be able to retrieve all of Hbase data in specific column

hadoop apache-spark mapreduce hbase

My Hbase table has 30 Million records, each record has the column raw:sample, raw is columnfamily sample is column. This column is very big, the size from a few KB to 50MB. When I run the following...