Excel-macro to group by column & sum value
Solved/Closed
Related:
- Excel-macro to group by column & sum value
- Spell number in excel without macro - Guide
- Excel free download - Download - Spreadsheets
- Excel marksheet - Guide
- Macros in excel download - Download - Spreadsheets
- Excel macro to create new sheet based on value in cells - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Dec 9, 2011 at 10:30 PM
Dec 9, 2011 at 10:30 PM
download the file "joe.xls" from this web page
http://speedy.sh/4u6ch/JOE.XLS
as the two relevant columns item and length are not contiguous I have to copy only these two columns in col. F and G
now on this F and G column advanced filter was used with criteria range as I1:J1
and the result in I1 (with "copy to another location" and "unique records only" chosen in the advanced filter window.
you get what you have in column I and j
see formulas K2 and L2 which is copied down.
this is spread sheet solution.
http://speedy.sh/4u6ch/JOE.XLS
as the two relevant columns item and length are not contiguous I have to copy only these two columns in col. F and G
now on this F and G column advanced filter was used with criteria range as I1:J1
and the result in I1 (with "copy to another location" and "unique records only" chosen in the advanced filter window.
you get what you have in column I and j
see formulas K2 and L2 which is copied down.
this is spread sheet solution.
Dec 10, 2011 at 10:19 AM