count formula

I need help with a formula to count loads. The count in the load # column would start at 1 and only show up if there was data in the location column. The load # would be the same for rows that have the same # in the load column.
the problem i'm having is when there is no data in the location column and i need the load number to pick up the next row with data and assign a number.
In my sample the load # column would mirror the load column, but use a formula.



Thanks in advance!

so far this works;
=IF(D4=D5,B4,IF(C5<>"",MAX($B$4:B4)+1,""))

the problem I have now is if the cells are blank. If D4=D5,B4 except if they are blank. thats what I need.
please help. My brain's inop today!

This work for you?

=IF(AND(D4=D5,NOT(ISBLANK(D5))),B4,IF(C5<>"",MAX($B$4:B4)+1,""))

Pauley

yup!
thanks