Experts,
Help me in providing a formula to calculate the Half day in the attached
Attendance Tracker.
If I enter H in the column the Half day column should add up by 0.5 and No
of days present column should reduce by .5.
Thanks
Hemanath.D
9176656647
--
Join official Facebook page of this
SEE THE ATTACHED SHEET
WARM REGARDS,
GAWLI ANIL
On Tue, Jan 29, 2013 at 1:52 PM, hemanath dhanasekar hema5s...@gmail.comwrote:
Experts,
Help me in providing a formula to calculate the Half day in the attached
Attendance Tracker.
If I enter H in the column the Half day column should add up
Awesome Anil Sir,
its only single line and very short code. amazing !!
thanks v vry much.
-Regards,
-Chaya
On Tue, Jan 29, 2013 at 3:12 PM, अनिल नारायण गवली
gawlianil8...@gmail.comwrote:
Dear Chaya,
Pl find attached sheet. FY I
Warm Regards,
Gawli Anil
On Tue, Jan 29, 2013 at
Dear Anil,
Formula is good,but how to convert in excel 2003 excel.I used excel
2003.So there no display formula if it move to another sheet it also
show error why?Pls Explain me
Regards
Amar
On Tue, Jan 29, 2013 at 10:22 AM, अनिल नारायण गवली
gawlianil8...@gmail.com wrote:
Pl see the attached
sorry to miss spell your name
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Manjunath Narayanappa
Sent: 29 January 2013 10:14
To: 'excel-macros@googlegroups.com'
Subject: RE: $$Excel-Macros$$ Extract information from excel
Dear Gawli Ali,
I'm unable to
Dear Anil,
Yes,I am not used countifs formula.pls suggest Excel 2003 formula
Thanks in Advance
On Tue, Jan 29, 2013 at 3:45 PM, Manjunath Narayanappa
manjunath.narayana...@aon.co.uk wrote:
sorry to miss spell your name
From: excel-macros@googlegroups.com
Hi Anil,
I want Ascending Decending data then how to VBA Code used.only I
click button which column on Ascending Decending then that column
sort with other data.I send Example file pls see it
Appreciate the help.
Regards
Amar
On Tue, Jan 29, 2013 at 2:46 PM, Yahya Muhammad yahya...@gmail.com
Dear Anil,
Formula is same as previous.Pls see it.
On Tue, Jan 29, 2013 at 4:07 PM, अनिल नारायण गवली
gawlianil8...@gmail.com wrote:
see the attached sheet..
Warm Regards,
Gawli Anil
On Tue, Jan 29, 2013 at 3:54 PM, amar takale amartak...@gmail.com wrote:
Dear Anil,
Yes,I am not used
Dear Amar
Please read Forum Rule No. 2 and post your query in a separate thread:
2) Don't post a question in the thread of another member.
On Tue, Jan 29, 2013 at 1:43 PM, amar takale amartak...@gmail.com wrote:
Hi Anil,
I want Ascending Decending data then how to VBA Code used.only I
Dear Yahya Muhamma Anil,
Sorry for that,I will post my query in a separate thread:
Amar
On Tue, Jan 29, 2013 at 6:14 PM, amar takale amartak...@gmail.com wrote:
Hi Anil,
Sorry for that,I will post my query in a separate thread:
Amar
On Tue, Jan 29, 2013 at 4:41 PM, Yahya Muhammad
sub detele()
Application.DisplayAlerts = False
Worksheets(Sheet1).delete
Application.DisplayAlerts = True
end sub
Hello Experts,
the code above deletes sheets1 but this is a static macro , i want to be
able to delete a sheet by type the sheetname and then have it deleted,
kindly assist with
Use input box pass the sheet name through inputbox
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Hilary Lomotey resp...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Tue, 29 Jan 2013 12:45:45
To: excel-macrosEXCEL-MACROS@googlegroups.com
Reply-To:
PERFECT
100%
thanks to All
On Tue, Jan 29, 2013 at 12:49 PM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
[image: Boxbe] https://www.boxbe.com/overview This message is eligible
for Automatic Cleanup! (noorain.ans...@gmail.com) Add cleanup
Sub CreateLinksToAllSheets()
Dim cell As Range, i As Long, j As Long
i = 1
j = 1
For k = 4 To Worksheets.Count
If ActiveSheet.Name Sheets(k).Name Then
Cells(j, i).Select
ActiveCell.Hyperlinks.Add Anchor:=Selection, Address:=,
SubAddress:= _
' Sheets(k).Name ' !A1,
Hi Hilary,
Please Hope this may be help full for you.
Public Sub TestLink()
Dim ShtCountAs Integer
Dim intStartpos As Integer
Dim intCtr As Integer
Dim i As Integer
With ThisWorkbook
i = 1
ShtCount =
Gawli,
This is not the answer I am looking for, The Half day column should be
0 initially and when ever I update H in the date column then the Half day
column should add up by 0.5 and if I update another H on another date then
Half day column should show as 1 (ie 0.5+0.5). and simultaneously No
Hi Hemanath,
Use the following formula or more clarity find the
attachment.
=COUNTIF(*C3:AG3*,H)*0.5
--
*Regards,*
*
*
*Excel Beginner*
On Tue, Jan 29, 2013 at 9:51 PM, hemanath dhanasekar hema5s...@gmail.comwrote:
Gawli,
This is not the
Thanks the formula is working, but I dont see any changes in No Of Days
Present column this column also should increase by 0.5.
On Tue, Jan 29, 2013 at 10:28 PM, Excel Beginner
excelbegin...@gmail.com wrote:
Hi Hemanath,
Use the following formula or more clarity find
working really nicely, thanks Prince, very grateful
On Tue, Jan 29, 2013 at 3:39 PM, Prince prince141...@gmail.com wrote:
[image: Boxbe] https://www.boxbe.com/overview This message is eligible
for Automatic Cleanup! (prince141...@gmail.com) Add cleanup
Dear Jaisri,
Pl elaborate some more quries .
Warm Regards,
Gawli Anil
On Wed, Jan 30, 2013 at 10:37 AM, Sri Jai jaisri1...@gmail.com wrote:
Dear team
Need your help on this
Tab 1 – Turkey list os over 4000 advertising companies in Turkey (There
are duplicates as this is actually a
Dear Amar,
Anil's formula in 2003 version
=IF(ISERROR(MID(B2,FIND(K508,B2),8)),,MID(B2,FIND(K508,B2),8))
On Tue, Jan 29, 2013 at 4:15 PM, amar takale amartak...@gmail.com wrote:
Dear Anil,
Formula is same as previous.Pls see it.
On Tue, Jan 29, 2013 at 4:07 PM, अनिल नारायण गवली
Dear Yahya,
Pls visit on below link,hope it will help to you.
http://www.ozgrid.com/forum/showthread.php?t=66674
On Wed, Jan 30, 2013 at 12:49 AM, Yahya Muhammad yahya...@gmail.com wrote:
Dear Ashish
This is what I want. But could not make it work in my file, which is
attached. Please
Dear Noorin,
Thanks very much for co operate me for solution
Anil also thanks for that
Regards
Amar
On Wed, Jan 30, 2013 at 11:47 AM, Anoop K Sharma aks.sharm...@gmail.com wrote:
Mid and Find work well in Excel 2003
On Wed, Jan 30, 2013 at 11:30 AM, अनिल नारायण गवली gawlianil8...@gmail.com
Hi friends,
i dont know ANYTHING about .net. and now want to learn it does anybody know how
shud i start with it.
Any site or ebook for beginners.
i am sorry this is off the track.
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use
24 matches
Mail list logo