Insert a value based on unique valuse in a row

  • Thread starter Thread starter John Fevens
  • Start date Start date
J

John Fevens

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
 
Back
Top