Consecutive numbers

Hello ,

I need help
Please see the Attached file "consecutive numbers.xls"

Thank you

This is not what I meant, i want to copy the consecutive numbers from sheet1 to sheet2 not counting the numbers...

ok , this is better but in sheet1 i have 17 RANDOM numbers from 1 to 70 (sort from A2 to Q2) and let say the consecutive number are 21,22 and 37,38
in sheet2 i have a table from A2 to BR2 and i want to copy the consecutive numbers like this.please see the example in the attachments

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

newx, although you are the one who started this thread, your latest question is unrelated and is a hijack. You already started a new thread to ask this question so please return to that thread and update the thread title as the Moderator requested.