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

2012-07-04 Thread Dilip Pandey
Hello Team, I am an Excel student and one of true lover of Excel Formulas ;) Popularly known as "PandeyJi" in my circle, presently working for Banking / Finance sector in a MNC where I support Analytics & Project Transition / Management. With your blessing, awarded Microsoft MVP - Excel for two ti

Re: $$Excel-Macros$$ Rajan Verma - Most helpful Member(June​'12)

2012-07-04 Thread Dilip Pandey
Congratulations Rajan.. Keep up the good work :) Regards, DILIPandey On 7/4/12, Ayush Jain wrote: > Hello Everyone, > > Rajan Verma has been selected as 'Most Helpful Member' for the month of > June'2012. This is third time in row. :) > He has posted 149 posts in June 2012 and helped many peopl

Re: $$Excel-Macros$$ MVP Award....Congratulations Ashish Koul and Dilip Pandey !!

2012-07-01 Thread Dilip Pandey
rs of the group are > awarded Microsoft Most Valuable Professional Award. > My heartiest congratulations to *Ashish koul* and *Dilip Pandey* and > thanks for their big support to this forum. > > Keep posting ! > > Best regards, > Ayush Jain > Group Manager > Microsoft

Re: $$Excel-Macros$$ VLOOKUP IN MULTIPLE OCCURRENCES

2012-06-09 Thread Dilip Pandey
nks Mr Pandey > > On Sat, Jun 9, 2012 at 3:03 PM, Dilip Pandey wrote: > >> Hi Amit, >> >> See the attached file where I have used Index & Match function in >> combination with Row n Arrays to achieve the desired result. Thanks. >> >> Regards, >

Re: $$Excel-Macros$$ VLOOKUP IN MULTIPLE OCCURRENCES

2012-06-09 Thread Dilip Pandey
Hi Amit, See the attached file where I have used Index & Match function in combination with Row n Arrays to achieve the desired result. Thanks. Regards, DILIPandey On 6/9/12, Amit Gandhi wrote: > Hi Experts > > I want to Lookup PO No. from Lookup data and return all results if there > are mult

Re: $$Excel-Macros$$ Most helpful Member - March 12- Don Guillett

2012-04-14 Thread Dilip Pandey
Heartiest congratulations Don .. cheers :) Regards, DILIPandey On 4/14/12, Ayush Jain wrote: > Dear members, > > Don Guillett has been selected as 'Most Helpful Member' for the month of > March'12 > He has been helping forum members from long time consistently and we are > proud to have him in t

Re: $$Excel-Macros$$ RepWait

2012-04-12 Thread Dilip Pandey
Hi All, I believe Sajid's email id has been hacked as I have also received similar kind of emails from his email id in past 2 -3 days. Regards, DILIPandey On 4/13/12, SAJID MEMON wrote: > > > "Hi,bro! What's up? You know what. Recently I find a really nice website, > zol-gyyg.com > You can fin

Re: $$Excel-Macros$$ ****** FIVE YEARS COMPLETION******THANK YOU******

2012-03-25 Thread Dilip Pandey
Congratulations.. Ayush.. this groups is awesome. Best of luck. Regards, DILIPandey On 3/22/12, Ayush Jain wrote: > > > Dear members, > > > > I am proud to announce that the forum has completed 5 years today. This is > really great milestone of the forum. > > My sincere thanks to each one of yo

Re: $$Excel-Macros$$ Help on Chart

2012-03-24 Thread Dilip Pandey
Hi Shrini, See the attached file and let me know if this helps somehow :) Regards, DILIPandey On 3/24/12, Shrinivas Shevde wrote: > Respected All, > Please find attached sheet I want help to make chart. > I want to make a bar chart of 2 different thing having the difference very > vast > for an

Re: $$Excel-Macros$$ कविता: अपने Excel-Macro ग्रुप का उम्र,अब 5 साल हो गया.****** FIVE YEARS COMPLETION******THANK YOU******

2012-03-23 Thread Dilip Pandey
Thanks Noorain... you are awesome and multi - talented.. regards, DILIPandey On Fri, Mar 23, 2012 at 10:56 PM, Rajan_Verma wrote: > Fantablus!! > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *xlstime > *Sent:* Mar/Fri/2012 10:07 >

Re: $$Excel-Macros$$ Count function needed

2012-03-18 Thread Dilip Pandey
Hi Santosh, See the attached file where I have achieved this using formulas only. Thanks. Regards, DILIPandey On Sun, Mar 18, 2012 at 1:27 PM, santosh subudhi < santoshkumar.subu...@gmail.com> wrote: > Hi Group, > > I have added "=2+2" in cell A1 and in cell A2 I want the result to be 2 > since

Re: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari

2012-03-14 Thread Dilip Pandey
Congratulations Noorain Keep up the good work and keep helping :) Regards, DILIPandey On Thu, Mar 15, 2012 at 11:31 AM, Abhishek Jain wrote: > Many congratulations Noorain bro! > > Keep up the good work and keep helping us mere mortals in excelling our > lives. :) > > God bless > > > On

Re: $$Excel-Macros$$ Syntax used in VBA

2012-03-12 Thread Dilip Pandey
Nice collection ... Noorain. Regards, DILIPandey On Mon, Mar 12, 2012 at 12:44 PM, NOORAIN ANSARI wrote: > Hi dnkndnkn, > > Please find attached Ebook for VBA beginner. > > On Sun, Mar 11, 2012 at 6:21 PM, dnkndnkn wrote: > >> The syntax of VBA is different than other languages. It is difficult

Re: $$Excel-Macros$$ Syntax used in VBA

2012-03-11 Thread Dilip Pandey
Hi dnkndnkn, For beginners, I would suggest following:- 1) Do short recordings for each and every step (frequent used would be better), press Alt + F11 and see how Excel has transferred those actions (steps) into VBA syntax. Now type / edit them and run the code to see the changes and you will le

Re: $$Excel-Macros$$ Help Formula to find last date please

2012-03-11 Thread Dilip Pandey
Hi Marcio, It has been done using Excel formula, see the attachment and let me know if this is what you were looking for. Feel free to get back in case of any queries. Thanks. Regards, DILIPandey On Mon, Mar 12, 2012 at 6:53 AM, Marcio Bandeira de Azevedo < marciobandeir...@gmail.com> wrote:

$$Excel-Macros$$ Pivot multisheet how to use? for what purpose?

2012-03-10 Thread Dilip Pandey
; > Dear Dilip Thanx, > > ** ** > > ** ** > > ** ** > > Regards, > > Muneer, > > CC….**** > > ** ** > -- > > *From:* Dilip Pandey [mailto:dilipan...@gmail.com] > *Sent:* Saturday, March 10, 2012 1:41 PM > *To:* excel

Re: $$Excel-Macros$$ Pivot multisheet how to use? for what purpose?

2012-03-10 Thread Dilip Pandey
Hi Muneer, See the attachment where I have created a mutisheet pivot. Use:- For example, if you have the scores of a team against different matches and you wanted to sum the scores, you can use a multisheet pivot in this case, see the attachment and look in sheet "pivot" which have the data from t

Re: $$Excel-Macros$$ Match text to a list

2012-03-10 Thread Dilip Pandey
Hi Brian, You can include the following code in your macro:- Sub chk() Source = Range("d18") target = Range("L6:l27") i = Application.WorksheetFunction.Match(Source, target) If i >= 0 Then 'continued.. paste your code here End If End Sub Regards, DILIPandey On Sat, Mar 10, 2012 at 2:36 PM,

Re: $$Excel-Macros$$ Business Days Query

2012-02-22 Thread Dilip Pandey
Hi Sushil, In Networkdays formula, use NOW() function and then you can play around with Time available in NOW() as today() do not have this feature. Thanks. Regards, DILIPandey On 2/23/12, Sushil Kumar wrote: > Hi, > > i am using =networkdays(A1,today()) and cell A1 is 2/1/12. the problem >

Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari

2012-02-01 Thread Dilip Pandey
Congratulations Noorain... Keep it up. Regards, DILIPandey On 2/1/12, Ayush Jain wrote: > Hello Everyone, > > Noorain Ansari has been selected as 'Most Helpful Member' for the month of > Jan'12 > He has posted 175 posts in Jan'12 and helped many people through his > expertise. He has been cons

Re: $$Excel-Macros$$ By Default 2003

2012-01-29 Thread Dilip Pandey
opens. >> >> i m travelling . so cannot provide the exact path where xlstartup >> exist. >> Try this >> if not possible one more solution is there.. >> >> On 1/29/12, Dilip Pandey wrote: >> > Hi Sajid, >> > >> > I had the similar i

Re: $$Excel-Macros$$ Please Help me to create summary and Macro.

2012-01-28 Thread Dilip Pandey
Hi Avinash, Not entirely getting your point. Please confirm if you need following < which I can understand per your post> :) 1) Following results as per Date in first field < this you have already attached> DateTotal Product Actual PriceTotal Number Of ProductsGrand Total She

Re: $$Excel-Macros$$ By Default 2003

2012-01-28 Thread Dilip Pandey
Hi Sajid, I had the similar issue and corrected that later... since I run Office 2010 and can't test this out but sill remember following two option which I had tried during my encounter :) Two tryouts :- 1) Right click an excel file (preferable xlsx) -> open with -> choose "Excel 2003" as the de

Re: $$Excel-Macros$$ Display numbers in Lakhs

2012-01-28 Thread Dilip Pandey
Hi Prabhu, If you have the amount in number format, simply divide it by 10. If you have the amount in text i.e., Rs.924104600.90, use following formula:- ="Rs."&TEXT(VALUE(MID(a1,4,50))/10,"0,000") You can play around with format "0,000" which is present at the right end of the formula.

Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Dec'2011

2012-01-03 Thread Dilip Pandey
Congratulations Rajan..!! Keep up the good work. Have a wonderful year ahead. Regards, DILIPandey On 1/3/12, Ayush Jain wrote: > Hello Everyone, > > Wish you a very happy new year !! > > Rajan Verma has been selected as 'Most Helpful Member' for the month of > December'2011 > He has posted 105

Re: $$Excel-Macros$$ Most Helpful Member Nov'11 - Sam Mathai Chacko

2011-12-03 Thread Dilip Pandey
Heartiest Congratulations Sam keep up the helping spirit. Regards, DILIPandey On 12/2/11, Ayush Jain wrote: > Hello Everyone, > > Sam Mathai Chacko has been recognised as 'Most Helpful Member' for the > month of Nov'11 > He has posted 129 posts (13% of total posts) in Nov 2011 and helped ma

Re: $$Excel-Macros$$ Determine scope of name range

2011-11-05 Thread Dilip Pandey
Hi Arpana, Please share your daily needs. Regards, DILIPandey On 11/5/11, Nishant Arpana wrote: > Hi freind > > In need to develop my own VBAprogramme as per my daaily needs. > > Can you help me out > > Nishant > 09724055586 > > > > > On Sat, Nov 5, 2011 at 3:21 AM, hanumant shinde > wrote: > >

Re: $$Excel-Macros$$ Most Helpful Member Oct'11 - Sam Mathai Chacko

2011-11-02 Thread Dilip Pandey
Congratulations Sam, you are wonderful. Regards, DILIPandey On 2 Nov 2011 01:20, "Sam Mathai Chacko" wrote: > Dear Noorain, Dear Haseeb, > > Thank you. Noorain, you've already been there. Have learned things > from you. Haseeb, you are a gem of a formula champion. thanks for all > the learning.

Re: $$Excel-Macros$$ HAPPY DIWALI!!!!!!

2011-10-26 Thread Dilip Pandey
A very happy Diwali to all the Group members. Enjoy. :) Regards, DILIPandey On 26 Oct 2011 23:02, "xlstime" wrote: > Happy Diwali to all. > > On Wed, Oct 26, 2011 at 5:51 PM, Sanjib Chatterjee < > chatterjee.kolk...@gmail.com> wrote: > >> Dear Members, >> >> WISH YOU A HAPPY DIWAL

Re: $$Excel-Macros$$ Re: Kindly Help

2011-10-22 Thread Dilip Pandey
Hi Karan, You can use below formula to achieve the desired results. Sample sheet is also attached with this email for your quick reference. =MID(A1,SEARCH(")",A1),(SEARCH("Enrol",A1)+4-SEARCH(")",A1))+1) Regards, DILIPandey On 10/21/11, karan 1237 wrote: > I'v around 8,000 cell like this. I'

Re: $$Excel-Macros$$ How to learn vba

2011-10-22 Thread Dilip Pandey
jus want to know any site to start > with as a beginner... > > With Thanks > CA Sandeep Chhajer > Sent on my BlackBerry® from Vodafone > > -Original Message- > From: Dilip Pandey > Sender: excel-macros@googlegroups.com > Date: Sat, 22 Oct 2011 2

Re: $$Excel-Macros$$ How to learn vba

2011-10-22 Thread Dilip Pandey
ds > CA Sandeep Kr Chhajer. > > Sent on my BlackBerry® from Vodafone > > -----Original Message- > From: Dilip Pandey > Sender: excel-macros@googlegroups.com > Date: Fri, 21 Oct 2011 11:09:04 > To: > Reply-To: excel-macros@googlegroups.com > Subject: Re: $$Excel-

Re: $$Excel-Macros$$ How to learn vba

2011-10-20 Thread Dilip Pandey
Hi, Below are the explanation of looping codes:- Looping codes Do While/ Until "conditon" Exit Do Loop ` Do - - Exit Do - - Loop While / Until "condition"

Re: $$Excel-Macros$$ Extract from date and time

2011-10-18 Thread Dilip Pandey
Hi, Assuming you have the data in cell a1, you can use following two formula for date n time respectively. =DATE(MID(A1,SEARCH("/",A1,SEARCH("/",A1)+1)+1,4),MID(A1,SEARCH("/",A1)+1,(SEARCH("/",A1,SEARCH("/",A1)+1)-SEARCH("/",A1)-1)),LEFT(A1,SEARCH("/",A1)-1)) =TIME(MID(A1,SEARCH(" ",A1)+1,SEARCH

Re: $$Excel-Macros$$ How to extract number in cell

2011-10-16 Thread Dilip Pandey
Excellent formula Sam... Awesome Regards, DILIPandey On 10/16/11, Sam Mathai Chacko wrote: > In keeping with Noorain's VBA function, use this formula as an array. This > extracts all numbers irrespective of whether the numbers are together, or > scattered across the text like ABC123DEF, or A

Re: $$Excel-Macros$$ How to extract number in cell

2011-10-16 Thread Dilip Pandey
Nice work Don..!! Regards, DILIPandey On 10/16/11, dguillett1 wrote: > Array formula solution > > =1*MID(J3,MATCH(TRUE,ISNUMBER(1*MID(J3,ROW($1:$9),1)),0),COUNT(1*MID(J3,ROW($1:$9),1))) > > Macro > Sub ExtractNumbers() > Dim r As Range > Dim s As String > Dim v As Variant > > Set r = Range

RE: $$Excel-Macros$$ Formula needed to extract the text from string

2011-10-16 Thread Dilip Pandey
You are welcome. Regards, DILIPandey On 16 Oct 2011 14:16, "Anil Bhange" wrote: > Amazing... I know this group can help me... it save my lot of time... > > Thanks Dilip & Ashish > > Regards,Anil Bhange > IP Phone - 512320 | Mobile - 90290 32123 > > --

Re: $$Excel-Macros$$ How to learn vba

2011-10-15 Thread Dilip Pandey
Hi Mr. Excel, I would suggest you to enable recording and do whatever you want to do in Excel window. Now go to code window (Alt + F11) and see how Excel transformed your actions into vba code and try to understand that. Change some references there and play that again to see your edited actions.

Re: $$Excel-Macros$$ Formula needed to extract the text from string

2011-10-15 Thread Dilip Pandey
Hi Anil, You can use following two formula for your two columns respectively:- =MID(B7,SEARCH("ORIG:",B7)+5,(SEARCH("ID:",B7)-1-SEARCH("ORIG:",B7)-5)) =MID(E7,SEARCH("BNF:",E7)+4,(SEARCH("ID:",E7)-1-SEARCH("BNF:",E7)-4)) Sample sheet is also attached for your better understanding. Regards, DIL

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

2011-10-13 Thread Dilip Pandey
Hi Prathap, If this is one time exercise then, write 100 somewhere in and copy it. Now select the data and apply paste special - > Values -> Divide. If this is kinda template where figures will come and go, then you can use custom format. Regards, DILIPandey On 10/13/11, Prathap wrote: > H

Re: $$Excel-Macros$$ Formula Sorting Data (Alpha + Numeric)

2011-10-13 Thread Dilip Pandey
Hi, In the Sorted list, you have shown 92C, 94B, 94C... This is not sorted as per alphabet order and neither it is in numeric (Descending) and same goes with 193, 195, 52, 86. Kindly explain the order. Thanks Regards, DILIPandey On 10/14/11, B Sharma wrote: > Dear Don & other experts > >

Re: $$Excel-Macros$$ Formula Sorting Data (Alpha + Numeric)

2011-10-13 Thread Dilip Pandey
Hi, The query is not easy but remember this group is awsome which can handle these types of query. See the attachment where I have tried sorting the data numeric/ alphanumeric. Regards, DILIPandey On 13 Oct 2011 19:17, "B Sharma" wrote: > Dear Excel Experts (and to my friends who have ans

Re: $$Excel-Macros$$ Most Helpful Member Sep'11 - Noorain Ansari

2011-10-13 Thread Dilip Pandey
Congratulations NOORAIN. sorry for late responss as I was running behind on my email. Regards, DILIPandey On 2 Oct 2011 00:43, "Ayush Jain" wrote: > Hello Everyone, > > Noorain Ansari has been selected as 'Most Helpful Member' for the month of > Sept'11 > He has posted 140 posts in sept 2011 an

Re: $$Excel-Macros$$ Thanks everyone.

2011-10-13 Thread Dilip Pandey
Heartiest congratulations Ayush. Sorry I missed this email. Regards, DILIPandey On 4 Oct 2011 00:15, "Ayush Jain" wrote: > Dear members, > > I am proud to share that I have been re-awarded the Micrososft MVP award in > 2011. My deep thanks to each group member for all your support and > contrib

Re: $$Excel-Macros$$ can we change hard copy in excel

2011-10-13 Thread Dilip Pandey
Hi Anil, Not sure if you are asking to edit a scanned excel sheet. Please elaborate. Thanks. Regards, DILIPandey On 13 Oct 2011 15:15, "anil kumar" wrote: > Hi frineds, > > > can we change a hard copy of data in excel by scanner. > > > Regards & Thanks > > Anil > > -- > > ---

RE: $$Excel-Macros$$ Selecting a date from a database, which equal to or lesser than the selected date

2011-10-13 Thread Dilip Pandey
Solution revised. Thanks Sam for the catch. Regards, DILIPandey On 13 Oct 2011 14:11, "Dilip Pandey" wrote: -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and lin

RE: $$Excel-Macros$$ Selecting a date from a database, which equal to or lesser than the selected date

2011-10-13 Thread Dilip Pandey
> > -Original Message- > From: Dilip Pandey [mailto:dilipan...@gmail.com] > Sent: 13-Oct-2011 11:39 AM > To: BS > Cc: excel-macros@googlegroups.com > Subject: Re: $$Excel-Macros$$ Selecting a date from a database, which equal > to or lesser than the selected date >

Re: $$Excel-Macros$$ Shortcut key for Border

2011-10-12 Thread Dilip Pandey
Nice collection Noorain... Regards, DILIPandey On 10/12/11, NOORAIN ANSARI wrote: > Dear Ankit, > > Please find below Short Cut keys,I hope it will help to you. > > 1. *Apply* an outline border > *[Ctrl]+[Shift]+[&] * > > 2. Remove the outline border > *[Ctrl]+[Shift]+[_] * > > 3. Toggle the lef

Re: $$Excel-Macros$$ Selecting a date from a database, which equal to or lesser than the selected date

2011-10-12 Thread Dilip Pandey
receding to the given criteria. > > Thanks & Regards, > B. Sharma > > > > > -Original Message- > From: Dilip Pandey [mailto:dilipan...@gmail.com] > Sent: 13-Oct-2011 12:54 AM > To: excel-macros@googlegroups.com > Cc: sharma@gmail.com > Subject: Re: $$Ex

Re: $$Excel-Macros$$ Selecting a date from a database, which equal to or lesser than the selected date

2011-10-12 Thread Dilip Pandey
Hi, Use the formula :- =OFFSET($A$1,MATCH($B$1,$A$1:$A$6,1)-1,0) Sample worksheet is also attached for your ready reference. Let me know if this suits your requirements. Regards, DILIPandey On 10/12/11, B Sharma wrote: > Dear Excel Experts > I want to select a date which is either equals

Re: $$Excel-Macros$$ Unable to change date fromate

2011-10-12 Thread Dilip Pandey
Hi Suman, Attached file has the solution. As the dates provided by you, were in Text format, hence I multiplied them by 1 and then just changed the format in mm/dd/. Let me know in case of any queries. Regards, DILIPandey On 10/11/11, Suman wrote: > Hi, > Good evening to all, > Please help

Re: $$Excel-Macros$$ Formula needed to extract the text from string

2011-10-12 Thread Dilip Pandey
Hi Anil, Designed a formula using Substitute function. See the attachment and let me know if this helps. Regards, DILIPandey On 10/12/11, Anil Bhange wrote: > Hi Expert, > > I needed the formula which can extract the specific content from a Text, > below is some sample excel cells > > To simpl

Re: $$Excel-Macros$$

2011-10-10 Thread Dilip Pandey
e Full address of Cell.. > > ='workbookPath\WorkbookName[sheetName]'!CellAddress > > On Thu, Oct 6, 2011 at 11:14 PM, Dilip Pandey wrote: > >> Good job Rajan... !! >> >> Few months back, I also had one software viz Bad Copy Pro which I used >> to recover c

Re: $$Excel-Macros$$ Formula to LOOKUP a value in a table and return the table header value

2011-10-07 Thread Dilip Pandey
l I3 (through I13)? > > I marked up the spreadsheet for my new question. > > Thanks for the help with the formula, it works great. > > John > > On Fri, Oct 7, 2011 at 10:00 AM, Dilip Pandey wrote: > >> Hi John, >> >> Please find attached the solved workshe

Re: $$Excel-Macros$$ can I unprotect a sheet

2011-10-07 Thread Dilip Pandey
Hi Anil, see the below link. www.straxx.com/excel/password.html Regards, DILIPandey On 7 Oct 2011 13:12, "anil kumar" wrote: > Hello everybody, > > I have a excel file in which i use protect op. but I have forgot password. > becoz i use this file some time not daily. > If we can unprotect sheet

Re: $$Excel-Macros$$ Excel is showing Error

2011-10-06 Thread Dilip Pandey
Just an additional check. Verify if there are some objects lying at the boarder of the worksheet. See the attachment for better understanding. Feel free to get back in case of any queries. Regards, DILIPandey On 10/6/11, Sam Mathai Chacko wrote: > I wasn't able to see the picture earlier. Stra

Re: $$Excel-Macros$$ Conditional Formatting Highlight of Changed Cells

2011-10-06 Thread Dilip Pandey
Hi Craig, Please find the solution attached as a sample. It has the same idea as suggested by Sam. Thanks. Feel free to get back in case of any queries. Regards, DILIPandey On 10/6/11, Craig Brandt wrote: > Conditional Formatting Highlight of Changed Cells > I have a large spreadsheet where

Re: $$Excel-Macros$$

2011-10-06 Thread Dilip Pandey
Good job Rajan... !! Few months back, I also had one software viz Bad Copy Pro which I used to recover corrupted fils, which I lost - not sure if you also have such kind of software. Thanks, DILIPandey On 10/6/11, rajan verma wrote: > hi > See the attached Workbook,i think some Content of thi

Re: $$Excel-Macros$$ vlookup , index - Reg

2011-09-20 Thread Dilip Pandey
Hi Mothilal, Nesting limit for function(s) is 6+1 but this is not applicable in your case here. Not sure why this is happening, try attaching a sample file for better understanding of the Group. Thanks Regards, DILIPandey On 9/20/11, jmothilal wrote: > Dear Friends, > > Any limit is there vloo

Re: $$Excel-Macros$$ Rajan Verma : Most Helpful Member - August'11

2011-09-06 Thread Dilip Pandey
Congratulations. . . Keep up the good work. Regards, DILIPandey On 5 Sep 2011 23:00, "Ayush Jain" wrote: > Hello Everyone, > Rajan Verma has been selected as 'Most Helpful Member' for the month of > August'11 > He has posted 152 posts in August 2011 and helped many people through his > expertise.

Re: $$Excel-Macros$$ copy cell value from clicked hyperlink

2011-08-17 Thread Dilip Pandey
Hi Vickey, Hyperlink can never copy values from one place to another, hence given a two line code which will help you :) Let me know if this helps you. Regards, DILIPandey On 8/4/11, vickey wrote: > Hi, > > Thanks for the same,but my problem has not yet been solved... > > Please refer att

Re: $$Excel-Macros$$ Creating Linked Drop-Downs in a User form

2011-08-04 Thread Dilip Pandey
I got the point, can you attach a sample file for me to apply revised logic. Regards, DILIPandey On 8/4/11, tuffhu...@yahoo.com wrote: > Thanks for the time. However, it's not quite what I was looking for. > > I am trying to design a user form that basically interviews the user. The > first qu

Re: $$Excel-Macros$$ Mostly Uses Excel 2007 Short cut key

2011-08-03 Thread Dilip Pandey
Nice collection. . . Regards, DILIPandey On 8/4/11, NOORAIN ANSARI wrote: >*Short Key* *Activity* Alt+A+Q Advance Filter Alt+D+F+A Advance Filter > Alt+D+P Pivot Table Alt+E+I+S Fill Series Alt+E+L Delete Sheet Alt+H+B For > Border Alt+H+F Font Colour Alt+H+F+P Format Painter Alt+H+FF Font A

Re: $$Excel-Macros$$ Plz help me how can posible

2011-08-03 Thread Dilip Pandey
Hi, I just replied to this post, but wonder where that gone. Anil, please wait for some time and search that again. Let me know if you do not find the same, I'll send another one. Regards, DILIPandey On 8/4/11, Anil Saxena wrote: > Hi All, > Plz find the attached file and solved this query. > H

Re: $$Excel-Macros$$ Creating Linked Drop-Downs in a User form

2011-08-03 Thread Dilip Pandey
Hi Rob, Attached is the solution to your query. It may not be a perfect one, but tried it as it came to mind :) Regards, DILIPandey On 8/4/11, tuffhu...@yahoo.com wrote: > Hello! > > First post, so bear with me. > > I'm a novice VBA user (and love it!), but here is what I want to do: > I want t

Re: $$Excel-Macros$$ copy cell value from clicked hyperlink

2011-08-03 Thread Dilip Pandey
Hi Vickey, Based on your description, attached is the solution. Let us know if this works. Thanks, DILIPandey On 8/3/11, vickey wrote: > Is there any way to to get cell value from clicked cell hyperlink. > > i.e. if there is sr.no. 1 in cell A1 in sheet1 and it is hyper linked > with sheet2 th

Re: $$Excel-Macros$$ Microsoft Excel 2010 function translations

2011-08-03 Thread Dilip Pandey
Nice work!! Thanks, DILIPandey On 8/4/11, XLS S wrote: > Hey All, > > > In Microsoft Excel the names of functions depend on the language of > the installed version of MS-Office. Here's a table containing the > Excel function names in 16 languages > -- > . > > -- > ---

Re: $$Excel-Macros$$ What is the Mean of Working Day??

2011-08-03 Thread Dilip Pandey
ha ha ha!! This is a kind of dilemma which every user experiences while working with Date & Time calculations. Best option is to define the holidays and use functions like networkday and workday. Regards, DILIPandey On 8/4/11, XLS S wrote: > Working days = M-F in certain countries. S-F in s

Re: $$Excel-Macros$$ Rajan Verma : Most Helpful Member - July'11

2011-08-03 Thread Dilip Pandey
Congratulations Rajan...!! Regards, DILIPandey On 8/3/11, Ayush Jain wrote: >> >> Hello Everyone, >>> >>> Rajan Verma has been selected as 'Most Helpful Member' for the month of >>> July'11 >>> He has posted 170 posts in July 2011 and helped many people through his >>> expertise. He has been c

Re: $$Excel-Macros$$ Poem - जोर से बोलो दम लगा के जय, Excel -Macro परिवार.

2011-08-01 Thread Dilip Pandey
Hey Noorain... you are good poet.. with wonderful vocabulary.. this is awsome.. Thanks, DILIPandey On 7/30/11, NOORAIN ANSARI wrote: > Dear Experts, > > I have written a poem on our group to complete 8000 Members in EXCEL-MACRO > faimly. > read and Enjoy... > > जहा रोज सैकड़ों Questi

Re: $$Excel-Macros$$ Interesting Question

2011-07-29 Thread Dilip Pandey
You are welcome. . . Regards, DILIPandey On 7/29/11, XLS S wrote: > Thnx Sir > > On Fri, Jul 29, 2011 at 10:31 AM, Dilip Pandey wrote: > >> Hi, >> >> I have used offset function to achieve the desired result. >> Refer the attachment and let me know if this

Re: $$Excel-Macros$$ Reverse Sorting Of Rows

2011-07-28 Thread Dilip Pandey
Cheers. . Thanks, DILIPandey On 7/28/11, qcan wrote: > THANK YOU EVERYONE. I am in awe with the knowlege you guys have. WELL > DONE ! > > On Jul 27, 2:25 am, "Rajan_Verma" wrote: >> Try this.. >> >> Sub Reverse() >> >>  Dim fRng As Range >> >>  Dim Couter As Integer >> >>  Dim cell As Range >>

Re: $$Excel-Macros$$ Interesting Question

2011-07-27 Thread Dilip Pandey
Please share the sample file. Regards, DILIPandey On 7/27/11, XLS S wrote: > function > > On Wed, Jul 27, 2011 at 10:55 AM, Dilip Pandey wrote: > >> Ok... do you need solution in VBA or Function. >> Also it would be great if you can share a sample workbook. >

Re: $$Excel-Macros$$ Interesting Question

2011-07-26 Thread Dilip Pandey
Ok... do you need solution in VBA or Function. Also it would be great if you can share a sample workbook. Regards, DILIPandey On 7/27/11, XLS S wrote: > Hello Friend, > > > Suppose that, i have one excel sheet their is more then 50 columns and 100 > rows, i want extract data 20 rows and 41 colum

Re: $$Excel-Macros$$ Reverse Sorting Of Rows

2011-07-26 Thread Dilip Pandey
Hi, You can refer to following link by Microsoft - http://support.microsoft.com/kb/324991 Regards, DILIPandey On 7/27/11, XLS S wrote: > Dilip sir, > > i want to learn offset function, please provide the basic tips and example > > On Wed, Jul 27, 2011 at 9:59 AM, Dilip Pandey

Re: $$Excel-Macros$$ Reverse Sorting Of Rows

2011-07-26 Thread Dilip Pandey
Hi, You can use following formula in the next column and drag it down till you have data. =OFFSET($A$1,COUNTA(A:A)-ROW(A1),0) Sample file is also attached. Regards, DILIPandey On 7/27/11, qcan wrote: > Hi, > > A little different request here. I am looking for a way to reverse > sort rows: > >

Re: $$Excel-Macros$$ Hi Everybody

2011-07-26 Thread Dilip Pandey
Nice portal and it is offering more solutions related to HR, not just MIS reports.. Thanks, DILIPandey On 7/27/11, XLS S wrote: > Hey, > > Please register and download any HR related MIS report > > http://www.citehr.com/ > > On Tue, Jul 26, 2011 at 5:29 PM, Sanjay Maurya > wrote: > >> Hi >> >> A

Re: $$Excel-Macros$$ Difference between Array formula and Normal Formula...

2011-07-26 Thread Dilip Pandey
Hi Venkat, Check following links:- www.cpearson.com/excel/array.htm www.ozgrid.com/Excel/arrays.htm Regards, DILIPandey On 7/26/11, Venkat CV wrote: > Dear All, > > any one Explain Difference between Array formula and Normal Formula... > > With Examples..&Use of Array formulas ... > > *Best Re

Re: $$Excel-Macros$$ Two major milestones : 8000 members and 1000+ posts

2011-07-26 Thread Dilip Pandey
Great achievement. Best of luck. Regards, DILIPandey On 7/26/11, Ayush wrote: > Dear members, > > I am glad to share that this forum has achieved two major milestones this > month. The number of members have reached 8000 and 1000 posts in a month > which is highest in forum history. > The credi

Re: $$Excel-Macros$$ Data Validation - Create a drop down list containing only unique

2011-07-24 Thread Dilip Pandey
Hi Venkat, I have managed to solve your query using defined Names in Excel. Let me know if this works. Regards, DILIPandey On 7/24/11, Venkatesan c wrote: > Dear All, > > I have attached sheet contains my query on Data Validation - Create a drop > down list containing only unique > > > -- > *B

Re: $$Excel-Macros$$ HI --help me

2011-07-24 Thread Dilip Pandey
Hi Vijayajith, It depends which report having what kind of formula / function / macros you are working on. I have came across following errors so far:- 1) Excel Function errors -> Can be corrected using ISError function(s) 2) VBA Macros -> Can be prevented using Error handlers 3) Linking errors

Re: $$Excel-Macros$$ Strange Issue with Macro

2011-07-12 Thread Dilip Pandey
Subject: RE: $$Excel-Macros$$ Strange Issue with Macro >> > >> > How Did u increase range by code or by name wizard?? Can you attached >> > Sample File >> > >> > -Original Message- >> > From: excel-macros@googlegroups.com >>

Re: $$Excel-Macros$$ Strange Issue with Macro

2011-07-09 Thread Dilip Pandey
Hi Hanumant It is interesting.. I am assuming that code first changes the range for the name and then the same is getting used. Try changing the order or refresh (Calculate) the sheet. If possible, share the test file. Best Regards, DILIPandey On 7/9/11, hanumant shinde wrote: > Hi friends, >

Re: $$Excel-Macros$$ Excel Formula needed-Urgent help

2011-07-09 Thread Dilip Pandey
Hi Vinod, Please share the test file. Regards, DILIPandey On 7/8/11, vinod rao wrote: > Hi, > I have put a pivot table and i need to get Gross% starting from 0% and above > data listed in pivot. Can i know how to get in pivot by by adding formula? > My data has both -ve and +v % but what i need

Re: $$Excel-Macros$$ count unique values

2011-07-04 Thread Dilip Pandey
Nice explanation Haseeb (HTH).. !! Regards, DILIPandey On Tue, Jul 5, 2011 at 12:34 AM, Haseeb Avarakkan < haseeb.avarak...@gmail.com> wrote: > Hello AIren, > > Consider B1:B6 we have these values; > > B1=1 > B2=1 > B3=Blank > B4=A > B5=Blank > B6=Blank > > =SUMPRODUCT((B1:B6<>"")/**COUNTIF(B1:B

Re: $$Excel-Macros$$ Ashish Koul : Most Helpful Member - June'11

2011-07-04 Thread Dilip Pandey
Congratulations Ashish...!! you Rock :) Regards, DILIPandey On 7/4/11, Ayush Jain wrote: >> >> Hello Everyone, >> >> Ashish Koul has been selected as 'Most Helpful Member' for the month of >> June'11 >> He has posted 53 posts in June 2011 and helped many people through his >> expertise. He ha

Re: $$Excel-Macros$$ count unique values

2011-07-04 Thread Dilip Pandey
Hi Airen, This is the beauty of SumProduct function. Below is the explanation:- If you evaluate the formula in parts, you will get following look: =SUMPRODUCT(({TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;T

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

2011-07-04 Thread Dilip Pandey
Hi Anshul, As per the latest scenario provided by you, attached solution may help you. Let me know if this works :) Regards, DILIPandey On 7/4/11, Anshul Gupta wrote: > Hi All > > No boss this is also not working see i show you what excatly i want > > 202.718 > 198.724 > 200.178 > 202.867 > 195

Re: $$Excel-Macros$$ Sumif across multiple worksheets

2011-07-04 Thread Dilip Pandey
he same criteria , and summing > different ranges. > > I tried SUMPRODUCT(SUM(IF... > I tried SUM(IF and inserting a + before each proceeding IF > > Neither of those worked. > > > What about using INDEX? Thou I am not familiar with that formula... > also, how about VLOOKUP w

Re: $$Excel-Macros$$ Sumif across multiple worksheets

2011-07-04 Thread Dilip Pandey
again? > > Sunnie :-) > > On Jun 30, 11:26 pm, Dilip Pandey wrote: > > Hi Sunnie, > > > > It can be sorted out using simple SUM function. Look at the below > formula:- > > > > > {=SUM(IF(D2:D6=G3,E2:E6,""),IF(Sheet3!D11:D18=G3,Sheet3!E11:E18,

Re: $$Excel-Macros$$ Macro to copy and paste selected raws.xls

2011-07-02 Thread Dilip Pandey
You are welcome. . . Regards, DILIPandey On 7/2/11, Atul wrote: > Thnaks you Pandeyji. ITs working fine > > On Jun 29, 2:45 am, Dilip Pandey wrote: >> Hi Atul, >> >> You were clear in the first email itself.  It is my mistake that I had >> overlooked the point

Re: $$Excel-Macros$$ and the Microsoft MVP award goes to Ashish Koul :)

2011-07-01 Thread Dilip Pandey
Heartiest congratulations Ashish . . !! This is well deserved, keep the helping spirit high. Best regards, DILIPandey On 7/1/11, Ayush wrote: > Dear Group, > I am extremely happy to share a good news with you. One of our dearest group > member 'Ashish Koul' is awarded Microsoft MVP award on 1st

Re: $$Excel-Macros$$ Macro causing drawing objects to be deleted

2011-06-29 Thread Dilip Pandey
This is interesting... can you forward the sample file. Best Regards, DILIPandey On 6/29/11, 0 1 wrote: > The objects are locked. The object lock settings on the problem PC are > identical to those on the PCs not experiencing the problem. > > -- >

Re: $$Excel-Macros$$ Extract a comment and paste in adjacent cell

2011-06-29 Thread Dilip Pandey
Hi Heather, Check the below link:- http://chandoo.org/wp/2009/09/03/get-cell-comments/ Best Regards, DILIPandey On 6/29/11, Heather wrote: > I would like to extract comments and paste it next to the cell. > > For example: > The comment in cell A1 would be pasted in B1 > The comment in cell A2

Re: $$Excel-Macros$$ Extract values from cell

2011-06-25 Thread Dilip Pandey
Hi Kashan, You can use following formula in column B and C respectively =SUBSTITUTE(A1,C1,"") =IF(VALUE(LEFT(MID(A1,SEARCH("ltr",A1)-1,50)))=0,MID(A1,SEARCH("ltr",A1)-2,50),MID(A1,SEARCH("ltr",A1)-1,50)) If you could provide some large set of data, that would have been great to develop the full

Re: $$Excel-Macros$$ How to learn VSTO with excel.

2011-06-23 Thread Dilip Pandey
Hi, MSDN library would help... see the below link:- http://msdn.microsoft.com/en-us/vsto/dd162436 Best Regards, DILIPandey On 6/22/11, Mr excel wrote: > hi all, > > I want to learn VSTO for excel.anybody please give me the notes,pdf or > urls for learning. > > thanks & regards... > > -- > --

Re: $$Excel-Macros$$ Macro causing drawing objects to be deleted

2011-06-23 Thread Dilip Pandey
Just a thought, check if the object is locked (from object properties). I believe objects generally shifts up / down when you delete rows. Might be something happening between migration from / to 2003 and 2007 version. This is interesting and there are learners who wish to know the main cause of

Re: $$Excel-Macros$$ Need Tutorial for VBA

2011-06-23 Thread Dilip Pandey
Hi Gagan, If you have already secured good knowledge of Excel, then I would suggest you to go for something like, crash course of Excel Programming. This will save definitely save your lots of time. You can get these types of e-books over internet. Thanks. Best Regards, DILIPandey On 6/23/11,

Re: $$Excel-Macros$$ I want Institute or Sites to Learn VBA

2011-06-16 Thread Dilip Pandey
Hi, I would suggest to follow Microsoft online tutorials & help OR Google for "Excel-VBA tutorial for beginners". Best Regards, DILIPandey On 6/15/11, Shaik Waheed wrote: > Dear Experts, > > As I am beginner in VBA, please suggest me any institute in Hyderabad or any > best sites which can gi

Re: $$Excel-Macros$$ Pad zeros

2011-06-16 Thread Dilip Pandey
Hi Skanda, Assuming the data provided by you is in Column A, use following formula:- =REPT(0,9-LEN(A2))&A2 Sample worksheet is attached herewith. Let me know if this helps. Best Regards, DILIPandey On 6/17/11, Skanda wrote: > Hi, > How to add zeros in front of a value with varying lengths s

  1   2   3   4   5   6   7   8   9   >