So what do you need ??
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Amit Desai (MERU)
Sent: 16 April 2013 11:02
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Column Reference based on changes in Raw reference
Dear Group,
I need
Dear Amit,
Pl share the workbook
Warm Regards,
Gawli Anil.
On Tue, Apr 16, 2013 at 11:30 AM, Priti_verma pritiverma1...@gmail.comwrote:
So what do you need ??
** **
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *Amit Desai (MERU)
Follow steps and try this. Hope this will work for you:
1. *Right Click on Cell C5*
2. *Create a hyperlink with cell refrence C5 in the same (output sheet )*
3. *Do same for Cell D5 and create hyperlink with cell refrence D5 in
the same (output sheet )*
4. *Right click on output
Hi Noorain,
Can you please share all stuff for get. function
.
Enjoy
Team XLS
On Thu, Apr 11, 2013 at 5:45 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear LK,
Please try it..
=GET.CELL(63,INDIRECT(RC[-1],))
On Thu, Apr 11, 2013 at 4:48 PM, L.K. Modi
Dear Lalit
Thats amazing,Perfect,mind blowing.Which I want I got it.Brother thank very
much. you are great.
Also Thanks others members like Chaya,Priti,Anil who struggle for my
solution.
Once agian Thanks very much all.
Regards
Amar
On Tue, Apr 16, 2013 at 12:52 PM, Lalit Mohan
Hello Ashish,
We are using MS office 2007.
I have attached sample sheet.
--
Regards
Santosh
santoshkumar.subu...@gmail.com
--
From: koul.ash...@gmail.com
Date: Mon, 15 Apr 2013 20:14:02 +0530
Subject: Re: $$Excel-Macros$$ print current file to pdf
To:
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! 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,
thx
On Monday, April 15, 2013 9:58:30 AM UTC+2, colmkav wrote:
Hi,
I am trying to set the formula of a cell to be the following: =D6
YEAR(MonthEndDate) . MONTH(MonthEndDate) . \Outputs\
However the following code gives this forumula instead: = 'D6'
YEAR(MonthEndDate) .
Hi team,
Awaiting ur valuable response on my below email.
Regards,
Kaushik Savla
-- Forwarded message --
From: KAUSHIK SAVLA savla.kaus...@gmail.com
Date: Apr 15, 2013 8:21 PM
Subject: Fwd: $$Excel-Macros$$ Time Tracking Tracker
To: excel-macros@googlegroups.com
Hi All,
I am
You didn't mention what error you're getting, or where the error occurs.
I tested it and I think I found it:
Let's take a look at how Excel operates:
If you didn't have an Event macro, when you double-click a cell,
what normally happens?
If you still have the default edit in cell option
Here's what I would do:
since you're wanting to round to 5 or 10's,
I'd multiply the number by 2, then you're technically rounding by 10's or 20's,
which, is the same as rounding by 10's.
Then, divide the number by 10 (which moves the decimal point)
and round the number to an even integer.
By
Thanks paul but it's not working.
On Tue, Apr 16, 2013 at 8:32 PM, Paul Schreiner schreiner_p...@att.netwrote:
Here's what I would do:
since you're wanting to round to 5 or 10's,
I'd multiply the number by 2, then you're technically rounding by 10's or
20's,
which, is the same as rounding
What's not working?
I placed this formula in your worksheet, copied it down,
and the results exactly matched what you listed as expected results.
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
Hi Kuldeep
I think this formula fullfil your requirement.
=ROUNDUP((A2*2)/10,0)*10/2
Regards
Priti verma
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Kuldeep Singh
Sent: 16 April 2013 8:17
To: excel-macros@googlegroups.com;
Since you've ruled out 5 and 10, I would've thought =MROUND(C1+5/2,5)
should be fine
Regards,
Sam Mathai Chacko
On Tue, Apr 16, 2013 at 8:46 PM, Priti_verma pritiverma1...@gmail.comwrote:
Hi Kuldeep
I think this formula fullfil your requirement.
=ROUNDUP((A2*2)/10,0)*10/2
For the sake of you opening up your options for a response, why don't you
tell us why you want to open the access database using code?
On Mon, Apr 15, 2013 at 6:01 PM, neilstewa...@sky.com wrote:
Hi all,
I am stuck, hope someone can help me...
I a using the following code in Excel, to open
Thanks *Paul Sam*, your formula is working fine.
Regards,
Kuldeep Singh
On Tue, Apr 16, 2013 at 11:23 PM, Sam Mathai Chacko samde...@gmail.comwrote:
Since you've ruled out 5 and 10, I would've thought =MROUND(C1+5/2,5)
should be fine
Regards,
Sam Mathai Chacko
On Tue, Apr 16, 2013 at
17 matches
Mail list logo