Scan group of cells and result based on condition

M

Manan

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
 
A

akphidelt

Type in to a cell the formula

=If(Iserror(Match("B",A1:A5,0)),"N/A","B")

Change A1:A5 to whatever the range of data you have.
 
M

Manan

Awsome! I was keep trying different function did not work out. Finally, you
made my day. Thanks a bunch for your great help....
 
Top