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