hi,
I have 2 sheets 1. LR_CNF and 2. Summary
LR_CNF sheet has container-wise loading data and we put BL no. against each container as
they sail and BL is issued.
in the Summary Sheet, UNDER BL STATUS we intent to summarize BL only. if BL Coloumn is blank it should not be
populated
the formula used was working initially and now it stopped and not pulling the BL nos after more
containeers are inserted in this sheet.
Kindly help is sorting the mistake if any in the formula or else advise.
Thanks
Ranbir
Bookmarks