find the missing numbers in alternate columns

hi all

need to find missing numbers in alternate columns P,column R,and column T were lowest number is 3346 and highest number is 3372.

file attached.

thanks.

Put the number 3346 in cell AB2, and this formula in AB3:

=AB2+1

Copy down until you reach 3372 (row 28). Then you can use this formula in cell AC2:

=IF(COUNTIF(P:P,AB2)+COUNTIF(R:R,AB2)+COUNTIF(T:T,AB2)=0,"missing","")

and copy this down.

Hope this helps.

Pete

hi all

thanks PETE it is working, but little long process as i have many numbers to check ,any other way around.

thanks