Beautiful man, just beautiful! This subtotal formula is just what I needed. I recently read the difference between subtotal and running total and I didn't get it. I get it now. I have 16,000 rows to filter so it takes a few seconds to calculate, but when it's done my results are numbered from top to bottom!