Countif Else?

[burmtra]

Hi, I have a column of values which are either R, A or G.

I want to search the column(range) and if any cells contain R to return R, otherwise if any cells return A to return a A otherwise to return G.

I want this is one formulae which I can place in a cell.

Any assistance would be greatly appreciated.

Thanks!

 

[jarjarbingie]

Hi, I have a column of values which are either R, A or G.

I want to search the column(range) and if any cells contain R to return R, otherwise if any cells return A to return a A otherwise to return G.

I want this is one formulae which I can place in a cell.

Any assistance would be greatly appreciated.

Thanks!

post a sample of the data and the required output..

 

[burmtra]

post a sample of the data and the required output..

Hi, here is the range (a column of data)





4/08/2017
R
RAM on 02,09,14,18a,20a,22a,22a,25a,27a, Diskpace on 22a




A
EBMFILE02 Memory




A
Memory on EBMMAIL01 and EBMMAIL02




A
Memory on both EBMQSL01 & EBMSQL02




G






G














G



I want to search through all of these cells and if any of the cells = R to produce an "R" in the output cell; otherwise if any are an A to produce an "A"; otherwise to return a "G".

Thanks

 

[jarjarbingie]

not sure if I understood the request correctly but if you want to check if the cell contains R, A or G, here's the formula:

=IF(ISNUMBER(FIND("R",A1)),"R",IF(ISNUMBER(FIND("A",A1)),"A",IF(ISNUMBER(FIND("G",A1)),"G","")))

 

[FormR]

I want to search the column(range) and if any cells contain R to return R, otherwise if any cells return A to return a A otherwise to return G.

Hi, welcome to the board! Not sure I understand the data either, but based on the above maybe:

=IF(COUNTIF(A:A,"R"),"R",IF(COUNTIF(A:A,"A"),"A","G"))