=IF(A1=FALSE,"-",IF(OFFSET(A1,-1,0)=FALSE,"No","-"))
Brillaint that worked - Anyway to simply this - its going to go down approx 10k rows? dont wont to slow the document down.
HI Guys the data is in row J2 onwards and the formula will be in K2 onwards - How would I rearrange this formula - I have changed the cells but it doesn't seem to work?
Excel 2010 | ||||
---|---|---|---|---|
J | K | |||
1 | ||||
2 | FALSE | - | ||
3 | 0 | No | ||
4 | FALSE | - | ||
5 | 0 | No | ||
6 | 0 | - | ||
7 | 0 | - | ||
8 | FALSE | - | ||
9 | - | No | ||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
K2 | =IF(J2=FALSE,"-",IF(INDEX(J:J,ROW()-1)=FALSE,"No","-")) |