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:00,E
Hi Ashish,
Thanks for sharing the file... but file is not opening... it takes lot of time
to open... and it shows the data is downloading from different sources
Could you please help in this.
Regards,Anil Bhange
IP Phone - 512320 | Mobile - 90290 32123
From: ashish koul
Hi Experts,
I have list of items which have not full codes. I need them to convert full
code. Could you please help me.
Item code column has either 3, 2, 4 5 digits no. but by default they
should be either 6 or 7 or 8 digits code. What best formul I need to use to
get that output. Item Full
Dear all,
I am facing this problem since a long time. Suppose I want to write anything
in English I can directly give by a line in code (filesys.WriteText POP)
but if I want to write the translation of same in Chinese inside code it is
showing junk characters () like this Chinese word 西洋勁曲
Hi ! Group members,
I have a pivot table, which shows 5 income groups in row Range and their
counts. However, when I apply a filter it leaves 3 income groups in the row
range as other two groups don't match the filter criteria. I want the pivot
table to keep all five groups and if a group doesn't
its working fine at my place
try these links it may help you
http://excelusergroup.org/forums/t/1210.aspx
http://chandoo.org/forums/topic/marquee-in-excel
On Fri, Apr 1, 2011 at 2:48 PM, Anil Bhange
anil.bha...@tatacommunications.com wrote:
Hi Ashish,
Thanks for sharing the file… but
awaiting for your replay please.
On Fri, Apr 1, 2011 at 4:49 PM, Puttu * puttu...@gmail.com wrote:
Experts please help me on this it's bit urgent sorry to bother.
On Fri, Apr 1, 2011 at 4:10 PM, Puttu * puttu...@gmail.com wrote:
Hi Experts,
I have list of items which have not full codes.
Hi
I am also searching for that. u can download freely the tools codes
to crack the worksheet passwords, but in case of VBA project password
cracking I think it may not be easy.
Regards
Rajesh kainikkara
On 3/28/11, Raveendra raveendra_naga...@rediffmail.com wrote:
Can you explain how to
CompareWorksheetsAdd-in.xla !!!
It is a usefull tool / add-in ..
Thank you Mr Ashish
best regards,
STDEV(i)
On Fri, Apr 1, 2011 at 12:21 AM, ashish koul koul.ash...@gmail.com wrote:
try this
On Thu, Mar 31, 2011 at 8:37 PM, hanumant shinde
hanumant_5...@yahoo.co.in wrote:
Hi Guys,
sorry again, please hep me in the formula
On Fri, Apr 1, 2011 at 5:12 PM, Puttu * puttu...@gmail.com wrote:
awaiting for your replay please.
On Fri, Apr 1, 2011 at 4:49 PM, Puttu * puttu...@gmail.com wrote:
Experts please help me on this it's bit urgent sorry to bother.
On Fri, Apr 1,
Kind attach the sample file.
Kindly check the data you have select is correct or not.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
attach the sample file so we can help you.
--
--
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 @
Hi Puttu,
explain it in excel sheet and also mention all the possibilities.
Regards
Umesh
On Fri, Apr 1, 2011 at 5:12 PM, Puttu * puttu...@gmail.com wrote:
awaiting for your replay please.
On Fri, Apr 1, 2011 at 4:49 PM, Puttu * puttu...@gmail.com wrote:
Experts please help me on this
Hi Rakesh,
can you attach the excel sheet
Regards
Umesh Dev
On Fri, Apr 1, 2011 at 4:29 PM, rakesh kumar rakeshshail2...@gmail.comwrote:
Hi ! Group members,
I have a pivot table, which shows 5 income groups in row Range and their
counts. However, when I apply a filter it leaves 3 income
why r u using 200 for 990 or 300 for 11 any reason
On Fri, Apr 1, 2011 at 4:49 PM, Puttu * puttu...@gmail.com wrote:
Experts please help me on this it's bit urgent sorry to bother.
On Fri, Apr 1, 2011 at 4:10 PM, Puttu * puttu...@gmail.com wrote:
Hi Experts,
I have list of items which
Can you please please help any one
On Fri, Apr 1, 2011 at 5:40 PM, Puttu * puttu...@gmail.com wrote:
sorry again, please hep me in the formula
On Fri, Apr 1, 2011 at 5:12 PM, Puttu * puttu...@gmail.com wrote:
awaiting for your replay please.
On Fri, Apr 1, 2011 at 4:49 PM, Puttu *
Hi ,
Try this code in attached File
On Fri, Apr 1, 2011 at 2:18 PM, vijayKumar midearfam...@gmail.com wrote:
Hi..
Please guide how to use this file.. i'm getting a error when i open the
file..
Screenshoot of error attached,,
On Fri, Apr 1, 2011 at 2:03 PM, ashish koul
Item Full Code output
Give the formula for output
Item Code
200990
=Text(item_Code,000)
990
200991
991
300011
11
300014
14
300104
104
520901
20901
520902
20902
500450
450
500451
451
203529
3529
203538
3538
8515959
=IF(OR(HOUR(M14)7,HOUR(M14)21),Yes,No)
Rajan
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 BColumn C
Date
find attached File
On Wed, Mar 30, 2011 at 4:16 AM, None n8dine4ma...@yahoo.com wrote:
Hi all. Attached is a workbook that contains 2 sheets. The first is the
list that the 2nd sheet will refer to. I'd like a formula in col C on sheet
2 that looks up each combination and determines if the
Sub Macro1()
ActiveWorkbook.RefreshAll
Call Update
End Sub
Sub Update()
Application.Wait Now + TimeValue(00:01:00)
Call Macro1
End Sub
On Wed, Mar 30, 2011 at 9:54 AM, Divaker Pandey divake...@gmail.com wrote:
can u send that file.
Divaker
On Tue, Mar 29, 2011 at 2:40 PM, Anil Bhange
Hi again,
This is the formula that I needed:
=COUNTIFS($E$5:$E$34,15,$G$5:$G$34,=09:00:00,$G$5:$G$34,=19:00:00),+
COUNTIFS($E$5:$E$34, ,$G$5:$G$34,=09:00:00,$G$5:$G$34,=19:00:00)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ashish koul
Sent:
22 matches
Mail list logo