Search results

Dear Yousuf, I have approached Microsoft Tech community and found a suitable, effective & efficient solution to the problem . It is resolved through solver Add-in. It has an limit of 200 variables to check and this limit is understandable File is attached for your reference please. Thanks...

Dear Yousuf MS Excel has many possibilities for any requirement to complete. I noted the requirement details for running this code! However, I have execute the code for two hours and it was went without interruption and now I break it. Will run it again while leaving the office. Next day...

Dear Yousuf, After updating the code, still VBA code is not filtering records correctly. Please see attached file in which I have given three different ranges to filter. After running the code, output total is not same as required and difference is too much in thousands. If there was small...

In attached file we give three different ranges and code is not running. Please check and reply.

Dear Mr. Yousuf Thank you so much for your work. I was extremely pleased to receive this reply from you, and I appreciate the your hard work. I must admit that was was not possible for me to derive the formula or VBA code. Please see below my comments. A little more work on the code can...

Method 'count' of object 'range' failed. This is the error, I am currently facing. Even though I have make to range to 40 lines only. Till 30 lines its working fine.

Dear Mr. Yousuf, thanks for your reply. I feel pride as I m in contact with the people who ar part of STEM and respect and integrity. Further, I have attached the file with real data and range is updated in vba code but facing with an error of range failed. Kindly check this and advise. Note...

Hi John I need to filter records based on a value. Records to be filter are around 200 and sum of few records will bring required total value. Example data: 2966.84 217.36 7670.51 19167.4 9357.28 2646.18 1412.78 108.68 434.7 I need to filter out records from above list...

Dear All, I came across this blog through Md. Abdul Kader posts. He is doing good. His method to describe and solve the issue is easy to understand. 18,541.78 7,305.39 10,388.17 2,990.00 My requirement is to filter records based on a value 13378.17 This value is total of last two...