in J1
=LOOKUP(1,N(COUNTIF(D2:H2,D2:H2)1))=1
Regards
Rajan.
On Thursday, 25 September 2014 11:15:01 UTC-6, SUDHIR VERMA wrote:
Dear Experts,
Kindly resolve my problem.
Explanation in attached workbook.
Thanking You
Regards
Sudhir
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?
thanking you so much
On 1 October 2014 19:37, Rajan Verma rajanverma1...@gmail.com wrote:
in J1
=LOOKUP(1,N(COUNTIF(D2:H2,D2:H2)1))=1
Regards
Rajan.
On Thursday, 25 September 2014 11:15:01 UTC-6, SUDHIR VERMA wrote:
Dear Experts,
Kindly resolve my problem.
Explanation in attached
its super one..
+
*I did not do this for you. God is here working through me for you.*
On Wed, Oct 1, 2014 at 7:37 PM, Rajan Verma rajanverma1...@gmail.com
wrote:
in J1
=LOOKUP(1,N(COUNTIF(D2:H2,D2:H2)1))=1
Regards
Rajan.
On Thursday, 25 September 2014 11:15:01 UTC-6, SUDHIR VERMA
Hi Lalit,
No I don't want the timeline to scroll down. What I want is that suppose I
have the timeline on top of the dashboard. I select a particular period to
view. If you notice that on the time line it displays the period you have
selected (E.g. Q1 2014 or Jan-Feb 2014). But if I scroll
What you want whenever you scroll down the timline should also scroll down?
On Friday, 27 June 2014 14:59:45 UTC+5:30, Prayank Vidyarthi wrote:
Hi Excel Gurus,
I need your help as I am really stuck over here. I have data starting from
Nov 2012 till March 2014. I have created various charts
you should try with two add on printer software adobe pdf printer or
bullzip printer.
Thanks
Chintan
On Thursday, January 23, 2014 9:22:29 AM UTC+5:30, Aatmik Muchhal wrote:
My code is -
Sub SavePDF()
' pdf Macro
Application.ScreenUpdating = False
Sheets(Invoice).Select
PFA.. solved
On Sat, Oct 5, 2013 at 11:23 AM, Rakesh kumar rakesh.apt...@gmail.comwrote:
Please find the attachment.
On Sat, Oct 5, 2013 at 11:22 AM, Rakesh kumar rakesh.apt...@gmail.comwrote:
Dear Friend,
i want to use total no of present or absent list using pivot table.
Please
Please find the attachment.
On Sat, Oct 5, 2013 at 11:22 AM, Rakesh kumar rakesh.apt...@gmail.comwrote:
Dear Friend,
i want to use total no of present or absent list using pivot table.
Please find the attachment.
--
Thanks £ Regards
Rakesh Kumar
+91-9650303464
--
Thanks £
Hello Arpita,
A little confusion in the part =1/-1
If you want to SUM all 0 values, you can use
*
=SUMIF(A1:A16,0,A1:A16)*
If you are looking to SUM between =-1 to 1 (minus 1 to positive 1), use
*
=SUM(SUMIF(A1:A16,{=**-**1,1},A1:A16)*{1,-1})*
HTH
Haseeb
On Monday, February 27, 2012 3:32:19
Dear santosh,
Please follow below link
http://www.techbookreport.com/tutorials/fso1.html
Thanks regards,
Noorain Ansari
http://excelmacroworld.blogspot.com/
http://noorain-ansari.blogspot.com/
- Show quoted text -
On Sat, Sep 10, 2011 at 10:01 AM, Santosh V
See if this helps, haven't tested it though.
On Mon, Aug 8, 2011 at 4:01 PM, Sundarvelan N nsund...@gmail.com wrote:
Hi Friends,
I need one help.
I have 5 to 6 graphs in a sheet. On clicking a combo box respective graph
should pop up. Please help me.
Thanks
N.Sundarvelan
9600160150
Quick reply for 2nd point:
IN VBE,
Select:
Tools / VBA Project Propoerties / Protection
Now enable Lock Project for Viewing, enter password twice and click
on OK.
Most Imp: Do not forget the passowrd.
regards,
Milind
On Mar 6, 3:52 pm, Indrajit $nai talk2indra...@gmail.com wrote:
Hi All,
I
The solution was sent through mail.
Is the solution working fine, reply back.
Regards,
Kishan Reddy, K
On Jul 29, 8:33 am, Nagendra Modupalli naga14...@gmail.com wrote:
Hi Team,
The password is correct STPIInvoices in this up to STPII is CAPS letter
nvoices is small latters.
Please let me
Code is not opening, The password might be wrong.
Kishan Reddy, K
On Jul 27, 10:21 am, Nagendra Modupalli naga14...@gmail.com wrote:
Hi Team,
I have Invoices printing macro.It is printing row wise.I want to modify
customer wise.Can you please help me.Thanks in advance.
And also i have
Hi Team,
The password is correct STPIInvoices in this up to STPII is CAPS letter
nvoices is small latters.
Please let me know if you have any questions on this.Thanks in advance.
*Private Sub cmdPrint_Click()
Set objDataSheet = Me.Parent.Sheets(Data)
objDataSheet.Unprotect STPIInvoices
Hi ZAC,
I have created a user form as per your needs. The shortcut is CTRL + Y and
userform will pop up on this shortcut. The data will be updated on click of
submit button.
The fields will reset on data successfully updated.
Please have a look and let me know if any further assistance is
Shrivastava
anish@gmail.comwrote:
Experts
Please helpor advice if it is possible...
-- Forwarded message --
From: Anish Shrivastava anish@gmail.com
Date: Tue, Jan 5, 2010 at 2:29 PM
Subject: Re: $$Excel-Macros$$ Re: Urgent Help Needed!!
To: excel-macros
Hey Praveen, Good solution. I didn't think of doing it by macro. Pretty silly
when this is a macro group!
Regards - Dave.
Date: Thu, 7 Jan 2010 12:36:39 +0530
Subject: Re: $$Excel-Macros$$ Re: Urgent Help Needed!!
From: pkkara...@gmail.com
To: excel-macros@googlegroups.com
Hello Anish,
Please
:36:39 +0530
Subject: Re: $$Excel-Macros$$ Re: Urgent Help Needed!!
From: pkkara...@gmail.com
To: excel-macros@googlegroups.com
Hello Anish,
Please check the attached file and let me know if this is what you were
looking for.
run the macro testmulti()
You should get a true for all
.
--
Date: Thu, 7 Jan 2010 12:36:39 +0530
Subject: Re: $$Excel-Macros$$ Re: Urgent Help Needed!!
From: pkkara...@gmail.com
To: excel-macros@googlegroups.com
Hello Anish,
Please check the attached file and let me know if this is what you were
looking for.
run the macro
Experts
Please helpor advice if it is possible...
-- Forwarded message --
From: Anish Shrivastava anish@gmail.com
Date: Tue, Jan 5, 2010 at 2:29 PM
Subject: Re: $$Excel-Macros$$ Re: Urgent Help Needed!!
To: excel-macros@googlegroups.com
Hi Dave,
Attached please
at 6:43 PM, Dave Bonallack davebonall...@hotmail.comwrote:
Please attach a workbook with a sample of English and non-English
characters
Regards - Dave
--
Date: Mon, 4 Jan 2010 15:40:08 +0530
Subject: $$Excel-Macros$$ Re: Urgent Help Needed!!
From: anish
Experts!!!
Any updates on below query??
Thanks!!
ANISh
On Wed, Dec 30, 2009 at 1:31 PM, Anish Shrivastava anish@gmail.comwrote:
Hello Experts,
Thank you very much for helping me on my earlier queries.
Could you please help me in finding cells which contains multibyte
characters.
I
Please attach a workbook with a sample of English and non-English characters
Regards - Dave
Date: Mon, 4 Jan 2010 15:40:08 +0530
Subject: $$Excel-Macros$$ Re: Urgent Help Needed!!
From: anish@gmail.com
To: excel-macros@googlegroups.com
Experts!!!
Any updates on below query??
Thanks
Hi Vinod
Try the Macro below.
Sub update()
Dim x As Integer
x = 3
Do While Sheet1.Cells(x, 2).Value
If Sheet1.Cells(x, 4).Value = Core Then
Sheet1.Cells(x, 2).Value = PAT
End If
x = x + 1
Loop
End Sub
--
--
Hi All,
Apologies for sending this request. I seem to have found out the solution. I
wasted one whole hour trying to figure out something which was simple, but I
seem to have over looked how the formatting is done. Please do not waste your
time on this request.
Apologies once again.
Guys,
I am waiting for an answer , Please respond
Best regards
rajesh
On Mon, Aug 3, 2009 at 8:01 AM, Rajesh Janardanan rajesh...@gmail.comwrote:
Dear All,
Need an urgent help , please refer the attached file , I need a formula
which will read YTD (B13) as the last cell entered , in the
rajesh can you confirm if the number of rows in just 13 or will it cross
more than that...
if its just Jan to Dec.. we can fix it with an simple {if condition.. } or
else we need to find other ideas..
Regards
Venkatesh
On 8/3/09, Rajesh Janardanan rajesh...@gmail.com wrote:
Dear All,
sorry guys.. looks like i am too late...to reply
sorry ...
On 8/3/09, Rajesh Janardanan rajesh...@gmail.com wrote:
Guys,
I am waiting for an answer , Please respond
Best regards
rajesh
On Mon, Aug 3, 2009 at 8:01 AM, Rajesh Janardanan rajesh...@gmail.comwrote:
Dear All,
Need an
hi Venkatesh,
Can u give me a suggestion on the If command u have mentioned?
Best regards
rajesh
On Mon, Aug 3, 2009 at 9:34 AM, Rajesh Janardanan rajesh...@gmail.comwrote:
yes Venkatesh, it will be Jan to December only, please advise me withe
the if command
Best regards
rajesh
On
Shivashankar,
I suggest you give us a sample format in which you want to see the data so that
it is easier then.
Regards,
Swanand Deshpande
Cell: +91- 90110 99165
From: shivashankar katageri
Sent: Monday, August 03, 2009 1:44 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$
Hi Shivashankar
cal u please clarufy in which structure or format do you require the result
in
Thanks and Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Mon, Aug 3, 2009 at 1:44 PM, shivashankar katageri
shankarkatag...@gmail.com wrote:
Rajesh,
Try the formula below:
=INDEX(B1:B12,MATCH(9.99E+307,B1:B12))
Norman
On Mon, Aug 3, 2009 at 1:01 AM, Rajesh Janardanan rajesh...@gmail.comwrote:
Dear All,
Need an urgent help , please refer the attached file , I need a formula
which will read YTD (B13) as the last cell
Hi,
Use text to column wizard in 3rd step select date and DMY format all your
dates will be converted to data format
Regards
Sathish Jalendran
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of sachin patil
Sent: 13 July 2009 PM 03:00
To: Excel
Hi Sachin,
You have entered date which seems as date but actually are strings. You have
to write dated in the format mm/dd/yy. So your date should be 03/31/09, not
31-03-09.
This will solve your problem
Regards,
Upendra Singh
+91-9910227325, +91-9310760597
Hello,
Plz let me know below query.
On Thu, Jul 2, 2009 at 2:26 PM, vinod rao vinod.ma...@gmail.com wrote:
Hello,
Can i know how was radio icon created linked to year 1,2 3.?
Thanks in advance.
Vinod
On Wed, Jul 1, 2009 at 5:09 PM, Sachin Shukla sachina...@gmail.comwrote:
Dear Dilip,
Hi Sachin,
Attached sheet has been solved. Thanks,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Tue, Jun 30, 2009 at 11:53 AM, Sachin Shukla sachina...@gmail.comwrote:
Dear All,
Please provied me help
Dear Dilip,
Thanks a lot. Its working.
Thanks
Sachin Shukal
On Wed, Jul 1, 2009 at 3:57 PM, Dilip Pandey dilipan...@gmail.com wrote:
Hi Sachin,
Attached sheet has been solved. Thanks,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
: Monday, June 29, 2009 10:08 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Re: Urgent help
Hi,
try this code
Activeworkbook.saveas(Thiswookbook.path \ ClinentName format(now
(),ddmmhhmm).xls)
With regards
BALA
On Jun 27, 5:14 pm, Chidurala, Shrinivas
shrinivas.chidur
Hi,
try this code
Activeworkbook.saveas(Thiswookbook.path \ ClinentName format(now
(),ddmmhhmm).xls)
With regards
BALA
On Jun 27, 5:14 pm, Chidurala, Shrinivas
shrinivas.chidur...@citi.com wrote:
Dear Friends
I want file should be save like client name with current date time
Hi Dilip,
Thanks a lot for your respose.
This is something which i am expecting to perform. However, i forgot to
mention one thing in my previous mail.
It would be great if a macro could be created, where all these things (which
you have made in the file) could be automatically keeping in mind
Not sure what you question is exactly about... but
If you want a macro to open automatically, each time a user opens a
file
1. , then save the macro in Personal Workbook. This is a default
workbook which is always hidden.
2. create an add-in
or
if you don't want a macro to open each time
Can you please send the sample text file..
Regards,
Andy
On Fri, Jun 12, 2009 at 8:10 AM, Balachander S sba...@gmail.com wrote:
May be this is very simple for you experts . I am unable to crack the
converiosn from Test file to excel for the data below.
The fields are not aligned to draw
Hi Akshu,
The best and quick way is Text - to -Column feature of the excel.
I believe, if we do it by a function then we might have to drag that to the
end of the columns/ rows (IV or 65536) or else VBA is the sure shot answer
for your query.
Thanks,
--
DILIP KUMAR PANDEY
MBA-HR,B
Please check out the attachment.
Regards,
Mudassar Ramzan
- Original Message -
From: Akshu Bhagat
To: excel-macros@googlegroups.com
Sent: Wednesday, June 03, 2009 3:46 PM
Subject: $$Excel-Macros$$ Urgent help to split the column values
Hi everyone,
I want each name
Hi Prashanth,
Write the below query and let me know if it is working:
Update Test1
Set Test1.Month = Month.Month
Where Test1.Weekno. = Month.Weekno
Regards,
Upendra Singh
9910227325
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of
havent heard, still waiting for the answer, wake up...
--- On Tue, 4/14/09, shannu shannu shannur...@yahoo.com wrote:
From: shannu shannu shannur...@yahoo.com
Subject: Urgent help filter macro
To: excel-macros@googlegroups.com
Date: Tuesday, April 14, 2009, 10:16 AM
Hi All,
Good idea,
but we can come out of that situation.
Harish, Just put a line in the macro before msgbox:
activeworbook.save
hope that solves the issue
On Tue, Apr 14, 2009 at 8:55 PM, santosh bahuguna santoshbahug...@gmail.com
wrote:
working with share file is much diffcult to fix this
Thanks a lot Harmeet...
Can u also get me one more functionality here that as soon as one agent
acquires the job time and date he acquired also appears and untill he
finishes the job by selecting as close which will be a drop down in next
column to acquired time column. Once agent uses close from
Hi Harish,
First of all, Thanks a lot for appreciation.
If now I do the changes that you have mentioned in your mail, will be a
spoon feeding.
I have not protected the code that I have sent you. It would be a good
learning for you if you try and do it by yourself. You just need to write
two lines
One more thing,
You can also use shortcuts to enter time/date.
*Ctrl+;* to enter date
and *Ctrl+shift+;* to enter time.
On Mon, Apr 13, 2009 at 7:00 PM, Harmeet Singh harmeet.hew...@gmail.comwrote:
Hi Harish,
First of all, Thanks a lot for appreciation.
If now I do the changes that you
Hi Harmeet,
I used the other macro to fix my date and time issue since I was trying to
link this date and time with availble field in raw data but this was
refreshing so time was also refreshed but anyway I have fixed that but
eventually I have found that the data acquired is always misses the
Dear
The following
codehttp://www.ozgrid.com/forum/autolink.php?id=1script=showthreadforumid=8will
put a Left
headerhttp://www.ozgrid.com/forum/autolink.php?id=37script=showthreadforumid=8in
each
worksheethttp://www.ozgrid.com/forum/autolink.php?id=18script=showthreadforumid=8in
the workbook
Hi Sashank
if u enter the value in cell A1 and want to see the decimal value in A2 then
just type =A1/100 in the cell A2.
Regards,
Andy
On Sat, Apr 4, 2009 at 1:46 AM, shashank bhosle
catchshashankbho...@yahoo.co.in wrote:
HI All,
I am having a Excel file where i need to imput the
Thanks Aindril !!! its working
--- On Sat, 4/4/09, Aindril De aind...@gmail.com wrote:
From: Aindril De aind...@gmail.com
Subject: $$Excel-Macros$$ Re: urgent help req.
To: excel-macros@googlegroups.com
Date: Saturday, 4 April, 2009, 9:33 AM
Hi Sashank
if u enter the value in cell
--
Hi LavPrasad,
Here is the solution to your query:
http://www.excelitems.com/2009/02/count-5-consecutive-zeroes.html
Regards
Ashish Jain
Analyst and Demand-Co-ordinator, CSC Australia
Microsoft Office Specialist
Technical
Dear Ashish,
Thanks for the reply. When I go to below mentioned site. There is macro
program. I had gone by step by step. but I am not getting the answer. There
is an #Name error has occured. Please help me attached the same file.
Thanks Regards,
Lavprasad Kori
MIS Executive - Water
Hi Pavithrak,
Not sre what markers are required.
i had updated three radio buttons but not sure of the code which you require
the below link has the option of adding the code.
*http://www.functionx.com/excel2003/articles/radiobuttons.htm*
regards
Hari kumar
On Wed, Feb 18, 2009 at 8:56 AM,
58 matches
Mail list logo