here is a macro that works, anybody have an alternative suggestion?

**siba** · 12-28-2012, 09:49 PM

I have done a formula by pressing ctrl+shift+enter in excel cell

Formula:

Please Login or Register  to view this content.

,and then I copied it to the cells below,
I have given this code:

Please Login or Register  to view this content.

and I need an equevalent code like this

Please Login or Register  to view this content.

but the code doesn't work, and I don,t know why.
I couldn't use if funcion before max
so I replaced the order
I thinknthat the wrong is with s identifying or using ... becaus It must be an unknown count range...

**protonLeah** · 12-29-2012, 01:05 AM

This code:

Please Login or Register  to view this content.

is seriously wrong. You need to explain what you are trying to do with each line.

**siba** · 12-29-2012, 06:04 AM

I need to find the max value that have the same End as my Start for every pipe in a sewer system.
I could do it by entering this :
=MAX(IF(C:C=B3,D:D,0))
by pressing ctrl+shift+Enter in cell G3, and then I copied it to all other pipes in column G, my results were right, but now I need to do it by going into loop in VBA macro using max and if functions.
the values explained in the excel file above
.
.
.
thanks for every help.