Hi,
I need excel formula that will give me the result in column C.
if one of the items in column A has number in one of its rows then all of his rows are OK.
if the item in column A has no number in column B then all of its row are NOT OK in column C.
A B C
185 55 OK
185 55 OK
185 OK
186 NOT OK
186 NOT OK
186 NOT OK
Thanks
Bookmarks