Dear Forum
Master and Excel Expert
I need your help please.
I have dataset
https://drive.google.com/open?id=0BwUNg-SBvMSwRnFSTkZTczJyakk
How to set the formula on Column H I J K ?
Your help is very appreciate.
Thank you
=====
On text format like this :
ORIGINAL:
=======================
CASE_ID,1ST ,2ND ,3RD ,4TH
1,1,,4,4
2,2,1,,4
3,6,10,7,8
4,,3,5,5
5,,6,4,4
6,,,4,5
7,,,9,6
8,8,7,6,10
9,7,2,4,6
10,8,,,3
11,4,,,9
12,9,3,7,1
13,,,,2
14,,,,2
15,7,2,10,9
16,2,10,4,9
17,4,8,7,5
18,,,,2
19,,,,7
20,7,5,10,10
==================
AFTER:
CASE_ID,1ST ,2ND ,3RD ,4TH
1,1,4,4
2,2,1,4
3,6,10,7,8
4,3,5,5
5,6,4,4
6,4,5
7,9,6
8,8,7,6,10
9,7,2,4,6
10,8,3
11,4,9
12,9,3,7,1
13,2
14,2
15,7,2,10,9
16,2,10,4,9
17,4,8,7,5
18,2
19,7
20,7,5,10,10
Manggo
Master and Excel Expert
I need your help please.
I have dataset
https://drive.google.com/open?id=0BwUNg-SBvMSwRnFSTkZTczJyakk
How to set the formula on Column H I J K ?
Your help is very appreciate.
Thank you
=====
On text format like this :
ORIGINAL:
=======================
CASE_ID,1ST ,2ND ,3RD ,4TH
1,1,,4,4
2,2,1,,4
3,6,10,7,8
4,,3,5,5
5,,6,4,4
6,,,4,5
7,,,9,6
8,8,7,6,10
9,7,2,4,6
10,8,,,3
11,4,,,9
12,9,3,7,1
13,,,,2
14,,,,2
15,7,2,10,9
16,2,10,4,9
17,4,8,7,5
18,,,,2
19,,,,7
20,7,5,10,10
==================
AFTER:
CASE_ID,1ST ,2ND ,3RD ,4TH
1,1,4,4
2,2,1,4
3,6,10,7,8
4,3,5,5
5,6,4,4
6,4,5
7,9,6
8,8,7,6,10
9,7,2,4,6
10,8,3
11,4,9
12,9,3,7,1
13,2
14,2
15,7,2,10,9
16,2,10,4,9
17,4,8,7,5
18,2
19,7
20,7,5,10,10
Manggo