Hi all,

I'm looking for a formula and wondering if anybody can assist. There are the rules I need to follow.
  1. There are two columns with multiple unknown rows.
  2. Column 1 on any given row may or may not be populated with a value.
  3. In column two, the first cell in column 1 that is populated must equal 10.
  4. The second cell that is populated must equal 9, and so on down to 1.


The purpose is to show that I have 10 slots available in a given box and to advise when the box no long has slots available.

Can anybody assist with a formula that might be helpful in this case.

Cheers