Recent content by arshad_masud

Thanks

No it's an Add-in which is an advance version of auditing tools

Hi, I am using office 2010 and Explode add-in works fine. But when i use office 2013 it only works in the file which you currently work on and does not go the other linked files. Is there any solution. Thanks in advance.

Really grateful for your valuable guidance

Hi I have a problem in an excel file. It shows a link from other file but i can't find it. I have tried to break link but failed. Moreover, i also tried to find it in Name series but there is nothing . Can any body help me. Thanks in advance

Dear NARAYANK991 It worked. Really grateful :)

Dear NARAYANK991 Thanks for your time and effort. But the problem is that all the data has not the same lenght, otherwise i would have used "left, right or mid" formula. Neither i could use Convert Text to Columns facility due to the issue mention above. Thanks

Hi I have huge data extracted from ERP. There are spaces at the start of the data and even at the end. I tried to use "Trim" & "Clean" function but failed. Can some body help me. Here is one example of data "         310101:Share capital " Thanks in advance

Thanks Hui

Dear Hui How can we get sum of figures horizontally by using sum offset formula. e.g. i have this kind of data Months Jan Feb Mar Apr May 100 200 120 50 340 I know the use of this formula if the data is Verticle. Thanks in advance.

Hui Your are great. Thanks

Hi I have an excel file which contains some links wich do not exist. I tried to break these links but fail. Can any one help in fixing the problem. Thanks in advance.

Thanks Luke, Vijay & Hui I really appreciate your efforts. I think i should use Hui's earlier guidance i.e. =if(D10>100, "Validity period Expires","")as it is simple and moreover i dont' know anything about VB. Thanks Pal

Thanks Vijay Pl guide me if data validation (which you mentioned above) can work on any resultant figure. Thanks

Thanks Hui But i need popup. I tried data validation option but it does not work :) Thanks