SUMS


H

heather

OK, after the problem below I am now finding it difficult to
sum the $ in col R by the number in Col I....example in
http://www.savefile.com/projects/808732916
I would like it to look like COL S in the end...How can I do this



Column C and D I would like to get some formula to auto enter the info.
Number from largest to smallest which i used the Larger() ...and Column D to
pull the corresponding number/letter seq from column B.

One possible way...

C2 = LARGE($A$2:$A$1000,ROW()-1)

D2 = IF(C2=C1,INDEX(INDIRECT(ADDRESS(MATCH(D1,$B$2:$B$1000,0)+2,2)&":B1000"),
MATCH(C2,INDIRECT(ADDRESS(MATCH(D1,$B$2:$B$1000,0)+2,1)&":A1000"),0)),
INDEX($B$2:$B$1000,MATCH(C2,$A$2:$A$1000,0)))

Adjust the "1000"'s to include all of your data, then copy both down as far
as
needed.

Ok, I tried that formula but for the numbers in column A that duplicate all
it returned to me is #num!

With the data above it worked fine. Can you put a copy of your worksheet on
www.savefile.com for someone to look at?


You said columns C and D, but you really wanted columns H and I.

H2 = LARGE($A$2:$A$1000,ROW()-1)

I2 = IF(H2=H1,INDEX(INDIRECT(ADDRESS(MATCH(I1,$B$2:$B$1000,0)+2,2)&":B1000"),
MATCH(H2,INDIRECT(ADDRESS(MATCH(I1,$B$2:$B$1000,0)+2,1)&":A1000"),0)),
INDEX($B$2:$B$1000,MATCH(H2,$A$2:$A$1000,0)))



AWESOME!!!!!!!! You are the BEST!~!!! Thank you soooooooo much!!!!!!! 18,000
gold stars for you!
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top