Hello,

I currently have a matrix that requires a series of loops with conditions, to retrieve data given a pre-selected value by the user. I am successfully able to compile the array to match the conditions, for both "Score" and "Correll" but I now have zeros where the conditions were not met...how can I remove these to get only a list of those values that match my criteria?

Also, i would like to then use the results to populate two list boxes ("listCG" and "listMC"); however, instead of actually populating the listbox with the actual values, I would like to reference another cell in the corresponding row for each (Column "C" of "matrix" worksheet).

If this doesn't make sense I can clarify. Thank you in advance for the help, I sure could use it!

Please Login or Register  to view this content.