Re: $$Excel-Macros$$ Urgent Help required

2017-07-17 Thread Rakesh kumar
see this attachment. hope it makes you understand. On Mon, Jul 17, 2017 at 11:59 AM, Saleem Ansari wrote: > Question not clear > > On Mon, Jul 17, 2017 at 9:13 AM, Rakesh kumar > wrote: > >> Hi Friends, >> >> I need urgent help, If any one can help me. >>

$$Excel-Macros$$ Urgent Help required

2017-07-16 Thread Rakesh kumar
Hi Friends, I need urgent help, If any one can help me. actually I have got one assignment, I need to solve it, but I'm completely stuck into this. Please see the attachment and help. -- Thanks £ Regards Rakesh Kumar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wan

$$Excel-Macros$$ Macro Required for attached excel

2016-06-12 Thread Rakesh
Dear Experts, Macro Required for attached excel . this is urgent. pl help. Process 1 Test Location name to be filled 2 Lat/Long to be taken from raw input-rsrp sheet from Yellow marked line 3 PCI to be taken from raw input-rsrp sheet data should be taken between yello marked line 4 Test start tim

$$Excel-Macros$$ Re: Introduce Yourself !!

2016-02-24 Thread Rakesh Bjain
Hi all, This is Rakesh here, I am chartered accountant by profession, next target for me is to train myself in Macro and VBA. Request experts to send me easy way of understanding and learning Macro and VBA. Regards, CA Rakesh B Jain On Saturday, 9 June 2012 00:51:59 UTC+5:30, Ayush Jain

Re: $$Excel-Macros$$

2015-05-14 Thread Rakesh
​help plz​ RAKESH SHARMA NPI –Team Ericsson India Pvt. Ltd. 4th Floor, Gupta Towers, Commercial Block, Rail Head Jammu & Kashmir, INDIA Phone 01912477440/ 01912477473/441 Fax 01912477442 Mobile +91 9906115140 rakesh.kumar.d.sha...@ericsson.com www.ericsson.com “If You fall, fall like a see

Re: $$Excel-Macros$$

2015-05-13 Thread Rakesh
Dear Ashish, Thanks for your efforts, pl find the attached sheet for your reference. Kindly suggest any appropriate formula which give me the exect which i want. RAKESH SHARMA NPI –Team Ericsson India Pvt. Ltd. 4th Floor, Gupta Towers, Commercial Block, Rail Head Jammu & Kashmir, I

$$Excel-Macros$$

2015-05-13 Thread Rakesh
Dear Experts, can you please tell me how to get 2nd,3rd... values with the Vlookup. Thanks Rakesh -- 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

Re: $$Excel-Macros$$ Re: DropDown List

2015-05-13 Thread Rakesh
Dear Nasir, Thanks for your efforts. but dear i need data in drop down list . for example. if i select indus in drop down then in zte cluster option i will get zte cluster and same for the zdm name and zdm number RAKESH SHARMA NPI –Team Ericsson India Pvt. Ltd. 4th Floor, Gupta Towers

$$Excel-Macros$$ DropDown List

2015-05-13 Thread Rakesh
Dear Experts, Help required for attached sheet urgently -- 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, accurate thread titles. Poo

Re: $$Excel-Macros$$ Re: Help required for conslidate

2015-05-05 Thread Rakesh
Thanks alot Mandeep ji. its working. br// rakesh RAKESH SHARMA NPI –Team Ericsson India Pvt. Ltd. 4th Floor, Gupta Towers, Commercial Block, Rail Head Jammu & Kashmir, INDIA Phone 01912477440/ 01912477473/441 Fax 01912477442 Mobile +91 9906115140 rakesh.kumar.d.sha...@ericsson

Re: $$Excel-Macros$$ Re: Help required for conslidate

2015-05-05 Thread Rakesh
Thanks Mandeep ji, but dear i didn't under stand what your are talking about this line *go into home tab delete cells and shift cells left you will get your data* Pl help RAKESH SHARMA NPI –Team Ericsson India Pvt. Ltd. 4th Floor, Gupta Towers, Commercial Block, Rail Head Jammu &

$$Excel-Macros$$ Help required for conslidate

2015-05-05 Thread Rakesh
Dear Experts, Kindly Help on urgent basis to get it resolve as below . suggest any formula to get the exact data as i required. reference sheet attached ​ I have data as below source 1 1 1 1 1 1 1 1 1 1 1 1 RAKESH A B C DMUKESH A B C D E GAURAV A B

$$Excel-Macros$$ Avarage calculation

2015-04-09 Thread Rakesh kumar
Hi, I want to put Avarage formulla with multiple conditions in same column. Please see the attechment and put the formulla Please do it on urgent basis if possible. -- Thanks £ Regards Rakesh Kumar +91-9650303464 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

$$Excel-Macros$$ Calender Control

2015-03-31 Thread Rakesh kumar
unable to find out. Please guide me how to add this. -- Thanks £ Regards Rakesh Kumar +91-9650303464 -- 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

$$Excel-Macros$$ how to run SQL Query in Excel to retrive a set of Data.

2015-03-23 Thread Rakesh kumar
can anybody guide to me. -- Thanks £ Regards Rakesh Kumar +91-9650303464 -- 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, acc

$$Excel-Macros$$ DailyTransport cost tracker.

2015-03-04 Thread Rakesh Kumar Sharma
Hi Team, Request you to share a Daily Transport cost Tracker format, if any one have. -- Regards, Rakesh Kumar Sharma Contact: +91-9971024741 -- 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

$$Excel-Macros$$ Information Required

2015-02-10 Thread Rakesh kumar
in SAS. so that it would be helpfull for me to understand the SAS software. If anyone have Study meterial of SAS please send me. Thanks for time and considration. -- Thanks £ Regards Rakesh Kumar +91-9650303464 <#> <#> -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do

Re: $$Excel-Macros$$ Macro Required ...!!!

2015-01-20 Thread Rakesh
Any update plz On 20-Jan-2015 5:22 PM, "Rakesh" wrote: > Hi Experts, > > > > Please help to provide macro of above mentioned requirement.As in > attached sheet On Left side i have shown the input which we have to > fetch in macro which can range from 1 to 50

$$Excel-Macros$$ Macro Required ...!!!

2015-01-20 Thread Rakesh
be converted into right hand side shown format. Do the needful Thanks rakesh sharma -- 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

$$Excel-Macros$$ TIme format

2015-01-10 Thread Rakesh
:49 AM* 4 *10/26/14 4:53 AM* 4 thanks rakesh -- 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, accurate thread titles. Poor thread

Fwd: $$Excel-Macros$$ Re: Vlookup Help required

2015-01-10 Thread Rakesh
Kindly with suitable formula urgenly required Rakesh -- Forwarded message -- From: "Mandeep Baluja" Date: 06-Jan-2015 5:52 PM Subject: $$Excel-Macros$$ Re: Vlookup Help required To: Cc: , Try this. > Regards, Mandeep Baluja LearningZmyPassion https://www.linkedi

$$Excel-Macros$$ Vlookup Help required

2015-01-06 Thread Rakesh
Dear Experts, pl suggest any formula which can help me to get valeus for K2 & L2 from raw sheet against B2 & C2 Note:- kindly Refer the hours which stand within StartTime & EndTime sheet attached for reference Thnaks in advance. rakesh Sharma -- Are you =EXP(E:RT) or =

$$Excel-Macros$$ Hqppy New Year 2015

2014-12-31 Thread Rakesh
Dear All. Aap Sabko New Year Ki Bohot Bohot Vadhaiyan... Mein Uppar wale se dua krunga., Fariyad Karunga ki Wo aap sabko Khush Rkhe aur Khusal Rkhe :) Keep Smiling :) Sincerely ;) Rakesh -- 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$$ Help Required on Dependent Data Validation

2014-12-30 Thread Rakesh kumar
Hi, I need help on Dependent Data validation. and please try to solve it without adding any other column. -- Thanks £ Regards Rakesh Kumar +91-9650303464 <#> -- 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 o

Re: $$Excel-Macros$$ validation

2014-12-18 Thread Rakesh
Thanks Sandeep... but not exectly want this.. m talkng about validation issue not Vlookup dear. :(​ RAKESH SHARMA NPI –Team Ericsson India Pvt. Ltd. 4th Floor, Gupta Towers, Commercial Block, Rail Head Jammu & Kashmir, INDIA Phone 01912477440/ 01912477473/441 Fax 01912477442 Mobile

Re: $$Excel-Macros$$ validation

2014-12-18 Thread Rakesh
On sheet 1. Cell b2 On 18-Dec-2014 2:16 PM, "Victor Momoh" wrote: > > On what sheet and on what cell do you get that error > > On Thu, Dec 18, 2014 at 9:28 AM, Rakesh wrote: >> >> Dear Experts >> >> I received the following data validation error

$$Excel-Macros$$ validation

2014-12-18 Thread Rakesh
Dear Experts I received the following data validation error: Source evaluates to an error. Do you wish to continue? and when i continue nothing will changed. :( KIndly help reference sheet attached br// rakesh -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

Re: $$Excel-Macros$$ Urgent help

2014-12-16 Thread Rakesh kumar
I want all, whatever the is available on sheets. On Tue, Dec 16, 2014 at 5:47 PM, Vaibhav Joshi wrote: > > ok, do you want both or unique one? > > + > *I did not do this for you. God is here working through me for you.* > > On Tue, Dec 16, 2014 at 5:43 PM, Rakesh kumar

Re: $$Excel-Macros$$ Urgent help

2014-12-16 Thread Rakesh kumar
t; > On Tue, Dec 16, 2014 at 5:03 PM, Rakesh kumar > wrote: >> >> HI frinds, >> i want split cells value in diffrent row using macros, please see the >> attechment. >> >> Please do it urgent basis if any one can. >> >> >> --

$$Excel-Macros$$ Urgent help

2014-12-16 Thread Rakesh kumar
HI frinds, i want split cells value in diffrent row using macros, please see the attechment. Please do it urgent basis if any one can. -- Thanks £ Regards Rakesh Kumar +91-9650303464 <#> -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:I

$$Excel-Macros$$ Help reqrueid.(Index formula requried)

2014-12-08 Thread Rakesh
hello Experts, Need an index formula which combined the index which have na data reference sheet attached thanks in advance. Br//​ RAKESH SHARMA NPI –Team Ericsson India Pvt. Ltd. 4th Floor, Gupta Towers, Commercial Block, Rail Head Jammu & Kashmir, INDIA Phone 01912477440/ 01912477473

$$Excel-Macros$$ Re: Interview Questions with Answers (Excel+VBA+Access+SQL Server)

2014-08-14 Thread Rakesh Chaudhary
Hi sir, Its realy good to see. Please provide us ms access question and answer attachment sheet. On Thursday, 10 May 2012 16:49:25 UTC+5:30, NOORAIN ANSARI wrote: > > Dear Group, > > Please find attached Interview questions and answers for MS Excel+VBA+MS > Access+SQL Server. > > If any one ha

$$Excel-Macros$$ Data validation help

2014-06-17 Thread Rakesh kumar
Dear Friends, i want to use data validation in excel. first validation - Value would not be repeat in list. and In second Validation , show only those value which is belongs to first value. please find the Sample sheets. -- Thanks £ Regards Rakesh Kumar -- Are you =EXP(E:RT) or =NOT

$$Excel-Macros$$ Needs help in Data validation

2014-06-17 Thread Rakesh kumar
PFA -- Thanks £ Regards Rakesh Kumar +91-9650303464 -- 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, accurate thread titles. Poor

Re: $$Excel-Macros$$ Help Needed

2014-06-17 Thread Rakesh kumar
Thanks Brother, But how you Did this. Please explain the process. On Tue, Jun 17, 2014 at 1:02 PM, Dhaval Shah wrote: > fyi > > Warm Regards, > > Dhaval Shah > M) 98240 35253 > *E-mail : todhavals...@gmail.com * > > > > > On Tue, Jun 17, 2014 at 12:51 PM,

$$Excel-Macros$$ Help Needed

2014-06-17 Thread Rakesh kumar
Hi Guys, I want to use formula on pivot table data. Kindly help me. -- Thanks £ Regards Rakesh Kumar +91-9650303464 -- 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

Re: $$Excel-Macros$$ Re: [XL-VBA Clinic] Extracting Google spreadsheet data on MS Excel daily automatically

2014-03-20 Thread Rakesh Kumar Sharma
Dear Experts, Please solve the query if possible. On Wed, Mar 19, 2014 at 2:16 PM, Rakesh Kumar Sharma wrote: > Dear Varun, > > Pls find the attached format. > > Same file will be shared with team also. thwy will update location wise on > sheets > > > On Wed, Mar

$$Excel-Macros$$ Extracting Google spreadsheet data on MS Excel daily automatically

2014-03-19 Thread Rakesh Kumar Sharma
data as team insert or summarized, does not matters. Pls suggest me, is this possible, if Yes, then How? -- Regards, Rakesh Kumar Sharma Contact: +91-9971024741 -- 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 pa

$$Excel-Macros$$ Fwd: [XL-VBA Clinic] PIVOT TABLE BASED ON CELL VALUE

2014-02-14 Thread Rakesh Kumar Sharma
. For more options, visit https://groups.google.com/groups/opt_out. -- Regards, Rakesh Kumar Sharma Contact: +91-9971024741 -- 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.c

$$Excel-Macros$$ Re: [XL-VBA Clinic] Offset Query

2014-02-01 Thread Rakesh Kumar Sharma
correct bhai Thank you So much Saurabh Ji. On Sat, Feb 1, 2014 at 12:54 PM, saurabh kumar wrote: > Hi Rakesh, > > Please use below with CSE. > > =OFFSET(INDEX($A$4:$A$27,MATCH($M$1,A4:A27,0)),0,3,6,COUNTA(N4:U4)) > > Changes is highlighted. > > Regards > Saurabh &

$$Excel-Macros$$ Re: [XL-VBA Clinic] Offset Query

2014-01-31 Thread Rakesh Kumar Sharma
Pls find the attached file. On Sat, Feb 1, 2014 at 12:03 PM, saurabh kumar wrote: > Hi , > > Attachment is missing dear. > > > > > On Sat, Feb 1, 2014 at 11:58 AM, Rakesh Kumar Sharma < > rakeshks@gmail.com> wrote: > >> Dear Experts, >> >

$$Excel-Macros$$ Offset Query

2014-01-31 Thread Rakesh Kumar Sharma
Dear Experts, Pls suggest me where is mistake in attached sheet. why the last Row not showing data. -- Regards, Rakesh Kumar Sharma Contact: +91-9971024741 -- 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

Re: $$Excel-Macros$$ Please Help

2014-01-29 Thread Rakesh kumar
Well done Ravindre, Thanks On Thu, Jan 30, 2014 at 11:59 AM, Ravinder wrote: > =TEXT(MAX((H2=$B$2:$B$1944)*$D$2:$D$1944),"MM/DD/ H:MM") with CSE > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Rakesh kumar &g

Re: $$Excel-Macros$$ Required Chart with multiple criteria

2014-01-24 Thread Rakesh Kumar Sharma
Dear Experts, Pls consider on chart query. On Fri, Jan 24, 2014 at 4:59 PM, Rakesh Kumar Sharma wrote: > Hi Experts, > > pl find the attached data file. > > -- > Regards, > > Rakesh Kumar Sharma > Contact: +91-9971024741 > > -- > Are you =EXP(E:RT) or

Re: $$Excel-Macros$$ Help Required

2014-01-24 Thread Rakesh kumar
Thanks Ravinder. On Fri, Jan 24, 2014 at 4:37 PM, Ravinder wrote: > PFA > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Rakesh kumar > *Sent:* Friday, January 24, 2014 4:26 PM > *To:* excel-macros@googlegroups.

$$Excel-Macros$$ Required Chart with multiple criteria

2014-01-24 Thread Rakesh Kumar Sharma
Hi Experts, pl find the attached data file. -- Regards, Rakesh Kumar Sharma Contact: +91-9971024741 -- 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

$$Excel-Macros$$ Help Required

2014-01-24 Thread Rakesh kumar
Hi Friends, Please find the attachment. Help Please -- Thanks £ Regards Rakesh Kumar +91-9650303464 -- 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

$$Excel-Macros$$ Re: Urgent Help.

2013-10-04 Thread Rakesh kumar
Please find the attachment. On Sat, Oct 5, 2013 at 11:22 AM, Rakesh kumar wrote: > > Dear Friend, > > i want to use total no of present or absent list using pivot table. > > Please find the attachment. > > > -- > Thanks £ Regards > Rakesh Kumar > +91-9650

$$Excel-Macros$$ Urgent Help.

2013-10-04 Thread Rakesh kumar
Dear Friend, i want to use total no of present or absent list using pivot table. Please find the attachment. -- Thanks £ Regards Rakesh Kumar +91-9650303464 -- 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

$$Excel-Macros$$ Query in Pivot Table

2013-07-11 Thread Rakesh Kumar Sharma
Dear Experts, I have a query related to Pivot Table. Pls refer to attachment. -- Regards, Rakesh Kumar Sharma Contact: +91-9971024741 -- 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

$$Excel-Macros$$ Need Access help

2013-07-04 Thread Rakesh Sharma
Dear Experts i have two queries in acess 2010 screen shot attached which have data mention below i just want to sum both of two queries. pl help query 1 query 2 name count name count rakesh 1

Re: $$Excel-Macros$$ required Result on Conditions

2013-07-03 Thread Rakesh Kumar Sharma
Thank you so much Abhishek ji, it's working fine. On Thu, Jul 4, 2013 at 11:51 AM, Abhishek Jain wrote: > PFA > > > On Thu, Jul 4, 2013 at 11:42 AM, Rakesh Kumar Sharma < > rakeshks@gmail.com> wrote: > >> Dear Experts, >> I want Result o

$$Excel-Macros$$ required Result on Conditions

2013-07-03 Thread Rakesh Kumar Sharma
Dear Experts, I want Result on conditions. Pls find the attachment. -- Regards, Rakesh Kumar Sharma Contact: +91-9971024741 -- 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

Re: $$Excel-Macros$$ Help Required

2013-04-30 Thread Rakesh kumar
Hi Priti Great work, Thanku so much. Thank Raeksh k On Wed, May 1, 2013 at 9:56 AM, priti verma wrote: > Hi Rakes, > Yes you can do this without using another column.Please see the > attachement. > Regards, > Priti verma > > > On Tue, Apr 30, 2013 at 6:12 PM, Rakesh ku

Re: $$Excel-Macros$$ Help Required

2013-04-30 Thread Rakesh kumar
Hi priti, thanks for the help, Is it possible without using another column. On Tue, Apr 30, 2013 at 5:49 PM, priti verma wrote: > Hi Rakesh, > Please see the attachment. > Regards, > Priti verma > > > On Tue, Apr 30, 2013 at 5:22 PM, Rakesh kumar wrote: > >> Th

Re: $$Excel-Macros$$ Help Required

2013-04-30 Thread Rakesh kumar
Thanks Prafull On Tue, Apr 30, 2013 at 4:47 PM, Prafull Jadhav wrote: > Dear Rakesh, > > find the same. > > Regards, > Prafull jadhav. > > > On Tue, Apr 30, 2013 at 4:37 PM, Ahmed Honest wrote: > >> Rakesh: >> >> Run Pivot table, if no I

$$Excel-Macros$$ Help Required

2013-04-30 Thread Rakesh kumar
£ Regards Rakesh Kumar +91-9650303464 -- 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, accurate thread titles. Poor thread titles, like

Re: $$Excel-Macros$$ Need formula to retrieve value

2013-02-18 Thread Rakesh Kumar Sharma
Dear Abhishek, Working fine Will yo please explain this how it works? On Tue, Feb 19, 2013 at 12:55 PM, Abhishek Jain wrote: > Check attached. Let us know if there is any further query. > > HTH > Abhi > > > On Tue, Feb 19, 2013 at 12:31 PM, Rakesh Kumar Sharma <

$$Excel-Macros$$ Need formula to retrieve value

2013-02-18 Thread Rakesh Kumar Sharma
Dear Experts, I need a formula/function which can give required value. Sample file attached. Thanks in Advance -- Regards, Rakesh Kumar Sharma Contact: +91-9971024741 -- 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

$$Excel-Macros$$ Formula to Calculate Age in Excel

2012-12-06 Thread Rakesh Kumar Sharma
Dear Team, Can you help me how to calculate age ( in Year, month & day) in Excel -- Regards, Rakesh Kumar Sharma Contact: +91-9971024741 -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor th

$$Excel-Macros$$ VBA to update in Website.

2012-12-06 Thread Rakesh Joshi
how update value in text box in website which contain in table like as I am having the text box in table in interexplorer. As I can fill it if they are not it table using doc methon. Please help me as soon as poosible. -- Join official Facebook page of this forum @ https://www.facebook.

Re: $$Excel-Macros$$ Paul Schreiner - Most Helpful Member November'12

2012-12-03 Thread Rakesh Kumar Sharma
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 answered. > 2) Don't post a question in the thread of another member. > 3) D

Re: $$Excel-Macros$$ Re: Split a cell into multiple cells in Excel 2010

2012-11-20 Thread Rakesh Kumar Sharma
Hi Anil, Pls find the attached sample sheet. On Wed, Nov 21, 2012 at 11:53 AM, अनिल नारायण गवली wrote: > dear Rakesh, > > Pl specify you query to understand better.Or share a sample workbook with > us > > Regards, > Gawli Anil > > > > > On Wed, Nov 21, 2012

$$Excel-Macros$$ sharepoint to acces

2012-11-01 Thread Rakesh Joshi
Hi- Our team is currently using an Infopath form in SharePoint but looking to move to an Access database. We would like to be able to use as a resource request and have questions posted to the Access database. Does anyone know if this is something that can be done in Microsoft Access- and if

Re: $$Excel-Macros$$ Should Highlighted formula cell & reference cell also

2012-10-11 Thread Rakesh Kumar Sharma
*Select Formula Cell and press Ctrl+ [ * > > * * > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > * * > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Rakesh Kumar Sharma

Re: $$Excel-Macros$$ Should Highlighted formula cell & reference cell also

2012-10-11 Thread Rakesh Kumar Sharma
Dear, Pls Find the Excel file as a sample On Thu, Oct 11, 2012 at 5:39 PM, Rakesh Kumar Sharma wrote: > Dear Experts, > > > Pls resolve this query. > when we use any formula and press F2 then it goes highlighted and > reference cells also. i want when i only select the form

$$Excel-Macros$$ How we use CHOOSE function with VLOOKUP in Excel

2012-10-09 Thread Rakesh Kumar Sharma
Dear Experts, I want to know How we can use CHOOSE function with VLOOKUP in Excel. -- Regards, Rakesh Kumar Sharma Contact: +91-9971024741 -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1

Re: $$Excel-Macros$$ Re: Lookup data when there are repeated data with diff amt

2012-09-03 Thread Rakesh Kumar Sharma
Dear Prince, Its working fantastic. On Mon, Sep 3, 2012 at 3:18 PM, Prince Dubey wrote: > Hi Rakesh, > > Plz Use this Hope this will Help You. > > SUMIF(Sheet1!$B$2:$B$18,Sheet2!A2,Sheet1!$D$2:$D$18) > > Regards > Prince > > On Monday, September 3, 2012 1:01

Re: $$Excel-Macros$$ Lookup data when there are repeated data with diff amt

2012-09-03 Thread Rakesh Kumar Sharma
, Manoj Kumar wrote: > Dear Rakesh, > > > Use *=SUMIFS(Sheet1!$D$2:$D$18,Sheet1!$B$2:$B$18,A2)* > > > Regd > Manoj > > > On Mon, Sep 3, 2012 at 1:00 PM, Rakesh Kumar Sharma < > rakeshks@gmail.com> wrote: > >> Hi Experts, >> >> I n

$$Excel-Macros$$ Lookup data when there are repeated data with diff amt

2012-09-03 Thread Rakesh Kumar Sharma
Hi Experts, I need the actual remit amt agnst tracking on sheet2 when data was found repeated on sheet1 with positive or nigative amt. See the attachment... -- Regards, Rakesh Kumar Sharma Contact: +91-9971024741 -- Join official facebook page of this forum @ https://www.facebook.com

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member August 2012

2012-09-02 Thread Rakesh Kumar Sharma
Jobs posting is not allowed. >> >> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> --- >&g

Re: $$Excel-Macros$$ Merging Two excel sheets on single sheet

2012-08-29 Thread Rakesh Kumar Sharma
-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Rakesh Kumar Sharma > > *Sent:* Tuesday, August 21, 2012 6:27 PM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Merging Two excel sheets on single sheet** > ** > > ** ** >

Re: $$Excel-Macros$$ How can i reduce file size of a Excel file

2012-08-22 Thread Rakesh Kumar Sharma
Hi Noorain, If i want to pick data of column2 then how it works? See attachment. On Fri, Aug 17, 2012 at 4:33 PM, NOORAIN ANSARI wrote: > Dear Rakesh, > > See attached sheet. > > > On Fri, Aug 17, 2012 at 4:13 PM, Rakesh Kumar Sharma < > rakeshks@gmail.com> wro

Re: $$Excel-Macros$$ Merging Two excel sheets on single sheet

2012-08-21 Thread Rakesh Kumar Sharma
Dear Noorain, Plz find the sample file. I need to combine data on last sheet. & in also that case when the data is on different workbooks On Tue, Aug 21, 2012 at 5:57 PM, NOORAIN ANSARI wrote: > Dear Rakesh, > > Can you share your sample workbook with us. > > > On Tue

Re: $$Excel-Macros$$ How can i reduce file size of a Excel file

2012-08-17 Thread Rakesh Kumar Sharma
plz ignore On Fri, Aug 17, 2012 at 5:34 PM, Rakesh Kumar Sharma wrote: > Hi Noorain, > > As you told to use INDEX MATCH to replace VLOOKUP . > > Plz find the attached file & share how to use these > > On Thu, Aug 16, 2012 at 6:11 PM, Rakesh Kumar Sharma < >

Re: $$Excel-Macros$$ How can i reduce file size of a Excel file

2012-08-17 Thread Rakesh Kumar Sharma
Hi Noorain, As you told to use INDEX MATCH to replace VLOOKUP . Plz find the attached file & share how to use these On Thu, Aug 16, 2012 at 6:11 PM, Rakesh Kumar Sharma wrote: > Dear Noorain/ Amresh, > > > Thank u so much for great helping. > > > > On Thu, Aug

Re: $$Excel-Macros$$ How can i reduce file size of a Excel file

2012-08-17 Thread Rakesh Kumar Sharma
Hi Noorain, As you told to use INDEX & MATCH to replace VLOOKUP . plz find the attached file & share how to use these On Thu, Aug 16, 2012 at 6:11 PM, Rakesh Kumar Sharma wrote: > Dear Noorain/ Amresh, > > > Thank u so much for great helping. > > > > On Thu,

Re: $$Excel-Macros$$ How can i reduce file size of a Excel file

2012-08-16 Thread Rakesh Kumar Sharma
Dear Noorain/ Amresh, Thank u so much for great helping. On Thu, Aug 16, 2012 at 4:21 PM, NOORAIN ANSARI wrote: > Dear Rakesh, > > You can also set high priority of Excel exe file > See attached screen shot. > > > On Thu, Aug 16, 2012 at 4:15 PM, NOORAIN ANSARI >

Re: $$Excel-Macros$$ How can i reduce file size of a Excel file

2012-08-16 Thread Rakesh Kumar Sharma
Dear Kuldeep, It's too large size On Thu, Aug 16, 2012 at 1:03 PM, Kuldeep Singh wrote: > > Hi Rakesh, > > Please Share a sample worksheet. > > Regards, > Kuldeep Singh > > On Thu, Aug 16, 2012 at 1:01 PM, Rakesh Kumar Sharma < > rakeshks@gmail.com&g

$$Excel-Macros$$ How can i reduce file size of a Excel file

2012-08-16 Thread Rakesh Kumar Sharma
Hi Experts, I have a sheet of 70MB. I am facing problem when using formulas & filters. It gets slow. I am using Excel 2010. Is there any way to prevent to being slow process or any format where i can work on a reduced file size. -- Regards, Rakesh Kumar Sharma Contact: +91-997102

Re: $$Excel-Macros$$ I want to learn macro from basic level

2012-06-12 Thread Rakesh Kumar Sharma
ok to start from scratch. > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Rakesh Kumar Sharma > *Sent:* 12 June 2012 3:00

$$Excel-Macros$$ I want to learn macro from basic level

2012-06-12 Thread Rakesh Kumar Sharma
Hi Masters, If you have any attachment which can help me to learn excel macro from starting point, plz share. -- *Regards, Rakesh Kumar Sharma Contact: +91-9971024741 * -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles

$$Excel-Macros$$ Query for Merging two excel sheets using Command Prompt

2012-05-13 Thread Rakesh Kumar Sharma
Hi, Plz suggest me how i can merge two excel files data to single sheet using command prompt. -- Thanks & Regards, Rakesh Kumar Sharma -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need

$$Excel-Macros$$ Report Problem in MS Access

2012-05-03 Thread Rakesh Joshi
. how to do report fit in a page in prining option.. please help your help will be highly appriciated. Rakesh Joshi. Asst Manager, United Health GROUP Hyderabad. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles

$$Excel-Macros$$ Re: INCOME TAX SOFTWARE

2012-04-22 Thread Rakesh
Hi, please check http://ynithya.com/taxcalc/ -- personal tax good one...excellent.. On Friday, April 20, 2012 6:23:50 PM UTC+5:30, TARUN wrote: > sir, i want a income tax calculating software using excel bywhich i > can calculate tax and take return querterly and annualy and the form >

$$Excel-Macros$$ fso

2011-12-03 Thread Rakesh Joshi
Hi Ashish, i need to open all files in a folder and run the macro regarding macro i can take care but opening all files in folder i am getting trouble application .filesearch is not working 2010 coudl you please let me know how to do that. -- Rakesh Joshi -- FORUM RULES (934+ members already

Re: $$Excel-Macros$$ How to load data into Combo box in user form

2011-08-30 Thread Rakesh Joshi
s and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><&

Re: $$Excel-Macros$$ Required Latest No. of Drawing - Help

2011-07-26 Thread Rakesh Joshi
ps and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><

Re: $$Excel-Macros$$ Want to copy two rows in all sheets except few

2011-07-14 Thread Rakesh Joshi
roups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > &g

Re: $$Excel-Macros$$ HELP urgent

2011-07-13 Thread Rakesh Joshi
celdailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on fa

Re: $$Excel-Macros$$ Question on VBA

2011-06-28 Thread Rakesh Joshi
> > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on faceboo

$$Excel-Macros$$ Excel macro errror

2011-06-24 Thread Rakesh Joshi
-- please help while i m coding new xl fine in 2007 getting below errorr what to do. attached is the error Rakesh Joshi -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links

Re: $$Excel-Macros$$ Pad zeros

2011-06-17 Thread Rakesh Joshi
group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macr

Re: $$Excel-Macros$$ Drop down button in cell

2011-04-12 Thread rakesh kumar
that's nice.. very handy On Tue, Apr 12, 2011 at 12:30 AM, Ramkesh Maurya wrote: > ll the options in the Range:List -- Rakesh kumar khowal -- -- Some important links for excel users: 1. Follow us on

$$Excel-Macros$$ Drop down button in cell

2011-04-11 Thread rakesh kumar
HI Group, I have been trying to put one drop down menu in cell, which should be visible only when the particular cell is clicked. I have seen such drop down menu to appear in many spreadsheets posted here for examples, but couldn't achieve that. -- R

$$Excel-Macros$$ - Pivot table .Calculation = xlPercentOfColumn

2011-04-04 Thread rakesh kumar
ields("Q3_Village") .Orientation = xlDataField .Position = 1 End With End With -- Rakesh kumar khowal -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and li

Re: $$Excel-Macros$$ Pivot table - Pivot tabel row Range

2011-04-03 Thread rakesh kumar
Could you tell me what have you done ??? On Sun, Apr 3, 2011 at 8:42 PM, Jaideep Panchal wrote: > if it helps... -- Rakesh kumar khowal +91 9868532105 -- -- Some important links for excel users: 1. Fol

Re: $$Excel-Macros$$ Pivot table - Pivot tabel row Range

2011-04-03 Thread rakesh kumar
Hi Umesh/Group members, I am attaching the sample data. I know if I take gender for column it'll solve the problem, but for some reason I don't wish to add any field in the column.. Thanks ! On Fri, Apr 1, 2011 at 7:07 PM, Umesh Dev wrote: > Hi Rakesh, > > can you att

$$Excel-Macros$$ Pivot table - Pivot tabel row Range

2011-04-01 Thread rakesh kumar
esn't match the filter criteria it should show 0 or anything else will just do. any idea ??? Thanks !! -- Rakesh kumar khowal -- -- Some important links for excel users: 1. Follow us on TWITTER for tips

Re: $$Excel-Macros$$ Pls help!!! Macro for Editi link

2011-03-18 Thread rakesh kumar
search for the string using Find&Replace Feb 11 - Circle\AA\GA - AA_F&F_FEB and replace with Mar 11 - Circle\AA\GA - AA_F&F_MAR On Thu, Mar 17, 2011 at 10:38 PM, Ankit wrote: > _MAR_ -- Rakesh kumar khowal +91 9540084660

  1   2   >