I have a list of products with different "steps". if there are duplicates in consecutive rows, i would like the Quantity in the Total Row to reflect the minimum value rather than the sum of the cells that contain the duplicates. How do I do this using VBA? Thank you in advance
Book1.xlsmphoto1705923494 (1).jpegphoto1705923494.jpeg
Last edited by chyeenne; 01-23-2024 at 09:11 PM.
If you want us to work on a Pivot Table, you need to provide the raw data.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
But if you have a table produced other way, or just ciopied and pasted, the main issue is that you tested both productname and quantity in column 2 (B).
Assuming your data starts in A1 this code shall do the job:
Please Login or Register to view this content.
Best Regards,
Kaper
Please Login or Register to view this content.
Last edited by sintek; 01-22-2024 at 12:23 PM.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
hi kaper thank you SO much! your code works excellently. may i know if there is a way to set a condition that if any of the quantity is 0, the total will be the lowest value above 0 instead of 0?
Tx for rep...I know you did not ask me...just for completion...
total will be the lowest value above 0 instead of 0?Please Login or Register to view this content.
Last edited by sintek; 01-23-2024 at 03:53 AM.
You can add second test to final IF.
But what in case when 0 is in first row of given product?
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks