Re: $$Excel-Macros$$ How to makeing a check box

if i tick then wanna Yes and no tick then No Warm Regards, Dhaval Shah M) 98240 35253 *E-mail : todhavals...@gmail.com todhavals...@gmail.com* On Mon, Apr 13, 2015 at 12:07 PM, Dhaval Shah todhavals...@gmail.com wrote: pls go through the attechment i put a checkbox in my file but i cant

Re: $$Excel-Macros$$ Re: How to makeing a check box

Thanks Dear :) Warm Regards, Dhaval Shah M) 98240 35253 *E-mail : todhavals...@gmail.com todhavals...@gmail.com* On Mon, Apr 13, 2015 at 1:49 PM, TAWHID tawhid.ha...@gmail.com wrote: Hi Dhaval Shah, See the attached file. I Have put few of them . You can copy paste and rename as you

$$Excel-Macros$$ Formula required

PFA Warm Regards, Dhaval Shah M) 98240 35253 *E-mail : todhavals...@gmail.com todhavals...@gmail.com* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM

Re: $$Excel-Macros$$ Re: Help Needed

ANY OTHER WAY TO USE OPTION OF PIVOT TABLE ?? Warm Regards, Dhaval Shah M) 98240 35253 *E-mail : todhavals...@gmail.com todhavals...@gmail.com* On Mon, Mar 2, 2015 at 3:52 PM, Dhaval Shah todhavals...@gmail.com wrote: THANKS DEAR FOR U R EFFORTS BUT ITS NOT USE FULL TO ME BECAUSE WHILE I

Re: $$Excel-Macros$$ Re: Help Needed

THANKS DEAR FOR U R EFFORTS BUT ITS NOT USE FULL TO ME BECAUSE WHILE I UPDATE ITS PASTE WRONGLY Warm Regards, Dhaval Shah M) 98240 35253 *E-mail : todhavals...@gmail.com todhavals...@gmail.com* On Mon, Mar 2, 2015 at 12:24 AM, michael vinoth michaelvino...@gmail.com wrote: Hi Dhaval Shah

$$Excel-Macros$$ Help Needed

, Dhaval Shah M) 98240 35253 *E-mail : todhavals...@gmail.com todhavals...@gmail.com* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise

Re: $$Excel-Macros$$ is it any easy way to import DAT file to Excel

thanks vaibhav :) Warm Regards, Dhaval Shah M) 98240 35253 *E-mail : todhavals...@gmail.com todhavals...@gmail.com* On Tue, Jul 15, 2014 at 7:43 PM, Vaibhav Joshi v...@vabs.in wrote: check this too... http://www.marketcalls.in/spreadsheet/how-to-extract-data-from-nseinda-com-using

Re: $$Excel-Macros$$ Help Needed

fyi Warm Regards, Dhaval Shah M) 98240 35253 *E-mail : todhavals...@gmail.com todhavals...@gmail.com* On Tue, Jun 17, 2014 at 12:51 PM, Rakesh kumar rakesh.apt...@gmail.com wrote: Hi Guys, I want to use formula on pivot table data. Kindly help me. -- Thanks £ Regards Rakesh Kumar

Re: $$Excel-Macros$$ wanna halp in conditional icon set

*To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ wanna halp in conditional icon set PFA On Fri, Jan 17, 2014 at 10:04 PM, Dhaval Shah ( Ahd ) todhavals...@gmail.com wrote: Hello friends I want help in conditional icon set … pls refer attached sheet

RE: $$Excel-Macros$$ how to reduce file size

formatting merging. See the file where size is half now. Thanks. On Tue, Jan 14, 2014 at 7:44 AM, Dhaval Shah todhavals...@gmail.com wrote: Friends i have a file with v limited data in file automatic my file size rise to 7.3 mb from 689 kb any suggestions ?? -- Are you =EXP(E:RT

Re: $$Excel-Macros$$ need chart help

Thanks Waseem :) On Mon, Jan 6, 2014 at 8:33 PM, Waseem Saifi waseemsa...@gmail.com wrote: Perhaps you are looking for this. see attachment. regards, Waseem Saifi On 1/6/14, Dhaval Shah ( Ahd ) todhavals...@gmail.com wrote: Guys I need chart help Pls refer attached sheet

RE: $$Excel-Macros$$ NEED FORMULA HELP

, Cartik On Tue, Dec 24, 2013 at 10:57 AM, Dhaval Shah todhavals...@gmail.com wrote: hello, i want a formula help for my here with attached file pls refer my sheet thanks Dhaval Shah -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join

$$Excel-Macros$$ Need formula help

Want to choss Day only from date pls refer attachment Thanks Dhaval Shah -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use

RE: $$Excel-Macros$$ Need formula help

@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Dhaval Shah ( Ahd ) Sent: Thursday, November 28, 2013 5:44 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need formula help Want to choss Day only from date pls refer attachment Thanks Dhaval Shah

Re: $$Excel-Macros$$ Need help

Thanks Ravinder :) On Mon, Jul 22, 2013 at 4:05 PM, ravinder negi ravi_colw...@yahoo.comwrote: PFA.. -- *From:* Dhaval Shah todhavals...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Monday, July 22, 2013 3:46 PM *Subject:* $$Excel-Macros$$ Need

Re: $$Excel-Macros$$ Re: Need expert advise for multipal Selection

Lalit Sir didt work can u send me the sample file Thanks Dhaval Shah 079 - 40055253 On Wed, Apr 3, 2013 at 12:25 PM, Lalit Mohan Pandey mohan.pande...@gmail.com wrote: Hi Dhaval, Copy below formula at cell address C11 and confirm it with CSE *=MAX(($B$2:$B$68=$S$10)*($A$2:$A$68 = FUTSTK

Re: $$Excel-Macros$$ Re: Need expert advise for multipal Selection

workbook and its working. On Wednesday, 3 April 2013 12:39:39 UTC+5:30, Dhaval Shah wrote: Lalit Sir didt work can u send me the sample file Thanks Dhaval Shah 079 - 40055253 On Wed, Apr 3, 2013 at 12:25 PM, Lalit Mohan Pandey mohan.p...@gmail.com wrote: Hi Dhaval, Copy below formula

Re: $$Excel-Macros$$ Re: Need expert advise for multipal Selection

Dear Thanks for u r prompt reply but out put is not as per my requirement pls check the reference sheet On Tue, Apr 2, 2013 at 10:49 AM, xlstime xlst...@gmail.com wrote: Hi Dhaval, dhaval shah (1).xlsxhttps://docs.google.com/file/d/0B4LBSzxr1QTiVjZoYkRneFFUY1k/edit?usp=drive_web PFA

$$Excel-Macros$$ Re: Need expert advise for multipal Selection

Hello all experts any solution for my query On Mon, Apr 1, 2013 at 4:37 PM, Dhaval Shah todhavals...@gmail.com wrote: Dear Experts I want to make out multipul selection for my project pls refer my sheet Thanks Dhaval Shah -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do

Re: $$Excel-Macros$$ Re: Need expert advise for multipal Selection

cmp is current market price ( CLOSE PRICE ) On Tue, Apr 2, 2013 at 10:18 AM, xlstime xlst...@gmail.com wrote: what is CMP ?... you can use sumifs or sumproduct . Enjoy Team XLS On Tue, Apr 2, 2013 at 9:56 AM, Dhaval Shah todhavals...@gmail.comwrote: Hello

$$Excel-Macros$$ Not able to do SUM

Dear Friends me downlaod daily file from my back office pls refer NEt.xls i m not able to do sum at the end of the amount -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @

Re: $$Excel-Macros$$ Not able to do SUM

.: +91-0120-4841100, Extn.: 2467, 9716615535 naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the environment. Please don't print this e-mail unless you really need to.* On Mon, Mar 18, 2013 at 5:41 PM, Dhaval Shah todhavals...@gmail.comwrote: Dear Friends me downlaod daily file from

Re: $$Excel-Macros$$ Not able to do SUM

can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley *- -- *From:* Dhaval Shah todhavals...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Mon, March 18, 2013 8:12:24

$$Excel-Macros$$ I want to merge two text cell

dear friends i want to merge two text cell in one pls refer the sheet thanks dhaval -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use

Re: $$Excel-Macros$$ Query collation of data ignoring #n/a

pls chk On Fri, Feb 15, 2013 at 3:03 PM, vatspoojav...@gmail.com wrote: Hi All, I seek your guidance in the attached sheet, wherein, currently I am updating manually the column: I Correct Cost Centre Contracts.I am updating this from the data available in corresponding columns: D,E,F G.

Re: $$Excel-Macros$$ Need formula Solution

Thanks Dear On Tue, Feb 12, 2013 at 10:04 PM, Excel Beginner excelbegin...@gmail.com wrote: Hi Dhaval, Find the attachment. -- *Regards,* * * *Excel Beginner* On Tue, Feb 12, 2013 at 1:42 PM, Dhaval Shah todhavals...@gmail.comwrote: Dear Friends pls refer my sheet

$$Excel-Macros$$ how to lock worksheet

Dear friends i am lookking for solution 4 Lock work sheet if i am lock work sheet then i m not able to use filter actually i want to hide my formula's only is it any way to hide formula ??? Thanks Dhaval Shah -- Join official Facebook page of this forum @ https

Re: $$Excel-Macros$$ query for getting external data from a website

Kenil pls click the below mention link to download data of any eq series stocks www.nseindia.com/content/equities/scripvol/datafiles/30-09-2012-TO-28-12-2012 *TCS*EQN.csv www.nseindia.com/content/equities/scripvol/datafiles/30-09-2012-TO-28-12-2012RELIANCE **EQN.csv just u have to change the

Re: $$Excel-Macros$$ HIGH LOW QUERY

Thanks Dear For LOW ( Min ) ?? On Mon, Dec 24, 2012 at 5:17 PM, The Viper viper@gmail.com wrote: =INDEX($C$2:$C$3000,MATCH(F2MAX(IF($A$2:$A$3000=F2,$B$2:$B$3000,0)),$A$2:$A$3000$B$2:$B$3000,0)) -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ HIGH LOW QUERY

Suppos i m change the data in Sintex manual then formula works On Mon, Dec 24, 2012 at 10:41 AM, Dhaval Shah todhavals...@gmail.comwrote: Hello Prince , Wish u merry Christmas i m facing some problem to find out High Low value Date in u r Formula pls see the attech file there is two

Re: $$Excel-Macros$$ Re: HTTP Request differences....

Me Also Facing the same problem i m view below mention link in any browser but while i m try to import table in excel is not working http://www.nseindia.com/live_market/dynaContent/live_watch/equities_stock_watch.htm?cat=N is it any other way to import Table in Excel Sheet On Wed, Dec 19,

Re: $$Excel-Macros$$ HIGH LOW QUERY

Need Data Range upto 99000 in this sheet data Range upto only 2000 me try to change Data Range but its dosent work Pls do need full Thanks Dhaval Shah 98240 35253 On Wed, Dec 12, 2012 at 10:43 PM, Prince prince141...@gmail.com wrote: Hi Dhaval , Pls find Attached. Regards Prince

Re: $$Excel-Macros$$ HIGH LOW QUERY

Already change data range but not working On Wed, Dec 12, 2012 at 6:24 PM, Satendra kumar satendrakuma...@gmail.comwrote: Hi, change data range than apply i hope this is working... thankx satendra On Wed, Dec 12, 2012 at 6:19 PM, Dhaval Shah todhavals...@gmail.comwrote: FRIENDS

Re: $$Excel-Macros$$ High low Query

, Dhaval Shah todhav...@gmail.comjavascript: wrote: Friends, pls go through the attached excel sheet in main sheet there is raw data of differenet date for different product now suppose product x trade for 5 days and 5 days close value is also different need to know the which date

$$Excel-Macros$$ HOW TO IMPORT LIVE WEB PAGE TO EXCEL

I M TRYIN TO IMPORT BELOW MENTION LINK http://www.nseindia.com/live_market/dynaContent/live_watch/equities_stock_watch.htm?cat=N ACTUALLY RECENTLY NSE INDIA DONE SOME MODIFICATION WITH WEB SITE AFTER UPDATATION I M ENALBE TO IMPORT DATA FROM ABOVE LINK IS IT ANY OTHER WAY TO IMPORT TO EXCEL

$$Excel-Macros$$ NEED HELP

-- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be

Re: $$Excel-Macros$$ NEED HELP

, Dec 10, 2012 at 10:28 AM, Anoop K Sharma aks.sharm...@gmail.comwrote: Hi Dhaval, PFA... Regards, Anoop Sr. Developer On Mon, Dec 10, 2012 at 9:12 AM, Dhaval Shah todhavals...@gmail.comwrote: -- Join official Facebook page of this forum @ https://www.facebook.com

Re: $$Excel-Macros$$ Re: High low Query

, Dhaval Shah wrote: Friends, pls go through the attached excel sheet in main sheet there is raw data of differenet date for different product now suppose product x trade for 5 days and 5 days close value is also different need to know the which date product x close on highest and lowest

Re: $$Excel-Macros$$ High low Query

Thanks a Lot Brother On Wed, Dec 5, 2012 at 11:14 PM, Excel Beginner excelbegin...@gmail.com wrote: Hi Dhaval, Please find the attachment. -- *Regards,* * * *Excel Beginner* * * On Wed, Dec 5, 2012 at 12:26 PM, Dhaval Shah todhavals...@gmail.comwrote: Friends