that two members 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 MVP
--
FORUM RULES (986
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 silkyro...@gmail.com wrote:
Hi Experts
I want to Lookup PO No. from Lookup data and return all results if
:
thanks Mr Pandey
On Sat, Jun 9, 2012 at 3:03 PM, Dilip Pandey dilipan...@gmail.com 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,
DILIPandey
On 6/9/12, Amit Gandhi silkyro
Heartiest congratulations Don .. cheers :)
Regards,
DILIPandey
On 4/14/12, Ayush Jain jainayus...@gmail.com 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
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 sajidwi...@hotmail.com wrote:
Hi,bro! What's up? You know what. Recently I find a really nice website,
Congratulations.. Ayush.. this groups is awesome.
Best of luck.
Regards,
DILIPandey
On 3/22/12, Ayush Jain jainayus...@gmail.com 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
Hi Shrini,
See the attached file and let me know if this helps somehow :)
Regards,
DILIPandey
On 3/24/12, Shrinivas Shevde shrinivas...@gmail.com 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
Thanks Noorain... you are awesome and multi - talented..
regards,
DILIPandey
On Fri, Mar 23, 2012 at 10:56 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
Fantablus!!
** **
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *xlstime
*Sent:*
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 i have
Congratulations Noorain
Keep up the good work and keep helping :)
Regards,
DILIPandey
On Thu, Mar 15, 2012 at 11:31 AM, Abhishek Jain abhishek@gmail.comwrote:
Many congratulations Noorain bro!
Keep up the good work and keep helping us mere mortals in excelling our
lives. :)
God
Nice collection ... Noorain.
Regards,
DILIPandey
On Mon, Mar 12, 2012 at 12:44 PM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Hi dnkndnkn,
Please find attached Ebook for VBA beginner.
On Sun, Mar 11, 2012 at 6:21 PM, dnkndnkn dnknd...@gmail.com wrote:
The syntax of VBA is different
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:
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
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 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
,
** **
** **
** **
Regards,
Muneer,
CC….
** **
--
*From:* Dilip Pandey [mailto:dilipan...@gmail.com]
*Sent:* Saturday, March 10, 2012 1:41 PM
*To:* excel-macros@googlegroups.com
*Cc:* Mohammed Muneer
*Subject:* Re: $$Excel-Macros$$ Pivot
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 sushil@gmail.com wrote:
Hi,
i am using =networkdays(A1,today()) and cell A1 is
Congratulations Noorain...
Keep it up.
Regards,
DILIPandey
On 2/1/12, Ayush Jain jainayus...@gmail.com 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.
xlstartup
exist.
Try this
if not possible one more solution is there..
On 1/29/12, Dilip Pandey dilipan...@gmail.com wrote:
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
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.
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
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 Sheet
Congratulations Rajan..!!
Keep up the good work. Have a wonderful year ahead.
Regards,
DILIPandey
On 1/3/12, Ayush Jain jainayus...@gmail.com 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
Heartiest Congratulations Sam keep up the helping spirit.
Regards,
DILIPandey
On 12/2/11, Ayush Jain jainayus...@gmail.com 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
Congratulations Sam, you are wonderful.
Regards,
DILIPandey
On 2 Nov 2011 01:20, Sam Mathai Chacko samde...@gmail.com 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
A very happy Diwali to all the Group members. Enjoy. :)
Regards,
DILIPandey
On 26 Oct 2011 23:02, xlstime xlst...@gmail.com 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
CA Sandeep Kr Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Dilip Pandey dilipan...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Fri, 21 Oct 2011 11:09:04
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: Re
server...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 dilipan...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Sat, 22 Oct 2011 22:16:15
To: excel
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 karan1...@gmail.com wrote:
I'v around 8,000 cell
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(:,A1)-SEARCH(
Message-
From: Dilip Pandey [mailto:dilipan...@gmail.com]
Sent: Saturday, October 15, 2011 09:59 PM
To: excel-macros@googlegroups.com
Cc: Noor Ali Sayyed; Anil Bhange
Subject: Re: $$Excel-Macros$$ Formula needed to extract the text from
string
Hi Anil,
You can use following two formula
Nice work Don..!!
Regards,
DILIPandey
On 10/16/11, dguillett1 dguille...@gmail.com 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
Excellent formula Sam... Awesome
Regards,
DILIPandey
On 10/16/11, Sam Mathai Chacko samde...@gmail.com 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
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
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: $$Excel-Macros$$ Selecting a date from a database, which equal
to or lesser
Nice collection Noorain...
Regards,
DILIPandey
On 10/12/11, NOORAIN ANSARI noorain.ans...@gmail.com 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.
..
-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
Oops... apologies.
I was relying only
Solution revised.
Thanks Sam for the catch.
Regards,
DILIPandey
On 13 Oct 2011 14:11, Dilip Pandey dilipan...@gmail.com wrote:
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks
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 kmr7a...@gmail.com wrote:
Hi frineds,
can we change a hard copy of data in excel by scanner.
Regards Thanks
Anil
--
Heartiest congratulations Ayush.
Sorry I missed this email.
Regards,
DILIPandey
On 4 Oct 2011 00:15, Ayush Jain jainayus...@gmail.com 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
Congratulations NOORAIN.
sorry for late responss as I was running behind on my email.
Regards,
DILIPandey
On 2 Oct 2011 00:43, Ayush Jain jainayus...@gmail.com wrote:
Hello Everyone,
Noorain Ansari has been selected as 'Most Helpful Member' for the month of
Sept'11
He has posted 140 posts
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 sharma@gmail.com wrote:
Dear Excel Experts (and to my
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 sharma@gmail.com wrote:
Dear Don
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
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 anil.bha...@tatacommunications.com wrote:
Hi Expert,
I needed the formula which can extract the specific content from a Text,
below is some
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 ksuman1...@gmail.com wrote:
Hi,
Good evening to
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 sharma@gmail.com wrote:
Dear Excel Experts
I want to select a date
of Cell..
='workbookPath\WorkbookName[sheetName]'!CellAddress
On Thu, Oct 6, 2011 at 11:14 PM, Dilip Pandey dilipan...@gmail.comwrote:
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
Hi Anil,
see the below link.
www.straxx.com/excel/password.html
Regards,
DILIPandey
On 7 Oct 2011 13:12, anil kumar kmr7a...@gmail.com 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
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 dilipan...@gmail.comwrote:
Hi John,
Please find attached the solved worksheet. Let me know if this works.
Thanks.
Regards
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 rajanverma1...@gmail.com wrote:
hi
See the attached Workbook,i
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 craigbran...@gmail.com wrote:
Conditional Formatting Highlight of Changed Cells
I have a
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 samde...@gmail.com wrote:
I wasn't able to see the
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 gjmothi...@gmail.com wrote:
Dear Friends,
Any
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 vikasda...@gmail.com wrote:
Hi,
Thanks for the same,but my problem has not yet been solved...
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 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
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 anilsaxena170...@gmail.com wrote:
Hi All,
Plz find the attached file
Nice collection. . .
Regards,
DILIPandey
On 8/4/11, NOORAIN ANSARI noorain.ans...@gmail.com 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
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 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
Congratulations Rajan...!!
Regards,
DILIPandey
On 8/3/11, Ayush Jain jainayus...@gmail.com 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
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 xlst...@gmail.com wrote:
Working days = M-F in certain
Nice work!!
Thanks,
DILIPandey
On 8/4/11, XLS S xlst...@gmail.com 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
--
.
Hi Vickey,
Based on your description, attached is the solution. Let us know if this works.
Thanks,
DILIPandey
On 8/3/11, vickey vikasda...@gmail.com 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
You are welcome. . .
Regards,
DILIPandey
On 7/29/11, XLS S xlst...@gmail.com wrote:
Thnx Sir
On Fri, Jul 29, 2011 at 10:31 AM, Dilip Pandey dilipan...@gmail.com wrote:
Hi,
I have used offset function to achieve the desired result.
Refer the attachment and let me know if this works
Cheers. .
Thanks,
DILIPandey
On 7/28/11, qcan comeonove...@gmail.com wrote:
THANK YOU EVERYONE. I am in awe with the knowlege you guys have. WELL
DONE !
On Jul 27, 2:25 am, Rajan_Verma rajanverma1...@gmail.com wrote:
Try this..
Sub Reverse()
Dim fRng As Range
Dim Couter As Integer
Please share the sample file.
Regards,
DILIPandey
On 7/27/11, XLS S xlst...@gmail.com wrote:
function
On Wed, Jul 27, 2011 at 10:55 AM, Dilip Pandey dilipan...@gmail.com wrote:
Ok... do you need solution in VBA or Function.
Also it would be great if you can share a sample workbook
Great achievement.
Best of luck.
Regards,
DILIPandey
On 7/26/11, Ayush jainayus...@gmail.com 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
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 venkat1@gmail.com wrote:
Dear All,
any one Explain Difference between Array formula and Normal Formula...
With Examples..Use of Array formulas
Nice portal and it is offering more solutions related to HR, not just
MIS reports..
Thanks,
DILIPandey
On 7/27/11, XLS S xlst...@gmail.com 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
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 comeonove...@gmail.com wrote:
Hi,
A little different request here. I am looking for a way to
Hi,
You can refer to following link by Microsoft -
http://support.microsoft.com/kb/324991
Regards,
DILIPandey
On 7/27/11, XLS S xlst...@gmail.com 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
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 xlst...@gmail.com 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
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 -
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 venkat1@gmail.com wrote:
Dear All,
I have attached sheet contains my query on Data Validation - Create a drop
down list containing only
@googlegroups.com
[mailto:excel-macros@googlegroups.com]
On Behalf Of Dilip Pandey
Sent: Saturday, July 09, 2011 5:55 PM
To: excel-macros@googlegroups.com
Cc: arsfan2...@yahoo.co.in
Subject: Re: $$Excel-Macros$$ Strange Issue with Macro
Hi Hanumant
It is interesting..
I am
Hi Vinod,
Please share the test file.
Regards,
DILIPandey
On 7/8/11, vinod rao vinod.ma...@gmail.com 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
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 arsfan2...@yahoo.co.in
, Dilip Pandey dilipan...@gmail.com 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,),IF(Sheet2!D13:D23=G3,Sheet2!E13:E23,))}
It is an array formula, hence needs to be entered
No worries Susan... you are always welcome..!!
Regards,
DILIPandey
On 7/4/11, Susan sunni...@gmail.com wrote:
Dilip,
I apologize…… after recalculating my sheets I see that it worked J.
Thank you to everyone else..for your insights.
Appreciate it!
Sunnie
From: 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 thatsme.a...@gmail.com wrote:
Hi All
No boss this is also not working see i show you what excatly i want
202.718
198.724
200.178
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:
Congratulations Ashish...!! you Rock :)
Regards,
DILIPandey
On 7/4/11, Ayush Jain jainayus...@gmail.com 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
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:B6,B1:B6))
You are welcome. . .
Regards,
DILIPandey
On 7/2/11, Atul atul_pate...@yahoo.com wrote:
Thnaks you Pandeyji. ITs working fine
On Jun 29, 2:45 am, Dilip Pandey dilipan...@gmail.com 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 jainayus...@gmail.com wrote:
Dear Group,
I am extremely happy to share a good news with you. One of our dearest group
member 'Ashish Koul' is awarded
Hi Heather,
Check the below link:-
http://chandoo.org/wp/2009/09/03/get-cell-comments/
Best Regards,
DILIPandey
On 6/29/11, Heather galo...@comcast.net 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
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 proof
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 excelkeec...@gmail.com wrote:
hi all,
I want to learn VSTO for excel.anybody please give me the notes,pdf or
urls for learning.
thanks
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,
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
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 skanda.pokkun...@gmail.com wrote:
Hi,
How to add zeros in front of a
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 waheedb...@gmail.com wrote:
Dear Experts,
As I am beginner in VBA, please suggest me any institute in Hyderabad or any
best
Thanks Ayush.
Best Regards,
DILIPandey
On 6/8/11, Ayush jainayus...@gmail.com wrote:
Dilip,
Ok, I will approve the external link if it is opening form for that specific
job only.
I hope that is fine.
Dear Group,
Start posting jobs :)
Regards
Ayush Jain
Group Manager
--
Good initiative Ayush and many thanks to Ashish.
I am having one doubt. Some job application needs to be filled up
online and hence external link is mandatory. Please suggest.
Best Regards,
DILIPandey
On 6/7/11, Ayush jainayus...@gmail.com wrote:
Dear members,
There is an idea shared by
You are welcome Shekhar.
Thanks,
DILIPandey
On 6/6/11, Chandra Shekar chandrashekarb@gmail.com wrote:
Hi,
Thank you very much, Its working fine. Thanks!
On Mon, May 30, 2011 at 8:45 PM, Dilip Pandey dilipan...@gmail.com wrote:
Hi Chandra Shekhar,
The spreadsheet attached by you has
Nice briefing :)
Best Regards,
DILIPandey
On 6/5/11, rosini srukshanabegum2...@gmail.com wrote:
Microsoft Excel has the basic features of all spreadsheets,using a
grid of cells arranged in numbered rows and letter-named columns to
organize data manipulations like arithmetic operations. It has
Hi Charlie,
Yes it is possible, check the attached file.
Let me know if this is what you are looking for.
Best Regards,
DILIPandey
On 6/4/11, sswcharlie swch...@gmail.com wrote:
Hi
Is it possible to have say a cell with hyperlink to sheet (that is ok)
but also if the name in that cell
You are welcome Bob :)
Best Regards,
DILIPandey
On 6/3/11, Bob bobandrich...@comcast.net wrote:
Thank you so much for your help!!! That got it!
On Jun 1, 2:14 am, Dilip Pandey dilipan...@gmail.com wrote:
Hi Bob,
I am not sure how many rows you have, hence came up with following:-
Sub dkp
Many congratulations Ashish. Keep up the helping spirit. Best of luck.
Regards,
DILIPandey
On 6/2/11, Ayush Jain jainayus...@gmail.com wrote:
Hello Everyone,
Ashish Koul has been selected as 'Most Helpful Member' for the month of
May'11
He has posted 67 posts in May 2011 and helped many
1 - 100 of 702 matches
Mail list logo
