Search results

Wow... I really need to learn excel from the basic again. I like your non array approach.

My gosh.... I've been trying to do that for an hour already... never crosses my mind to add the IF directly in an IF logical. Thanks a lot Narayank991..

I want to have both columns being summed up with just one formula (without using sumifs() + sumifs()) EDIT: adding subtotal columns is a nice solution, but is it possible to use a formula?

[SOLVED] Dear All, I have been trying to modify Narayank991 solution to my previous problem to make -sumifs- sums for more than one columns to no avail. Can anyone propose a solution for this? Thanks in advance.

thanks Narayank, took me several minutes to understand it....

I am not sure if I understand. Are you saying that I have to create 2 cell for the result? I attach sample workbook. Thank you

[SOLVED] Dear all, Can anyone suggest on how best to solve this problem. Situation: I need to use sumif(s) base on a validation list which contain "State"; "Private"; "State & Private". It is not a problem with only option "State" or "Private", but how do you make up for "State & Private" in...

Thanks Hui, I will try it. I do have some events. I am still trying to figure it out since I cannot reproduce the problem anymore. I will post a sample after I fix the indentation and all. @SirJb7, it is basically just copy pasting Chart & Table from Excel to Powerpoint.

@SirJB7 : It is in normal module. Usually I just trigger it manually (F5 or attach the macro to a shape)... I will try to do what Marc L suggest, if it does not work, I will upload the file but it is quite a mess. @Marc L : Thank you for your suggestion. I will try to do that. EDIT : Somehow...

Found someone with the same problems as mine at http://stackoverflow.com/questions/11574783/stepping-through-f8-code-suddenly-executes-all-code still looking for the app that might cause the problem. Has anyone else experience this

Hi all, I am trying to modify part of my macro and while i am trying to debug it using F8, at some line its start running. The macro it self is just a simple copy paste from excel to powerpoint (I am using early binding). Here is the part where the macro start running (Right after the paste...

Sorry for double posting, I cannot edit the 1st post. I am not a native English speaker, apologise if my question sounds rude. Regards

Dear All, I just tried Office 2013 and when I tried to copy Excel chart from Excel 2010 workbook to Powerpoint 2013, the color changed. I noticed that it is also change if I copied it down to a new (2013) workbook. I've tried to copy all the worksheet to a new 2013 workbook, change all...

My goodnes, I just realized I have asked wrongly. Narayank991 and you must assume that I'm trying to make 18 point 450 into 18 K while I meant making 18 thousand and 450 into 18 K. So sorry for that. I just wasted both of your time.

That is great Hui. It works now... The number format is 'strange'. How/Where do you come up with that? *BTW, I change the Z48 and so on back to =TEXT(T2;"#,##0") and it still works. Regards

That is exactly what I just did and I even add 1 decimal. Am I missing something? Just to be sure... Kalteng (Guru as variable) using "#.0 K" shows 29940,0 K, it should be 29,9 K

That is weird. I just did that.. and it is still the same..

@Hui, thank you (i wish my superior had the same view as you ^^). what I like to achieve is 6.6 K and I think Narayank991 post answer that. @Narayank991, Thank you... I haven't though of that. I'll try to revise it. It's an old file, kinda hard to remember. Kudos to both of you. Best regards

I'll upload the workbook in a moment (after i read how ^^).. thank you for the help so far.. here is the workbook http://sdrv.ms/Yp4gsU the code is in "module1" and please do not try to change the "NILAI" as it will cause error since before I was using k as variant. You can change...

Hi, I tried that..and it is still 18.450 K not 18,5 K Regards

Hi Hui, I been wondering about that. k is variant data type. I used k = Sheets("analyze").Range("x46").Value When I highlight k using STEP is shows "18450,0". I think this is the problem. Any idea why? I tried changing k into Long type but it is still the same. here is part of the code...

Hi, sorry to revive old thread I am not into against the idea of of using DB as the data source, but have anyone really tried to use DB to store large amount of data. For instance, I'm dealing with around 2M rows of data and it takes about 1/2 Hour just to run the query in Access. I have a...

Thanks Hui & Narayank991. Sorry I had to leave yesterday That is strange. What I did was z = format(k,"#.0 K") Activesheet.Shapes("Rectangle 1").TextFrame2.TextRange.Text = z So far, I have succeded in other formating, what is left is this one. (I cannot reach my laptop right now, I'll...

Thanks Narayank991 I tried it but it came out as 18450,0 K... I am using it as text in a shape.... would that affect it?

Dear All Have anyone tried scaling in number format using VBA function FORMAT... I tried to make 18.450 into 18.5 K using z = format(z,"#.#0, ""K""") but failed... the best thing i can achieve is 18 K. I tried the same formatting in worksheet using text function and it works just fine. Can...