Here's one ..

No need col D, just put in A1:
=OFFSET($C$1,INT((ROW(A1)-1)/3),)
Copy A1 down to A2500
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Mr. Low" wrote:
Dear Sir,

Lets consider the following worksheet:

A B C D
1 512 xxxx 512 1
2 512 xxxx 613 2
3 512 xxxx 816 3
4 613 xxxx 925 1
5 613 xxxx 216 2
6 613 xxxx 327 3
7 816 xxxx 428 1
8 816 xxxx 629 2
9 816 xxxx 520 3
10 925 xxxx 821 1
11 925 xxxx 922 2
12 925 xxxx 623 3

......

2500




I need to fill up column A with similar references obtained from Column C
for 3 times each.

Column D had a running number that repeat itself after a count of 3,

Is there any formula I can input at A1 and copy down to A2500 to get the
straight answer ?



Thanks

Low


--
A36B58K641