| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
From Column select Values to sum
Thanks
Peo Sjoblom wrote: Select Column1 (header and range), do datafilteradvanced filter (don't filter column 2 just 1), select copy to another location and unique records only, that will give you a header a b c d now in the adjacent cell to the right of the cell with a, assume you copied it to h1 then a would be in H2, so in I2 put =SUMIF($A$2:$A$100,H2,$B$2:$B$100) where A2:A100 is column 1 and B2:B100 is column 2 copy down as long as needed Col 1 Col 2 a 1 [quoted text clipped - 17 lines] Can there a function or functions that can do this in excel?? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200705/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select 50 greatest values with column matching | Excel Discussion (Misc queries) | |||
| select detail in column B if column A = date | Excel Worksheet Functions | |||
| How do I select the last 5 non zero values in a row & get an avg? | Excel Discussion (Misc queries) | |||
| Select values from list | Excel Discussion (Misc queries) | |||
| Select top 5 in column A, sum values in B | Excel Worksheet Functions | |||
Threaded Mode
