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.
Bookmarks