Will someone, please explain what the formula in Col I does.
Excel 2007
Excel Workbook | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
2 | 3620 | 065154 | 0 | 6 | 5 | 1 | 5 | 4 | 0.3 | ||
3 | 3619 | 291304 | 2 | 9 | 1 | 3 | 0 | 4 | 0.1 | ||
4 | 3618 | 236341 | 2 | 3 | 6 | 3 | 4 | 1 | 0.6 | ||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
C2 | =IF($A$1="","",MID(TEXT($B2,"000000"),1,1)+0) | |
C3 | =IF($A$1="","",MID(TEXT($B3,"000000"),1,1)+0) | |
C4 | =IF($A$1="","",MID(TEXT($B4,"000000"),1,1)+0) | |
D2 | =IF($A$1="","",MID(TEXT($B2,"000000"),2,1)+0) | |
D3 | =IF($A$1="","",MID(TEXT($B3,"000000"),2,1)+0) | |
D4 | =IF($A$1="","",MID(TEXT($B4,"000000"),2,1)+0) | |
E2 | =IF($A$1="","",MID(TEXT($B2,"000000"),3,1)+0) | |
E3 | =IF($A$1="","",MID(TEXT($B3,"000000"),3,1)+0) | |
E4 | =IF($A$1="","",MID(TEXT($B4,"000000"),3,1)+0) | |
F2 | =IF($A$1="","",MID(TEXT($B2,"000000"),4,1)+0) | |
F3 | =IF($A$1="","",MID(TEXT($B3,"000000"),4,1)+0) | |
F4 | =IF($A$1="","",MID(TEXT($B4,"000000"),4,1)+0) | |
G2 | =IF($A$1="","",MID(TEXT($B2,"000000"),5,1)+0) | |
G3 | =IF($A$1="","",MID(TEXT($B3,"000000"),5,1)+0) | |
G4 | =IF($A$1="","",MID(TEXT($B4,"000000"),5,1)+0) | |
H2 | =IF($A$1="","",MID(TEXT($B2,"000000"),6,1)+0) | |
H3 | =IF($A$1="","",MID(TEXT($B3,"000000"),6,1)+0) | |
H4 | =IF($A$1="","",MID(TEXT($B4,"000000"),6,1)+0) | |
I2 | =IF(C2="","",(MATCH(C2,C3:C1337,0)/($A3/COUNTIF(C3:C1337,C2)))) | |
I3 | =IF(C3="","",(MATCH(C3,C4:C1338,0)/($A4/COUNTIF(C4:C1338,C3)))) | |
I4 | =IF(C4="","",(MATCH(C4,C5:C1339,0)/($A5/COUNTIF(C5:C1339,C4)))) |