I have two ideas:

1. When the cell fills in (when your other conditions are met), in addition to filling in the cell, your conditional can also increment an address cell which is somewhere else. You use this address cell in your other location to figure out where your data is.

2. Use a delimiting value on your column, like "END", or something -- doesn't matter. Then, when your conditions are met, the next column value is written, as well as the delimiter in the next row of that column. Your display area, elsewhere in the page, can look for the END using a conditional, and display the results of the row above it.

There may be better ways with newer versions of Excel. My hard-core Excel days are a ways back...

FWIW,
Jim