Dear Max,
I have to update that file on daily basis. Is it possible to do all these
steps in one shortcut formula?

"Max" wrote:

a. Think Autofilter will be the easiest approach ...

Select entire cols A & B, then click DataFilterAutofilter
1. Click on the droplist in A1, select any name
You get all the filtered rows for that single name
2. Click on the droplist in B1, Choose "Top 10"
You get a dialog box to further tinker with for that single name

To quickly clear all filterings for the next name,
just click DataFilterShow All

b. Another easy, fast & relevant summarization to do is to create a pivot
table

Here's the easy steps to lead you in (in excel 2003):
Select any cell within the source table
Click Data Pivot table. Click NextNext
In step 3 of the wizard, click Layout, then:
Drag n drop "Name" into ROW area
Drag n drop "Amount" into DATA area 3 times, one below the other
Leave the 1st as Sum,
Double-click on the 2ndselect Max under Summarize by OK
Double-click on the 3rdselect Min under Summarize by OK
Click OK Finish

Hop over to the pivot sheet (new sheet to the left). Drag "Data" n drop it
over "Total" to get a nice summary table showing all the unique names in the
1st col, with their corresponding Sum, Max & Min amounts in the 3 adjacent
cols to the right
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:62
xdemechanik
---
"Sandeep Jangra" wrote:
I have a two column (Name and Amount) list with repeated values,
1. I want to look up all the repeated values against a single name
2. lookup heightest and lowest amount against a single name.