Hi,
New here and new to slightly more complex Formulas in Excel, I keep struggling with following task.
I need to retrieve all cells / values from column A for which there is data >0 in at least one of the columns B, C and D.
Rows can look as follows:
(A) (B) (C) (D)
ExA 0 0 6
ExB 5 5 0
ExC 0 0 0
ExD 1 8 2
ExE 0 0 0
and so on
For above example I would like to retrieve ExA, ExB, ExD. Not ExC and ExE since they have 0 in all columns.
Have tried some combinations of INDEX and MATCH using OR and IF functions but I can't seem to get it right...
What I have tried (examples):
=INDEX($A$4:$A$50; MATCH(0; OR($B$4:$B$50=0;$C$4:$C$50=0;$D$4:$D$50=0)))
=INDEX($A$4:$A$50; MATCH(0; IF($B$4:$B$50<>0+$C$4:$C$50<>0+$D$4:$D$50<>0; 0; 1); 0))
=INDEX($A$4:$A$50; MATCH(0; IF(OR($B$4:$B$50<>0;$C$4:$C$50<>0;$D$4:$D$50<>0); 0; 1); 0))
Thanks!!
W.
Bookmarks