CSV. A12 would be cell B1 and 512 would be cell B2. What is the standard
format to post a range here?

"Mike H" wrote:

Hi,

The question is too ambiguous to attempt an answer. Lets take 1 piece of
sample data

A12,512

Is this all in 1 cell?

how is the 'number' split up,
is it A and the number 12512?
Is it A12 and the number 512?

Mike

"CSchwass" wrote:

I need to sum the top ten values for 5 categories in a data range.

I can sort/filter by the category and use SUM and LARGE, but I want to show
the results in 5 cells (one per category) and automate the process. I am
willing to create a macro if a formula can't cover it.

My data looks like this:

Category,Value
A12,512
B35,458
A42,430
C20,429
E12,409
E29,395
D30,350
etc.

...in Columns A and B. How can I get results like this:

Category A,{Sum of top ten values for category A}
Category B,{Sum of top ten values for category B}
Category C,{Sum of top ten values for category C}
Category D,{Sum of top ten values for category D}
Category E,{Sum of top ten values for category E}

Thanks,
CSchwass