VBA Code Help needed!

[Javi]

I have a worksheet that contains 90K plus rows.
Column B represents part numbers
Column K represents usage (usage can range from 0 to 5000 for any part)

The part number will appear multiple times based on different locations with different usage.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
I need to know what parts had 0 at all storage locations.

 

[Javi]

I would Like to put an indicator and column O if the above criteria of no (0) usage in any store location is met. It can be a numeric number or a statement anything that would allow me to sort by.

 

[Hermanito]

I'm no formula expert, but I think you would need something like SUMIF. Then you can create a formula that sums all usages for all lines that have equal partnumbers. That formula has the partnumber as a parameter and returns the sum of usages. Then you can sort on that sum and select the ones where it is 0.
For a range of 90K rows, I'm afraid for the performance though, since this formula will need to be calculated 90K times as well...
I guess it would be wise to let it calculate everything once, then convert the results to values and remove the formulas.

 

[zjwbotak]

Hi Javi, Does a pivot table solves your problem? You can pivot by dragging into the Row: "Part Number", dragging into the Data: "Usage" (Note make sure that the usage is sum not count)?