Search results

Hi, You can use advanced filter option. please refer the below links for further inforamtion. http://www.excel-easy.com/examples/advanced-filter.html http://www.contextures.com/xladvfilter01.html Regards, SK

also you can use match index using array =IFERROR(INDEX('Raw data'!$A$1:$E$17665,MATCH(1,('Raw data'!$A$1:$A$17665=$A3)*('Raw data'!$D$1:$D$17655=C$2),0),5),0) Use Ctrl + Shift + Enter

=SUMIFS('Raw data'!$E:$E,'Raw data'!$A:$A,'Question sheet'!$A3,'Raw data'!$D:$D,'Question sheet'!C$2) try this

=A1-(5.5/24) try this

=INDEX($A$2:$A$11,MIN(IF(C2:C11="Yes",B2:B11))) Try this

Hi Shabbo, to my knowledge if you want to insert a folder you can use hyperlink. But through insert object option you can't. Regards, SK

To do it, you need to click on the Insert tab in the ribbon, and then click Object. This will open a dialog window allowing you to set the object to insert. Click on the Create from file tab to insert your specific file. Click Browse button and select the file you are looking to insert. There...

Hi, Let say in A1 and B1 you have now apply the below formula in A2 and drag to B2 =EDATE(A1,0)-1 Regards, SK

Hi Narayan, You have shared your knowledge to this forum and congratulation for reaching 4000. Keeping rocking.... Thanks, Suresh Kumar S

SirJB7, Congtz. Thanks, SK

Thanks Nazmul Muneer,Hui,bobhc & Deb may be my friend could have opened by any of your idea.

Hi pirduh, Please use SUMIFS Formula you will get the following output. Africa 0 Asia 15 Antarctica 0 Australia 8 Europe 42 North America 35 South America 0 Thanks, SK

Hi Rahul, I am sorry my office explore not allowing any download. Thanks, SK

Hi Rahu, Unable to download please proivde some other link. (2shared) Thanks, SK

Hi, Freeze the cells using $ for example if C2 = J2 Change to $J$2. Thanks, SK

Dear Hui, One of my friend told me that there is shortcut or setting available in outlook 2010 which open the excel. So just want to know. I am sorry if asked wrong question. Thanks, SK

Thanks Hui. does any other way in outlook 2010

Hi, Is it possible to open excel from outlook. Thanks, SK

Hi, Please refer the below link and minus the dates it will work. http://chandoo.org/wp/2010/03/23/text-to-date-convertion/ Thanks, SK

Glad to slove your problem and always welcome. Moreover the above code is a recorded one.

Hi Prem, Select all the cells which contains the data in Column A and run the macro. Suppose if you have data from A1 to A6 then select A1 to A6 and run the code Thanks, SK

Hi Parba, instead of YY use YYYY. Thanks, SK

Hi, Please use the below code. This is a recorded code so you should have the date in A column and slect all the date and run the macro. This macro blindly work with - and , Sub Macro6() Selection.TextToColumns Destination:=Range("B1"), DataType:=xlDelimited, _...

Hi, 1.select the date and press control+1(from top number) then go to custom and paste dd-mmm-yy. 2. suppose your date in A1 the paste the formula in B1 =TEXT(A1,"dd-mmm-yy") Thanks, SK

Marc thanks for that code.