Scan group of cells and result based on condition
 

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

Scan group of cells and result based on condition
 

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.

"Manan" wrote:

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

Scan group of cells and result based on condition
 

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

"akphidelt" wrote:

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.

"Manan" wrote:

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