I am looking for a way to take a list of data and transfer this to another
spreadsheet, identifying who the low performers for a metric might be. The
data is laid out as below.

A B C
Name Value Rank

There are hundreds of rows of data. I am wanting to return on a seperate
spreadsheet the only individuals who rank in the bottom 10% and their
corresponding information. I would like to generate a formula that will
allow this to autopopulate based on the amount of data each time the report
is modified.