Smart spreadsheeting according to 3 parameters?

Hello!

I am not too shabby with setting up basic charts on my own, but my boss has seen what I've done with the ultimate basics (we're talking simple line graphs of revenue over time--he was astounded) and has asked me to do something I have no idea how to do.

Basically he tossed me a spreadsheet with a huge jumble of data, with three relevant values: employee names, a dollar value, and a percent value.

I need a little table for each employee, so one table only pulls rows where employee=Ann, the next only where employee=Ben, that sort of thing.

Then in each table I need to specify a range of dollar values (say, 0-499, 500-699, 700-999 etc) and show the average percent value for each range.

I have no idea how to make Excel do all this, and I'd really appreciate some help! Thanks in advance for your time.

I had to wait until I got home to check the example--stupid phone--but it was really worth the wait. I will learn a lot from this. Thank you!!