Related:

- How to check multiple cells to return value?
- Compare multiple cells and return other value ✓ - Forum - Excel
- If multiple cells contain text then return value ✓ - Forum - Excel
- If cell contains multiple text then return value ✓ - Forum - Excel
- If cell contains multiple text how to add other cell value? ✓ - Forum - Excel
- If a cell contains any text then add a value ✓ - Forum - Excel

## 2 replies

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 1-0-0

Fred 2 1,2,0 1-2-0

George 3 1,2,3 1-2-3

Bill 4 1,4,3 1-4-3

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 1-0-0

Fred 2 1,2,0 1-2-0

George 3 1,2,3 1-2-3

Bill 4 1,4,3 1-4-3

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)

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