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
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
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
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,
>
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
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
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
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
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
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
>
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
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
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
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
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:
;
> Dear Dilip Thanx,
>
> ** **
>
> ** **
>
> ** **
>
> Regards,
>
> Muneer,
>
> CC….****
>
> ** **
> --
>
> *From:* Dilip Pandey [mailto:dilipan...@gmail.com]
> *Sent:* Saturday, March 10, 2012 1:41 PM
> *To:* excel
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
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,
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
>
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
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
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
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
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.
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
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
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:
>
>
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.
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
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'
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
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-
Hi,
Below are the explanation of looping codes:-
Looping codes
Do While/ Until "conditon"
Exit Do
Loop
`
Do
-
-
Exit Do
-
-
Loop While / Until "condition"
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
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
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
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
>
> --
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.
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
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
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
>
>
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
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
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
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
>
> --
>
> ---
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
>
> -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
>
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
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
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
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
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
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
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
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
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
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
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
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
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.
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
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
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
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
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
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
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
> --
> .
>
> --
> ---
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
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
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
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
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
>>
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.
>
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
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
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:
>
>
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
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
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
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
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
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
>>
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,
>
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
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
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
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
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
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
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,
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
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
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.
>
> --
>
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
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
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...
>
> --
> --
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
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,
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
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 - 100 of 828 matches
Mail list logo