I have done some searching for this to no avail. Here is an example
of what I need:

A B C

1 data
1 data
1 data
1 data 1
2 data
2 data
2 data 1
3 data
3 data 1
4 data
4 data
4 data 1



I want some sort of macro or formula to insert the 1 in column c, for
the last of occurence of the number in column A.

Any suggestions?

Hi John
one way: if your numbers are sorted ascending (as your example
suggests) enter the following in C1:
=IF(A1<A2,1,"")
copy down
HTH
Frank

John Fevens wrote:
I have done some searching for this to no avail. Here is an example
of what I need:

A B C

1 data
1 data
1 data
1 data 1
2 data
2 data
2 data 1
3 data
3 data 1
4 data
4 data
4 data 1



I want some sort of macro or formula to insert the 1 in column c, for
the last of occurence of the number in column A.

Any suggestions?

how about using a formula

in C1

=if(A2<A1,1,"")

then drag fill down the column.

--
Regards,
Tom Ogilvy

"John Fevens" wrote in message
om...
I have done some searching for this to no avail. Here is an example
of what I need:

A B C

1 data
1 data
1 data
1 data 1
2 data
2 data
2 data 1
3 data
3 data 1
4 data
4 data
4 data 1



I want some sort of macro or formula to insert the 1 in column c, for
the last of occurence of the number in column A.

Any suggestions?