Somendra Misra
Excel Ninja
Wait will return back with something.
Regards,
Regards,
Join IF,MID & V lookup function
- Thread starter Sreehari
- Start date
Somendra Misra
Excel Ninja
Thanks a lot for your time and patients in doing this this for me.
i tried with the file shared.
two points
KR_TF_01_05698120140907 KR_TF_01_056981 20140907
KR_TF_03_05331320140907 KR_TF_03_053313 20140907
KR_TF_02_05331820140907 KR_TF_02_053318 20140907
i tried with the file shared.
two points
- for the below attached file type i am getting an odd output in type field
KR_TF_01_05698120140907 KR_TF_01_056981 20140907
KR_TF_03_05331320140907 KR_TF_03_053313 20140907
KR_TF_02_05331820140907 KR_TF_02_053318 20140907
- I have to working with a file of 1026569 rows( todays count) which may even touch 10.5 Lac . also the working file contain 26+ column with other data’s. I tried the formula shared with the file name alone separately but took 15min appox to complete the task.
- is there any other way to tackle this..
Somendra Misra
Excel Ninja
Somendra Misra
Excel Ninja
@Sreehari
With a max no. of row of 10,48,576 in Excel 2010, you are saying that you are using full rows?
Well I did test on 10,48,000 rows for both type & date (i.e. 20,97,150 formulas) and it took appr. 15 secs. to complete the task. I think there are more connected formulas in your sheet or CF's which are making them further slower.
Regards,
With a max no. of row of 10,48,576 in Excel 2010, you are saying that you are using full rows?
Well I did test on 10,48,000 rows for both type & date (i.e. 20,97,150 formulas) and it took appr. 15 secs. to complete the task. I think there are more connected formulas in your sheet or CF's which are making them further slower.
Regards,
I am back with a new requirement for your support..
I have some digits with ranges are expressed using “&” and “- “. Digits with combination of &&- and &- and && and no & and – are having different meanings as mentioned below.
1050&&-3&-6 --> Means -1050 to 1053 and 1056
1063&-8 --> Means -1063 and 1068
1076 --> 1076 alone
1555&&-9 --> Means 1555 to 1559
4030&-2&&-4&-6&-8&-9 --> Means 4030 and 4032 and 4033 to 4034 and 4036 and 4038 and 4039
956282&&956294 --> Means 956282 to 956294
i need to convert the range into exact digits in excel like for ex: 1555&&-9 needs to be converted to 1555,1556,1557,1558 and 1559. Digit 1555&&-9 in one column against which the digits 1555,1556,1557,1558 and 1559 in next column and in separate rows (one below the other).
I have some digits with ranges are expressed using “&” and “- “. Digits with combination of &&- and &- and && and no & and – are having different meanings as mentioned below.
1050&&-3&-6 --> Means -1050 to 1053 and 1056
1063&-8 --> Means -1063 and 1068
1076 --> 1076 alone
1555&&-9 --> Means 1555 to 1559
4030&-2&&-4&-6&-8&-9 --> Means 4030 and 4032 and 4033 to 4034 and 4036 and 4038 and 4039
956282&&956294 --> Means 956282 to 956294
i need to convert the range into exact digits in excel like for ex: 1555&&-9 needs to be converted to 1555,1556,1557,1558 and 1559. Digit 1555&&-9 in one column against which the digits 1555,1556,1557,1558 and 1559 in next column and in separate rows (one below the other).
Somendra Misra
Excel Ninja
Hi Sreehari,
Well I will ask you to upload a sample file with where will the data dump and expected output out of it. At first go I don't think it is possible through formula and we may need to take the help of VBA in this.
Regards,
Well I will ask you to upload a sample file with where will the data dump and expected output out of it. At first go I don't think it is possible through formula and we may need to take the help of VBA in this.
Regards,
sample file uploaded as required .
this XL have 2 sheets ,sheet1 is input file and sheet2 expected output.
Alos one more point i missed in my last post is , the input file contains value 0 and 1 in column C under header "AL" agansit which the values in column G "NDEST"varies ,these values need to be captured under columns option 1 for AL-0 and option 2 for AL-1 .
As rightly mentioned by you ,we may need to take VBA in this.
one small doubt, is there any difference between our traditional VBA and Excel VBA programs or both are same, because i can see wook sheet ref. cell ref. are considered in our last UDF...
this XL have 2 sheets ,sheet1 is input file and sheet2 expected output.
Alos one more point i missed in my last post is , the input file contains value 0 and 1 in column C under header "AL" agansit which the values in column G "NDEST"varies ,these values need to be captured under columns option 1 for AL-0 and option 2 for AL-1 .
As rightly mentioned by you ,we may need to take VBA in this.
one small doubt, is there any difference between our traditional VBA and Excel VBA programs or both are same, because i can see wook sheet ref. cell ref. are considered in our last UDF...
