Hi ! I'm trying to find a better way to identify Accounts that hold more than 10 in each Company. I have hundreds of accounts and company so using a normal filter [AccountA] > 10 is not possible and we gain/lose Accounts every other month so individually filtering by Account is not feasible.
Starting off from the table below with existing sample data. I think I may have to do a transpose to have Company as the horizontal header and Accounts vertically in the first column. Following which, is there a formula that is capable of flagging out Accounts that hold more than 10 in each company? If it helps, all Account name will being with Account_123 but Company name is not consistently beginning with Company.
Many thanks in advance.
| Asset Name | AccountA | AccountB | AccountC |
| Company1 | 5 | | |
| Company2 | | 10 | |
| Company3 | | | 20 |
