hope this will help you. please find the attachment...
On Monday, February 28, 2011 12:58:15 AM UTC-8, Prathap D wrote:
>
> Dear All,
>
>
> I have an excel sheet in which i need to find the missing numbers in the
> sequence. Please help me with the formula to identify missing numbers in a
>
Insert new column then use this formula in column C
=RIGHT(B3,3)
=IF(C2-C1=1,"","missing")
Regards
Saggi
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitte