Venturing a wild guess here. If you manually flag/mark the designated rows
in a col with say, the letter: X, you could then easily apply autofilter on
this col, and choose: X to immediately retrieve all flagged rows. No formula
needed, just a simple use of Excel's powerful autofilter feature. You can
just as easily copy the filtered results and paste it into another sheet for
whatever downstream calculations, etc
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
