Counting if two cell match saved value(i need my working code revised)

Originally Posted by AlphaFrog

Have you considered making a Pivot Table? It seems that your data is well suited for it.

If you do a internet search for something like Excel Pivot Table tutorial, you'll find several videos and step-by-step guides.

i watched an video on pivot tables and ummmm..... you made the lightbulb in my head blink a few times, i will definitely research into these, this will be a ridiculously huge and efficient future upgrade to my tool.

but... for now i spent the past month on this(much much more code than what i posted) and basically almost done, except for the part that my tool takes 60-90 seconds to process all the code i wrote, also what i posted plays a huge role in other columns it populates.

next week i will research pivot tables for sure, but for now basically all my code has been written and i just need to work on code efficiency to get it to at least 20-30 seconds, then i will lookin to pivots.

Originally Posted by bakerman2

My 2 cents.
Push CommandButton for results.

Wow i got two experts attacking me with crazy good info... any way you could get the result to be placed in column D next to the product/brand on each row?
thanks for you help

Originally Posted by fullerorb7

grabs the cell values of column B(product) and C(Brand) with current row number, then starts a loop for any matches where both column B(product) and C(Brand) are the same and the saved value.
Then and adds to total count AND also counts the value in column F(Price) for our end result.
.

try

Please Login or Register  to view this content.