macro that detects the triplets that have the digit zero (red color) and add the amount and separate in a list on the side
ex=450, yes has zero
458 = no, there is no zero
only the one with the zeros
https://www.excelforum.com/attachmen...1&d=1628775788
Bookmarks