I have an attached excel with list of companies in Rows and Columns
Now, I want to know list of relationships where balance more than zero (for all companies) so that i can assign the team those companies to further work on.
e.g. A13:B13 is one relationship which has a balance of 1,951 which i want to assign to Team member 1, similarly A17:K17 has a balance of 81,891 which i would like to assign to team member 2.. so on and so forth..
Not sure which would be best formula to use to get the desired result..excel attached..
Now, I want to know list of relationships where balance more than zero (for all companies) so that i can assign the team those companies to further work on.
e.g. A13:B13 is one relationship which has a balance of 1,951 which i want to assign to Team member 1, similarly A17:K17 has a balance of 81,891 which i would like to assign to team member 2.. so on and so forth..
Not sure which would be best formula to use to get the desired result..excel attached..
Attachments

135.8 KB Views: 6