Search results

Dears, I need to find out how i can compare two Cells having different strings to give result which is common in both; like A2: 05-08,16-17 B2: 00-13,16-17,22-23 Common in both cells: 16-17 How it is possible pragmatically? Kindly help Regards, Muhammad Faisal

Hello, Is it possible to define Static Range of certain values inside the VB Script; Example Dim Rng as range Set Rng = [0,10,20,30,40,50,60,70,80,90,100] Means instead of setting range location from the sheet, giving fix vales regards,

Dear, Sorry to bother you; I need certain more requirements; 1. In earlier file, there was only 1 column with values but now i need to get the time for 02 columns (B,C). B will be True, C will be False and vice versa. 2. Time range is a fix values, how to fix permanent range inside script...

Ok bro Thanks

Dear, I have certain files in a folder and i am collecting certain data from each file into a Master file. Every thing is working fine but data is not being copied DATEWISE. What i need is, script copy data from all files but Datewise not randomly. Kindly guide, Regards

Dear, WORKSHEETFUNCTION.IIF(iserror(statement),"Error","Clear") Above statement is also not working in vb script, any clue. Regards,

Thanks bro, It worked perfect. Regards,

Dear, Thanks for your help. But i need output slightly in different manner. I have updated the file you shared with my required format. Hopefully, you will sort out. Regards,

Dear, Thanks for the help. How to use worksheetfunction.iferror function inside vb script or worksheetfunction.iif function. I want to use any of above because both are aingle line functions. Can u plz guide me if i can use anyone of above, it will be a great help. Regards,

Dear, I am doing certain calcuations in vba script but getting error "Divide by Zero". I tried to use Worksheetfunction.Iferror but no use. Any one can guide me how to encounter this problem? Scenario is as; I have two Columns A & B; Value of A is divided by value of B but when Value of B is...

Dear, I have a file with 02 columns, 1. Time 2. Status I need to get the time when the Status is "FALSE". Example, 02:00:00 TRUE 03:00:00 TRUE 04:00:00 FALSE 05:00:00 FALSE 06:00:00 TRUE 07:00:00 TRUE 08:00:00 FALSE 09:00:00 FALSE 10:00:00 FALSE 11:00:00 FALSE...

Dear, Thanks a lot for help and support... Regards,

Dear, Thanks for your help & support. Can u please explain the Function block you made? When i try to change the range, it is giving me error. Moreover, it is possible to make the function dynamic (Means if i delete the row in range or add any new row in range, it will update the function...

Dear, Please find attached. I tried to give value as expected in Column E based on Column C value when it increasing or when it remains same to calculate no. of hrs Hopefully, i explained Regards,

Thanks dear, But i need result in some different way. I need to calculate 1. No. of hours when Column C (FT1003) value increased than previous value. 2. No. of hours when Column C (FT1003) value decreased than previous value. regards, Muhammad Faisal

Dear, Please find attached file and sorry i forget to attach before Regards,

Dear, I am attaching a file which have certain readings every hour daily. I want to find out how to calculate no of hours when 1. FT1003 (Column C in SO2 Sheet) value was increasing 2. FT1003 (Column C in SO2 Sheet) value was not increasing 3. P101 (Column D in SO2 Sheet) value was "TRUE" 4...

Dear, I have certain files in a folder with data; Each file has a certain date and hourly data. My objective is to collect all the data from all the files and merge into a "Plant Record File". Plant Record File has datewise complete data which is copied from each file when Clicked on UPDATE...

Dear, Thanks for Help. but maybe it will not solve my issue; Following is the code which i am using to single file... ''code Start here Private Sub Download() Dim myOriginalURL As String Dim myURL As String Dim FileID As String Dim Dt As String Dim xmlhttp...

Really Thanks dear...