Search results

Hey dotchieJack, Great job done!. It would be great if you add "notification or to do before using this tool" like youo have mentioned below. Just an suggestion.

Littler confused, How did you calculate 102%? it should be -4%. and our formula there are some brackets error, see rectified one =IF(MIN(F25,G25)<=0,IF((G25-F25)>0,"P","N"),(G25/F25)-1) can you upload sample sheet with required output.

You can add formula in IF condition logical_test part like below if (or(and(1st__formula,2nd__formula),and(1st__formula,2nd__formula)),true,false) bold one is old rules. As suggest by @Khalid, you can also remove IF condition as there is no need to apply if. formula without if...

Yeah sure!.

Do you have English version? Thanks!.

Hey candybg, It would be great if you can upload solved sheet. :) [ quote="candybg, post: 183652, member: 26146"]The copy I downloaded (above) seemed to indicate you needed help with the CLOSE chart - specifically getting the dates to fill across the horizontal/bottom axis. I went to SELECT...

Hi Baama, I am little confused What and why you want to do this. As far I understand, In excel you can not add multiple "Horizontal axis" range. so logically you can not do this but if you really want to achieve this, you can make 2charts "One over the other". Below, I have changed the...

Based on subject line without opening your attachment. Just divide by 60 minutes = seconds / 60

Hope you need this - if(and(formula1=1 and formula2=1),TRUE,FALSE) In above formula1 = if(iserror(search(B1,"XXXX", 1),"",1) and Formula2 = VLOOKUP (A1,TABLE AARAY, 12,0)

Hey Jabawocky, PFA the sample sheet with macro and simple conditional formatting

Hey Rahul, have you discovered this on Google or Form search option? would request you to please search this on google, if after that any issue confusion / query then please let us know...

Hey sasuke, See if this is ok, I have used help column to do this. (please check sheet4 for output and sheet1 for raw data with helper column)

Hey All, Happy Independence Day :)...

please upload sample file.

Hey Ecel Dumbo, There are many ways to do this but first you need to create a table for tax-logic as excel can not read from string like "$39,540 for the first $2,947,000, then 2% over that " thn you can apply either IF condition or lookup. table should be look like - col1 col2 0...

Why you need this thru VBA? you can use pivot table or sum if function

this is very normal requirement and we discussed this many times on this group. Please see below url, also on top right side search functionality is available to search anything http://chandoo.org/forum/threads/concatenate-multiple-cells-into-one-cell.30698/#post-182970

hEY HanSam, Hope below url help you http://chandoo.org/forum/threads/pivot-slicer-to-work-for-pivot-tables-based-on-two-sets-of-data.30594/#post-182509

Hope you need like this.

Thanks a ton Narayan,

Why you cant upload sample with required output to get proper response in one go.

There are many service providers who sends sms thru there applications or excel addin, please search on google for the same. below are some urls http://www.smsco.it/tomcat/en/sms_tutorials/sms_from_excel.jsp http://www.activexperts.com/xmstoolkit/howto/gsm/vba/

Thanks Mate!.. But Is there any way to do this thru VBA only

Some explanation below to help you to understand. INDIRECT function is helps to convert text (non range) value to range. Why Sumproduct function? - I have used sumproduct function because sumif function will return 4 values (check your self - just select sumif part formula and press F9...

Dear Masters, I have search and not able to understand "How to Add Custom Tab or Ribbon using VBA". http://www.thespreadsheetguru.com/blog/step-by-step-instructions-create-first-excel-ribbon-vba-addin http://www.contextures.com/excelribbonaddcustomtab.html Can anyone guide me to make my...