compare 2 columns and result in 3th column

Hi all,
pls. how can i do with formula folowing:
i have 3 columns.
In column A is ID. In B is name and in C i want to add results.
I want to add in column C info if is in this row ID, which is blank in column B, but the same ID have any info (is nonblank) in colum B (in othere row).
how can i do that?
thank you

Example
--------A--------B---------C
1 ------23 ------ben ------ok
2------ 23 ---------------BLANK
3 ------555 -----sue------ok
4------ 111 -----dag------ok
5------ 111 -----pet------ok
6 ------255 -----fee ------ok
7 ------255 --------------BLANK
8------ 255 --------------BLANK

sorry for my mistake... i have shortcut and this is to bad forum

Originally Posted by vijay2482

Hi,
I have written a macro that will do your need.

Please Login or Register  to view this content.

Hope this helps!

yes, this works
thank you very much

i figured out also this formula (but is it with my real column) wich works also:

Please Login or Register  to view this content.

to ROYUK.
your code is not what i needed...this simply formulas i know..but thank you

i know,
it was good, that you moved this thred
thx