vijaychennai
Board Regular
- Joined
- Dec 7, 2009
- Messages
- 239
Hello all,
I have exel file in the below format.
Answer :
I required split....
I have exel file in the below format.
Excel Workbook | |||
---|---|---|---|
A | |||
1 | Hours | ||
2 | 2 | ||
3 | 3 | ||
4 | 4 | ||
5 | 4 | ||
6 | 5 | ||
7 | 6 | ||
8 | 29 | ||
9 | 30 | ||
Sheet1 |
Answer :
Excel Workbook | ||||
---|---|---|---|---|
A | B | |||
1 | Hours | Answer | ||
2 | 2 | |||
3 | 3 | |||
4 | 4 | |||
5 | 4 | |||
6 | 4.1 | 4 to 6 | ||
7 | 6 | 4 to 6 | ||
8 | 29 | 28 to 29 | ||
9 | 30 | 29 to 30 | ||
Sheet1 |
I required split....