To automate a list based of mutliple column criteria

So I have a list of accounts and for each account there are multiple columns whose criteria I am checking for. If the # in the columns is > 0, I want to list the account # corresponding to the column. Since there are multiple columns and one account could meet the criteria in multiple columns, there will be some accounts listed multiple times for each column in its row where it meets the criteria. So if Acct #1 is >0 in 4 of 7 columns, account #1 will get listed 4 times, followed by the next account that meets the criteria. Any suggestions on how to do this?

Sample document attached.

NBVC, Thank you once again for the very helpful formula. I have been trying to take the table a step further and would like to automate the cells in adjacent columns to list the corresponding depo description and the correct value for that account and depo.

I've tried vlookup with MATCH and SMALL to automate the column #, but haven't had any luck. The other idea I had was INDEX with MATCH but I couldn't figure out a way to automate the lookup value for each depo type with a positive value in it. I want the formula to reference the acct # listed to the left (teal highlight). Check Samplehelp3 for clearer description.

Any help would be greatly appreciated.

THanks again!

Unbelievable. Thank you again. I guess the only encouraging thing for me is that I actually tried to put the right formulas to work but I just couldn't get them in the right place. You guys are awesome, thanks again for the help. I think I have learned more from this site than I have from 2 excel classes at my 18k enrollment university. Thanks again