You can subscribe to this group by following the below link:-
http://groups.google.com/group/excel-macros
or
http://www.discussexcel.com/google-group
write a mail to excel-macros@googlegroups.com
read this Want to get your question answered quickly?
Hi,
I read a tip about using a VBA macro do automatically adjust inter-
sentence spacing (http://word.tips.net/Pages/
T000488_Spacing_After_Sentences.html):
Sub TwoSpaces()
Selection.Find.ClearFormatting
Selection.Find.Replacement.ClearFormatting
With Selection.Find
.Text =
I have a column of dates exported from Access into Excel. the current
formula counts any dates that start on the 1st and places the sum into
the proper column. My problem is there are quite a few that export
over as 3/15/2011 or 5/2/2011, etc...not on the 1st, so these volumes
are not being
Hi Experts,
Thank you so much in advance. Please help me on this.
Attached is the sampled data.
This is the generated report from tool upto column A to G.
Column H I are formulated columns by me.
Expected output from the report (When i run the macro)
1. Details to be listed in same
On my response I screwed up the 24 hour time format! Should be 21:00
instead of 17:00.
On Mar 30, 1:17 pm, STDEV(i) setiyowati.d...@gmail.com wrote:
Try this formula
=IF((B2=7/24)*(B2=9/24),NO,YES)
On Wed, Mar 30, 2011 at 6:53 PM, zinknax.zin...@gmail.com wrote:
Hi All,
I need formula
Thanks a lot Bhushan
On Tue, Mar 29, 2011 at 12:56 PM, Bhushan Sabbani bsabban...@gmail.com wrote:
Dear Bhavya,
Pls refer to attached file.
Pls look to the column which are colored in yellow.
Warm Regards
Bhushan Sabbani
+91 98208 26012
--
I am surprised that after three days no-one has come up with any
advice.
I find it hard to believe that others have not come across this sort
of problem before
Please help - I am getting desperate
Thanks
brian
On Mar 28, 7:18 pm, BJthebear brian.jerm...@gmail.com wrote:
I have a spreadsheet
Dear Myur,
=IF(AND(TEXT(B19,hh:mm)07:00,TEXT(B19,HH:mm)17:00),NO,YES)
You can use the above formula.
Dear Akash,
Pls attach the sample file.
So we can help you better.
Warm Regards
Bhushan Sabbani
+91 98208 26012
--
Hi Dilip,
Below mentioned link mght also be a help to you, it has a pictorial view to
understand...
http://www.techonthenet.com/index.php
Thanks
Raafi
On Thu, Mar 31, 2011 at 10:41 AM, Dilip Pandey dilipan...@gmail.com wrote:
Thanks Ashish...!!
This is awsome site.
Best Regards,
so... make it simplest
=IF((B2=7/24)*(B2=*21*/24),NO,YES)
On Thu, Mar 31, 2011 at 12:23 AM, JsinSk jsin...@gmail.com wrote:
On my response I screwed up the 24 hour time format! Should be 21:00
instead of 17:00.
On Mar 30, 1:17 pm, STDEV(i) setiyowati.d...@gmail.com wrote:
Try this
Hi,
Thanks for the reply and explanation given it.
Regards
Rajesh Kainikkara
On 3/28/11, C.G.Kumar kumar.bemlmum...@gmail.com wrote:
PFA file. Hope it serve the purpose.
Regards,
C.G.Kumar
On Sun, Mar 27, 2011 at 8:06 AM, STDEV(i) setiyowati.d...@gmail.com wrote:
oops, the
HI
Thanks for reply, its almost same what i want.
Regards
Rajesh Kainikkara
On 3/28/11, C.G.Kumar kumar.bemlmum...@gmail.com wrote:
PFA file. Hope it serve the purpose.
Regards,
C.G.Kumar
On Sun, Mar 27, 2011 at 8:06 AM, STDEV(i) setiyowati.d...@gmail.com wrote:
oops, the
Your are welcome.
I am glad that my solution helped out.
Warm Regards
Bhushan Sabbani
+91 98208 26012
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
Dear,
pls attached the sample file so we can help you.
Warm Regards
Bhushan Sabbani
+91 98208 26012
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
Thank for the same
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @
Thank for the same
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @
here is the formula
=IF(B2=(7/24),Yes,IF(B2=(21/24),Yes,No))
On Wed, Mar 30, 2011 at 5:23 PM, zinknax.zin...@gmail.com wrote:
Hi All,
I need formula to update column C, value if the time is between 7:00 AM to
9:00 PM YES else NO
Find attached for the same.
Column AColumn B
Thank you GoldenLance.
John
On Tue, Mar 29, 2011 at 3:00 PM, GoldenLance samde...@gmail.com wrote:
Try this
=IF(ISERROR(AVERAGE('Dept A'!B10,'Dept B'!B10,'Dept C'!
B10)),,AVERAGE('Dept A'!B10,'Dept B'!B10,'Dept C'!B10))
On Mar 29, 7:52 pm, John A. Smith johnasmit...@gmail.com wrote:
I
Hi Guys,
is it a way where i can compare 2 sheets. lets say sheet1 and sheet2.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2.
Is there a way to determine what the row height should be since AutoFit
doesn't work in a cell with a lot of text?
Thanks in advance.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips
Hi,
I have this formula,
=COUNTIFS($E$5:$E$17,15,$G$5:$G$17,=09:00:00,$G$5:$G$17,=19:00:00),
which returns to me a count total based on two criterias, but I also need
to add in this same formula how many blank cells there are, from E5:E17.
I did this formula:
try these links
http://akoul.blogspot.com/2011/03/show-status-or-display-any-message.html?showComment=1300954018709
http://www.ozgrid.com/FreeDownloads/DisplayWaitMessage.zip
http://spreadsheetpage.com/index.php/tip/displaying_a_progress_indicator/
On Fri, Apr 1, 2011 at 1:03 AM, santosh
see the forumula in yellow .
On Thu, Mar 31, 2011 at 11:37 PM, sunni...@gmail.com wrote:
Hi,
I have this formula,
=COUNTIFS($E$5:$E$17,15,$G$5:$G$17,=09:00:00,$G$5:$G$17,=19:00:00),
which returns to me a count total based on two criterias, but I also need to
add in this same formula how
23 matches
Mail list logo