Hi Shekhar
Pls help me for little issuue.
On Wed, Jan 23, 2013 at 3:05 PM, amar takale amartak...@gmail.com wrote:
Hi shekhar,
pls ignore previous attachment,it is word file,I will send excel.
On Wed, Jan 23, 2013 at 3:02 PM, amar takale amartak...@gmail.com wrote:
Hi Shekhar,
As per you
Dear All,
For a calculation of TAT, I wanted to make excel treat each day as working
days..Currently excel considers 5 days as working days.. I want to change the
logic to all 7days as working days will add any applicable Sunday as holiday..
Please help me if any setting needs to be changed
NO WORRIES, I SOLVED IT, THANKS
On Thu, Jan 24, 2013 at 12:00 PM, Hilary Lomotey resp...@gmail.com wrote:
[image: Boxbe] https://www.boxbe.com/overview This message is eligible
for Automatic Cleanup! (resp...@gmail.com) Add cleanup
Hi Dear just use this
=VLOOKUP(A3,MASTER!$A$3:$B$9,2,0)
regards
prince
On Thursday, January 24, 2013 5:30:51 PM UTC+5:30, hilary lomotey wrote:
Hello Experts,
In the file attached, i have a master list with names and codes(master
sheet), and then another list (list sheet). The codes in the
I THINK I understand what you're trying to say...
You have a workbook with sheets named for each DAY of the month.
You want to SPECIFY a range to sum the values for those days
(from January 1, 2013 to January 5, 2013)
By using Excel functions (not VBA) you want formulas to update using the
I'm sorry, but I am unable to figure out a way to do what you ask.
I know if the date range is from January 1, 2013 to January 5, 2013
I want to end up with the formula:
=SUM('01:05'!C2)
I know I can use the formula:
TEXT(DAY(E3),00):TEXT(DAY(G3),00)
to get the string 01:05
but I cannot figure
Hey there -
a very simple problem that I'm trying to solve without any code if at all
possible. It's so simple that I don't even need to post a workbook:
Imagine you have two columns worth of data whereas the 2nd column is 100%
unique but items in column 1 will appear multiple times such as
Hi guys,
I'm having trouble writing a couple subs. I'm new to vba, so what I'm
asking for may be very complicated. If so, I apologize. I've attached a
sample .xslm file which I'll be referencing throughout this post. So what
I'm trying to do is use the workbook as a tool to simplify
Thanks again for all of the replies, below is the code I put together to
do this task in case anyone is interested...
LastRow = Range(C Rows.Count).End(xlUp).row
Range(A1:B LastRow).SpecialCells(xlCellTypeBlanks).FormulaR1C1 =
=R[-1]C
Columns(A:B).Copy
Hi,
Pfa.
Thanks
Karan Singh
On Fri, Jan 25, 2013 at 1:51 AM, santosh subudhi
santoshkumar.subu...@gmail.com wrote:
Hello Group,
I want to veiw table 1 data in graph when check box is true else table 2
data when check box is false.
--
Regards
Santosh
santoshkumar.subu...@gmail.com
Dear betnmtdongnai,
what is use of (;;) in formula .as like Prince simple vlookup aslo
got answer
On Thu, Jan 24, 2013 at 9:21 PM, Bé Trần Văn betnmtdongna...@gmail.com wrote:
At D3 of sheet List you can use the formula:
=IF(A3=;;VLOOKUP(A3;MASTER!$A$3:$B$9;2;0))
And Fill down, See
11 matches
Mail list logo