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!
Bookmarks