Hi,

Hoping someone can help please! i have lists of loads that have been
delivered in col A, in col B i have a look up formula to record the invoice
that we piad for the load on, if not then the formula returns an X. What i
would like to be able to do is get a formula that can list the loads that
have an X beside them without having lots of blank lines, so i can see what
loads we still have outstanding to be paid?
I have the same set up on 5 sheets each for different suppliers...

Is this possible?

Thanks!