ExcelBanter - Value of particular column

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Value of particular column (https://www.excelbanter.com/excel-worksheet-functions/230564-value-particular-column.html)

kashish

Value of particular column

Formula for A column
If B = Y then there will be value in C column or D Column (any one column
has value)
Value of C or D should come in A
For example

A B C D

A Y A
B Y B
N
C Y C
N
D Y D

Jacob Skaria

Value of particular column

Formula in A1..

=IF(B1="Y",IF(C1="",D1,C1),"")
--
If this post helps click Yes
---------------
Jacob Skaria

"kashish" wrote:

Formula for A column
If B = Y then there will be value in C column or D Column (any one column
has value)
Value of C or D should come in A
For example

A B C D

A Y A
B Y B
N
C Y C
N
D Y D

Mike H

Value of particular column

Hi,

Put this in A1 and drag down

=IF(B1="y",C1&D1,"")

Mike

"kashish" wrote:

Formula for A column
If B = Y then there will be value in C column or D Column (any one column
has value)
Value of C or D should come in A
For example

A B C D

A Y A
B Y B
N
C Y C
N
D Y D

kashish

Value of particular column

Thank You

"Mike H" wrote:

Hi,

Put this in A1 and drag down

=IF(B1="y",C1&D1,"")

Mike

"kashish" wrote:

Formula for A column
If B = Y then there will be value in C column or D Column (any one column
has value)
Value of C or D should come in A
For example

A B C D

A Y A
B Y B
N
C Y C
N
D Y D

All times are GMT +1. The time now is 11:15 AM.