Recent content by sdsurzh

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