How to check multiple cells to return value?
[Closed]
Report
sadhya

Helper 
Helper 
Related:
 How to check multiple cells to return value?
 Compare multiple cells and return other value ✓  Forum  Excel
 If cell contains multiple text then return value ✓  Forum  Excel
 If multiple cells contain text then return value ✓  Forum  Excel
 Check if cell value exists in array vba  HowTo  Excel
 Excel check if cell is percentage ✓  Forum  Excel
2 replies
WD
What if you use:
P1=1,Q1=0 ,R1=0,.... Z1=concatenate(P1,"",Q1,"",R1,...)
P2=1,Q2=if(B2=0,Q1,O2),iR2=if(C2=0,R1,O2)... Z2=concatenate(P2,"",Q2,"",R2,....)
P3=1,Q3=if(B3=0,Q2,O3),iR3=if(C3=0,R2,O3)... Z3=concatenate(P3,"",Q3,"",R3,....)
And use Z as your unique identifier.
Bob 1 1,0,0 100
Fred 2 1,2,0 120
George 3 1,2,3 123
Bill 4 1,4,3 143
This can even be dressed up more by resetting each subsequent value (R,S,T,...) to 0 if the value in Q changes
R2=If(Q2<>Q1,0,if(C2=0,R1,O2)
P1=1,Q1=0 ,R1=0,.... Z1=concatenate(P1,"",Q1,"",R1,...)
P2=1,Q2=if(B2=0,Q1,O2),iR2=if(C2=0,R1,O2)... Z2=concatenate(P2,"",Q2,"",R2,....)
P3=1,Q3=if(B3=0,Q2,O3),iR3=if(C3=0,R2,O3)... Z3=concatenate(P3,"",Q3,"",R3,....)
And use Z as your unique identifier.
Bob 1 1,0,0 100
Fred 2 1,2,0 120
George 3 1,2,3 123
Bill 4 1,4,3 143
This can even be dressed up more by resetting each subsequent value (R,S,T,...) to 0 if the value in Q changes
R2=If(Q2<>Q1,0,if(C2=0,R1,O2)
Sharon
Maybe you can tell me how to set up a formula to add numbers like the following 8/1 and 8/4 and so on in a column.
Probably simple, I just can't figure it out. Thanks
email is
Smiller6623@hotmail.com
Probably simple, I just can't figure it out. Thanks
email is
Smiller6623@hotmail.com