Assuming you don't have any headings, put 37518 in cell C1 (or C2 if you do
have headers). Then in C2 put this formula:

=IF(B2=B1,C1,C1+1)

and copy this down.

Alternatively, you can put this in C1 and copy down:

=B2*1-54093

Hope this helps.

Pete

"RCB" wrote in message
...
Hi thanks for your reply
Col 3 was shown for example purposes. It should hold the new calculated
value.

I need to populate col 3 with values similar to col 2 but in a different
range.
e.g.
Cols 1 & 2 contain the following:
Col 1 Col 2
4 91611
5 91611
4 91612
5 91612
1 91613
4 91613
5 91613
1 91614
4 91614
5 91614
1 91615
4 91615
5 91615

Ny spreadsheet contains cols 1 & 2. You will see that there are repeated
values in Col 2. This is a transaction no.
I need a formula to populate a new transaction no into col 3, which starts
from a new value (e.g. 37518) and allows me to fill the formula down. I've
used col 1 (status value) to try to uniquely identify the records also.

So, col 3 should look like this if I can get the formula right:

col 1 col 2 col 3
4 91611 37518
5 91611 37518
4 91612 37519
5 91612 37519
1 91613 37520
4 91613 37520
5 91613 37520
1 91614 37521
4 91614 37521
5 91614 37521
1 91615 37522
4 91615 37522
5 91615 37522

It's probably IF or IF(AND), IF(OR).

This is really hard to explain, sorry.

"FSt1" wrote:

hi
your first sentence is broken and leaves out the need of column 3. what
is
the need of column 3?
you are looking for a formula. to calculat somthing....what?
is column 3 calculated? where did you get this value? how were the values
in
columns a, b and c derived?

more info please.

Regards
FSt1

"RCB" wrote:

I have 2 cols of data and need Col 3 which inserts a value the same as
column
2 but in a different range. Col 3 has been populated here to show as
example.
I've been working on if statements but can't find the right one, I've
tried
if and statements also. BTW I've only include Col 1 because it might
help to
uniquely identify the values, but may not be necessary.

Using Excel 2003 SP3

Col 1 Col 2 Col 3
4 91610 37513
5 91610 37513
4 91611 37514
5 91611 37514
4 91612 37515
5 91612 37515
1 91613 37516
4 91613 37517
5 91613 37517
1 91614 37518
4 91614 37519
5 91614 37519
1 91615 37520
4 91615 37521
5 91615 37521
1 91616 37522
4 91616 37522
5 91616 37522
1 91617 37523
4 91617 37523
5 91617 37523
1 91618 37524
4 91618 37524
5 91618 37524
1 91619 37525
4 91619 37525
5 91619 37525
1 91620 37526
4 91620 37526
5 91620 37526
1 91621 37527
4 91621 37527
5 91621 37527


Thanks