Hi All,

Firstly thanks for taking the time to look at this post.

The problem I have is relating to invoices. I have an Excel spreadshee
which I write down all payments I make for invoices. The invoice number
are always a number and started at 1 and then increment by 1. IE 1, 2,
etc.

What I would like to do is to have a way in which I could look in m
sheet to see if I have any invoices missing. ie 6 and 8 is there but
is not.

Due to the nature of invoices they are not always in order so I migh
pay 9 before I pay 8 and therefore on my spreadsheet they wont be i
order. they are currently in order of when I paid them.

Would anyone know a way I could do this?

Many tnaks agai

--
luxbo
-----------------------------------------------------------------------
luxboy's Profile: http://www.excelforum.com/member.php...fo&userid=2478
View this thread: http://www.excelforum.com/showthread.php?threadid=38345