Thanks for the reply,
Not exactly following what you said, so I included a few rows of my 2 worksheets. The data is coming from 1 worksheet and I want to place the extracted data on another. I tried the helper column, but didn't understand all of it, so I messed it up and am getting errors...
I have a list where some people have paid and others not. I want to create a sheet that has only the people with “0″ dollars balance. Columns I am choosing from are name, rank, balance. These are unsorted (order cannot be changed). I would like the “Balance Due” sheet to choose which person has...