How to Remove Duplicate Rows Down to the Lowest Amount on Hand in Excel?
Does this go against rule #6? If so, where do I need to be posting this?
Also, this is my first Reddit post ever and I don't really know what I'm doing. I feel like I'm being too... unimpersonable? Robotic? I don't know, like rude? I really don't mean to be. Socializing is not my forte - so I'm sorry in advance... And honestly, any help would be appreciated. I really enjoy learning everything about Excel. Thank you!
I just started taking some duties over for an inventory job.
Basically, we get an inventory report every night listing the quantities of each item listed in a package that we sell. We have about 100 packages with multiple items in them and I need to remove all duplicate rows from Column A based on the lowest number on hand in Column C. We have packages ranging from having only two items to some with up to eight.
The person who trained me is doing this manually - looking through every row and deleting each packages' duplicates. And I feel like there has to be some sort of formula that could make this go a lot easier. It would be great if it could delete the rows for me, but even just like a "highlight all lowest numbered items in each duplicate named package" would help.
I don't know if I'm making sense. Here is an example:
The original Spreadsheet:
| Name | Description | On Hand |
|---|---|---|
| AA1736 | 5-Burner Grill Package | 14 |
| AA1736 | 5-Burner Grill Package | 115 |
| AA1736 | 5-Burner Grill Package | 8 |
| AA1736 | 5-Burner Grill Package | 3 |
| AA1736 | 5-Burner Grill Package | 25 |
| AA1736 | 5-Burner Grill Package | 11 |
| BB16797 | Hammer and Measure Package | 1 |
| BB16797 | Hammer and Measure Package | 4 |
| BB16797 | Hammer and Measure Package | 11 |
| CC18794 | Hand Tool Set | 6 |
| CC18794 | Hand Tool Set | 6 |
| CC18794 | Hand Tool Set | 6 |
| CC18794 | Hand Tool Set | 6 |
| CC18794 | Hand Tool Set | 6 |
| DD1683 | Double Burner with Tank | 0 |
| DD1683 | Double Burner with Tank | 2 |
| DD1683 | Double Burner with Tank | 14 |
| DD1683 | Double Burner with Tank | 17 |
| DD1683 | Double Burner with Tank | 99 |
The finished spreadsheet:
| Name | Description | On Hand |
|---|---|---|
| AA1736 | 5-Burner Grill Package | 3 |
| BB16797 | Hammer and Measure Package | 1 |
| CC18794 | Hand Tool Set | 6 |
| DD1683 | Double Burner with Tank | 0 |
[link] [comments]
Want to read more?
Check out the full article on the original site