RE: $$Excel-Macros$$ Need to count blank cells with CountIF formula

Hi Ashish, That resulted in zero and the result should be 1. Because there is one blank cell that meets the criteria of the shift being 09:00 to 19:00 from Column G. I figured this one out and I believe it is working: =COUNTIFS($E$5:$E$34,"=17",$G$5:$G$34,">=09:00:00",$G$5:$G$34,"<=19:00:0

Re: $$Excel-Macros$$ Need to count blank cells with CountIF formula

see the forumula in yellow . On Thu, Mar 31, 2011 at 11:37 PM, 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 many blan

Re: $$Excel-Macros$$ hide and unhide a picture using check box

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 sub

$$Excel-Macros$$ Row height

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 tri

$$Excel-Macros$$ Need to count blank cells with CountIF formula

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: =COUNTIFS($E$5:$E$17,1

$$Excel-Macros$$ Compare sheets

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. Join

Re: $$Excel-Macros$$ Re: Calculating An Average Score from Multiple Tabs

Thank you GoldenLance. John On Tue, Mar 29, 2011 at 3:00 PM, GoldenLance 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" wrote: > > I have like tabs from different

Re: $$Excel-Macros$$ Help : Formula Required

here is the formula =IF(B2<=(7/24),"Yes",IF(B2>=(21/24),"Yes","No")) On Wed, Mar 30, 2011 at 5:23 PM, 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 BColu

$$Excel-Macros$$ Re: Help in formula to find the top 10 values

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 @ http://www.linkedin.com/groups?gid=1871

$$Excel-Macros$$ Re: Help in formula to find the top 10 values

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 @ http://www.linkedin.com/groups?gid=1871

Re: $$Excel-Macros$$ Help in formula to find the top 10 values

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 @ http://www.linkedin.com/groups?gid=1871

$$Excel-Macros$$ Re: formula or macro to convert dates

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 : http://twitter.co

$$Excel-Macros$$ Re: Fwd: Use The Same Vlookup To Find Two Different Values

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 : http://twitter.c

Re: $$Excel-Macros$$ Re: Identify the room status by color code

HI Thanks for reply, its almost same what i want. Regards Rajesh Kainikkara On 3/28/11, C.G.Kumar wrote: > PFA file. Hope it serve the purpose. > > > Regards, > > > C.G.Kumar > > > On Sun, Mar 27, 2011 at 8:06 AM, STDEV(i) wrote: > >> oops, the attachment >> >> >> >> On Sun, Mar 27, 2011

Re: $$Excel-Macros$$ Re: Identify the room status by color code

Hi, Thanks for the reply and explanation given it. Regards Rajesh Kainikkara On 3/28/11, C.G.Kumar wrote: > PFA file. Hope it serve the purpose. > > > Regards, > > > C.G.Kumar > > > On Sun, Mar 27, 2011 at 8:06 AM, STDEV(i) wrote: > >> oops, the attachment >> >> >> >> On Sun, Mar 27, 2011

Re: $$Excel-Macros$$ Help : Formula Required

so... make it simplest =IF((B2>=7/24)*(B2<=*21*/24),"NO","YES") On Thu, Mar 31, 2011 at 12:23 AM, JsinSk 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)" wrote: > > Try this formula > > > > *=IF((B2>=7/24)*(B2

Re: $$Excel-Macros$$ Useful Link ( Excel, Access, Word, Powerpoint ) VBA

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 wrote: > Thanks Ashish...!! > This is awsome site. > > Best Regards, > DILIPandey > > On 3/30

$$Excel-Macros$$ Re: Help : Formula Required

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 -- ---

$$Excel-Macros$$ Re: Updating excel 2003 spreadsheets and redeploying updates

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 wrote: > I have a spreadsheet with multiple macros a

$$Excel-Macros$$ Re: Fwd: Use The Same Vlookup To Find Two Different Values

Thanks a lot Bhushan On Tue, Mar 29, 2011 at 12:56 PM, Bhushan Sabbani 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 > > > -- --

Re: $$Excel-Macros$$ Help : Formula Required

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)" wrote: > Try this formula > > =IF((B2>=7/24)*(B2<=9/24),"NO","YES") > > On Wed, Mar 30, 2011 at 6:53 PM, wrote: > > Hi All, > > > I need formula to update column C,  value if the

$$Excel-Macros$$ Macro to Calculate Schedule Variance (SV).

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 w

$$Excel-Macros$$ formula or macro to convert dates

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 autom

$$Excel-Macros$$ find & replace macro needs exception

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 = "([.