IF Function

[Mailing]

Hello,

I have two columns of numbers

60 1
60 1
60 1
58 1
58 1
58 1
58 1
07 1
07 1

I need a formula to print ## at the end of a number group in column one. So it would print ## in row three. row seven and nine. It seems like it would be something like in C2 you would write the formula if A2 does not equal A1 then C1 is ##. I don't know how to write this equation or if it would be the correct way to do it. Any help would be appreciated.

Thanks, Mike

[ConneXionLost]

In cell C2, try:

Please Login or Register  to view this content.

[mike65535]

It seems like it would be something like in C2 you would write the formula if A2 does not equal A1 then C1 is ##.

Not sure that's what you want... how about this?

It seems like it would be something like in C2 you would write the formula if A2 does not equal A1 then C2 is ##.

[Mailing]

ConneXionLost is exactly the solution I was looking for. Thank you very much for your help.

Mike