SpielbergRules247465
New Member
- Joined
- Jun 22, 2020
- Messages
- 4
- Office Version
- 2019
- 2007
- Platform
- Windows
Hello Excel gurus,
I have been using Excel since the early 90s and I have absolutely NO idea how to do this. I am getting older and am having a tough time with my memory and concentration. It's not cool.
In the Mini Sheet (shown at the end), there is a "widget" inventory:
Column A is the quantity. (A blank cell indicates 0.)
Column B in the Part #.
Column C is the part description
Column D is the database code for this part.
As you can see, there are duplicate widgets. "Widget 5" has a total of four, and "Widget 8" has a total of three. (Colors are just for quick identification.)
So, what I need to do for each group of duplicates is tally the quantity. For example, since there are four Widget 5's, I need to put a 4 in Column A next to the first listed Widget 5, then delete the rest.
The same for Widget 8.
Deleting duplicates is easy of course, but tallying the number of them BEFORE that happens is what I can't figure out for the life of me.
I don't even know where to begin!
If there is anyone who can help that would be most appreciated and thank you in advance!
I hope I explained this properly (Sometimes I have a hard time putting into words what's in my head.) (That's usually a good thing!)
Mike
The following is the example,
I have been using Excel since the early 90s and I have absolutely NO idea how to do this. I am getting older and am having a tough time with my memory and concentration. It's not cool.
In the Mini Sheet (shown at the end), there is a "widget" inventory:
Column A is the quantity. (A blank cell indicates 0.)
Column B in the Part #.
Column C is the part description
Column D is the database code for this part.
As you can see, there are duplicate widgets. "Widget 5" has a total of four, and "Widget 8" has a total of three. (Colors are just for quick identification.)
So, what I need to do for each group of duplicates is tally the quantity. For example, since there are four Widget 5's, I need to put a 4 in Column A next to the first listed Widget 5, then delete the rest.
The same for Widget 8.
Deleting duplicates is easy of course, but tallying the number of them BEFORE that happens is what I can't figure out for the life of me.
I don't even know where to begin!
If there is anyone who can help that would be most appreciated and thank you in advance!
I hope I explained this properly (Sometimes I have a hard time putting into words what's in my head.) (That's usually a good thing!)
Mike
The following is the example,
| AML Export Tool v01.5.012223.xlsm | ||||||
|---|---|---|---|---|---|---|
| A | B | C | D | |||
| 1 | QTY | PART # | DESCRIPTION | dB_ID | ||
| 2 | 4 | 46-0001 | Widget 1 | W460001 | ||
| 3 | 46-0002 | Widget 2 | W460002 | |||
| 4 | 46-0003 | Widget 3 | W460003 | |||
| 5 | 5 | 46-0004 | Widget 4 | W460004 | ||
| 6 | 46-0005 | Widget 5 | W460005 | |||
| 7 | 46-0005 | Widget 5 | W460005 | |||
| 8 | 46-0005 | Widget 5 | W460005 | |||
| 9 | 46-0005 | Widget 5 | W460005 | |||
| 10 | 1 | 46-0006 | Widget 6 | W460006 | ||
| 11 | 46-0007 | Widget 7 | W460007 | |||
| 12 | 46-0008 | Widget 8 | W460008 | |||
| 13 | 46-0008 | Widget 8 | W460008 | |||
| 14 | 46-0008 | Widget 8 | W460008 | |||
| 15 | 3 | 46-0009 | Widget 9 | W460009 | ||
| 16 | 46-0010 | Widget 10 | W460010 | |||
XL2BB | ||||||
Last edited by a moderator:
