vlookup/if/large

[superspurs]

Hi,

I don't know if this is possible but thought i'd check.

Could I put together a look up that pulls through the 5 best performing categories'

so say i have 200 categories, just to pull on to a report page the top 5 and their result, and produce a report weekly so if the top 5 change it updates this?

Thanks,

[Palmetto]

Use a Pivot Table.

[Ron Coderre]

I attached a Pivot Table approach that you may want to consider.

The scores are generated randomly....Press F9 to change them.

To update the Pivot Table, right-click on it and select: Refresh Data

To see the settings....
Right-click the Category field
...Select: Field Settings
...Click: Advanced

Is that something you can work with?