We have a spreadsheet with 3 columns.
Column1 contains 7 digit seriel numbers
Column2 contains years (1990 - 2000)
Column3 contains units
It would look similar to below:
1234xyz 1990 3
1234abc 1997 1
1246abc 1992 5
1234nmo 1998 6
We need to see how many units we sold for years 1990-1995 and 1996-2000 for seriel numbers where the first 4 digits of the seriel number match. Desired outcome:
1234xyz 1990 3
total units=3
1234abc 1997 1
1234nmo 1998 6
total units=7
1246abc 1992 5
total units=5
We know there is a way to do this - grouping and subtotaling? - but the Help in Excel is baffling us? Could you help?
THANKS!!!!
Column1 contains 7 digit seriel numbers
Column2 contains years (1990 - 2000)
Column3 contains units
It would look similar to below:
1234xyz 1990 3
1234abc 1997 1
1246abc 1992 5
1234nmo 1998 6
We need to see how many units we sold for years 1990-1995 and 1996-2000 for seriel numbers where the first 4 digits of the seriel number match. Desired outcome:
1234xyz 1990 3
total units=3
1234abc 1997 1
1234nmo 1998 6
total units=7
1246abc 1992 5
total units=5
We know there is a way to do this - grouping and subtotaling? - but the Help in Excel is baffling us? Could you help?
THANKS!!!!