Consecutive numbers

Your second example doesn't make sense. In Sheet1 row 2, for example, starting in column D, reading left to right:

21, 22, blank, 37, 38

but in Sheet2 row 2 starting in U, reading left to right

21, 22, blank, blank, blank, blank, blank, blank, blank, blank, blank, blank, blank, blank, blank, blank, 37, 38

It is completely unclear what is the pattern you are using to copy these numbers. Why have you added 13 extra blank cells?

Hello,

I have 17 numbers from( 1 to 9)

ex: A1=2,B1=3,C1=1,D1=4,E1=2,F1=1,G1-9,H1=6,I1=4,J1=5,K1=7,L1=8,M1=9,N1=2,O1=3,P1=6,Q1=7

IN

R1 i want to count the no1 (total count=2)
S1 i want to count the no2 (total count=3)
etc..
etc..

Thank you

Isn't this last post the same as this thread:

http://www.excelforum.com/excel-gene...need-help.html

Why start a new thread?

Pete