Hi guys,
I am a kind of new in Excel and I am seeking some help to solve a problem on one of my sheets.
Short description:
- 6 Columns A to F
- My reference data is on column B
- Trigger data is on column E (TRUE, FALSE)
- Expected results in colum F (TRUE, FALSE)
- Columns A, C and D are not important
The data value in column B can be a duplicate: e.g. ABC11-0001 can be found 10 times.
The value in column E has is status value (TRUE or FALSE) entered manually.
Problem:
In column F I would like to have a formula on which if any of the value on column F is TRUE, the corresponding value of column B in any rows will also be TRUE.
Example below and encolsed file.
Col.A Col.B ... Col.E Col.F
# Data 1 Status Value from Formula
43 ABC11-0042 ... TRUE TRUE
44 ABC11-0042 ... TRUE TRUE
45 ABC11-0043 ... FALSE FALSE
46 ABC11-0043 ... FALSE FALSE
47 ABC11-0062 ... FALSE FALSE
48 ABC11-0063 ... FALSE FALSE
49 ABC11-0063 ... FALSE FALSE
50 ABC11-0063 ... FALSE FALSE
51 ABC11-0064 ... FALSE TRUE
52 ABC11-0064 ... TRUE TRUE
53 ABC11-0064 ... TRUE TRUE
54 ABC11-0064 ... FALSE TRUE
55 ABC11-0064 ... FALSE TRUE
56 ABC11-0064 ... FALSE TRUE
57 ABC11-0064 ... FALSE TRUE
Can anyone help me out?
I have tried to understand INDEX, MATCH and INDIRECT without success ;-(((
Many thanks for your help.
I am a kind of new in Excel and I am seeking some help to solve a problem on one of my sheets.
Short description:
- 6 Columns A to F
- My reference data is on column B
- Trigger data is on column E (TRUE, FALSE)
- Expected results in colum F (TRUE, FALSE)
- Columns A, C and D are not important
The data value in column B can be a duplicate: e.g. ABC11-0001 can be found 10 times.
The value in column E has is status value (TRUE or FALSE) entered manually.
Problem:
In column F I would like to have a formula on which if any of the value on column F is TRUE, the corresponding value of column B in any rows will also be TRUE.
Example below and encolsed file.
Col.A Col.B ... Col.E Col.F
# Data 1 Status Value from Formula
43 ABC11-0042 ... TRUE TRUE
44 ABC11-0042 ... TRUE TRUE
45 ABC11-0043 ... FALSE FALSE
46 ABC11-0043 ... FALSE FALSE
47 ABC11-0062 ... FALSE FALSE
48 ABC11-0063 ... FALSE FALSE
49 ABC11-0063 ... FALSE FALSE
50 ABC11-0063 ... FALSE FALSE
51 ABC11-0064 ... FALSE TRUE
52 ABC11-0064 ... TRUE TRUE
53 ABC11-0064 ... TRUE TRUE
54 ABC11-0064 ... FALSE TRUE
55 ABC11-0064 ... FALSE TRUE
56 ABC11-0064 ... FALSE TRUE
57 ABC11-0064 ... FALSE TRUE
Can anyone help me out?
I have tried to understand INDEX, MATCH and INDIRECT without success ;-(((
Many thanks for your help.