ok,thanks for reply
On Sat, Jan 26, 2013 at 6:02 AM, Bé Trần Văn betnmtdongna...@gmail.com wrote:
I ; to ignore the error # N/A if column A MASTER of 2 LIST list
and the elements are not the same, you try.
2013/1/25, amar takale amartak...@gmail.com:
Dear betnmtdongnai,
what is use of (;;)
if u are using 2010 then you can use NETWORKDAYS.INTL
other wise
use sumproduct (=(G2-F2)-SUMPRODUCT((HOliday=F2)*(HOliday=G2)))
holiday list as per your requirement
Thanks
XLS S
On Thu, Jan 24, 2013 at 3:19 PM, Amit Desai (MERU)
amit.de...@merucabs.comwrote:
Dear All,
** **
For a
please explain some more
On Thu, Jan 24, 2013 at 9:30 AM, Shiva Prasad shivaprasad1...@gmail.comwrote:
hi champs,
i have one main sheet some data sheet,
i need two dates with time between the the formula retrive the main sheet
based on Name colum in yellow color hilighted
pl z fin
use sumproduct function... please check my recent email solution
.
On Thu, Jan 24, 2013 at 1:55 AM, Amit Desai (MERU)
amit.de...@merucabs.comwrote:
Dear Friends,
** **
I need your help
** **
Refer attached file,
**1) **“Detail” sheet contains handover details of
Amar,
the code I posted must be put into a normal code module, not into the Sheet
object.
kind regards
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need
use sumproduct (=(G2-F2)-SUMPRODUCT((HOliday=F2)*(HOliday=G2)))
holiday list as per your requirement
On Mon, Jan 28, 2013 at 12:36 PM, Amit Desai (MERU) amit.de...@merucabs.com
wrote:
Dear Masters,
** **
Could you all, please reply.
** **
Best Regards,
Amit Desai
Hi minimaster,
I put into a normal code module but not work Pls send me above
attached report Name Excel file with that code.I dont know why?
Pls.
Amar
On Mon, Jan 28, 2013 at 12:53 PM, minimaster
hartmut.gruenha...@bakerhughes.com wrote:
Amar,
the code I posted must be put into a
Will this take care of excluding before Shift Start time (9:00 AM) after
ending shift hours (18:00)?
Best Regards,
Amit Desai
+91 98672 32534
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of xlstime
Sent: 28 January 2013 12:55
To: