Related:

- How to check multiple cells to return value?
- Check soft - Download - Finance
- How to check pc power consumption in windows 11 - Guide
- How to check if someone is spying on my whatsapp - Guide
- How to check ps4 controller battery - Guide
- How to delete multiple files on mac - Guide

## 2 responses

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