Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMS
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 "heather" wrote: "Glenn" wrote: heather wrote: i put it on there....this is the link it gave me....http://savefile.com/files/1978951 Thanks for the help "Glenn" wrote: heather wrote: "Glenn" wrote: heather wrote: Well, it doesn't really have anything to do with it. The first question didn't work so I am going about it from a different angle....Here is What i would like to happen.... Col A Col B Col C col D 699875 0102802NTZG 699875 0102802NTZG 345666 0102802NUCU 699875 0107802OBEX 548986 0104802NWPZ 699875 0107802OBFA 699875 0107802OBEX 548986 0104802NWPZ 699875 0107802OBFA etc... 462083 0107802OBZY 472550 0107802OCDY 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$1 000,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$1 000,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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMS
heather wrote:
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 See my reply in the original thread. Or, just go he http://www.savefile.com/files/1982535 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sums | Excel Worksheet Functions | |||
Max sums | Excel Discussion (Misc queries) | |||
SUMS | Excel Discussion (Misc queries) | |||
How to add previous sums in a column to current sums in a column? | Excel Worksheet Functions | |||
Sums | Excel Discussion (Misc queries) |