Hello,

I have group of cells in a coulmn, that have values of
N/A
N/A
N/A
N/A
B

The result cell should scan a group showing above and show result as B. It
means if any of the cell in the group shows B it should show B otherwise N/A.
If the group of cells would be
N/A
N/A
N/A
N/A
N/A
The result cell should show N/A. Any help please?

Thanks,
Manan