Hi All,
I want to disable the "Pick from Drop-down list" option on mouse right
click.
[image: Inline image 1]
--
Thanks
Kartik
--
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.faceboo
Hi,
Need to Scroll Horizontally (Column Index) Listbox with Scrollbar
control in Excel Userform.
--
Thanks
Kartik
--
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/discussexc
Use =randbetween() formula
e.g: =randbetween(1,100) which can give you a number which is between 1 to
100
Regards,
Kartik
On Thu, Dec 19, 2013 at 10:15 PM, XX wrote:
> HI all,
>
> I need some help with using excel to generate two sets of correlated
> random variables, anyone can help me with
Can you provide sample file
Regards,
Kartik
On Mon, Dec 23, 2013 at 10:07 AM, khushal wrote:
> Hie Experts..
>
> The requirement is : If the amount is outstanding for 41 days then It
> should calculate interest for 1 day and not 41 days.
>
> Thanks for your concern.
>
>
>
> On Saturday, De
Hello Experts,
I need a macro to open a particular folder from excel and should copy the
file name & sheet name & A1 value from each sheet. PFA
Thanks
Kartik
--
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 thi
Hi Chandru,
if you use "--" in front of the formula, it will convert Boolean values to
1's & 0's. For true it will convert to 1 & for false it will convert to 0.
* means multiply
Regards,
Cartik
On Mon, Nov 25, 2013 at 1:34 PM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:
> Hello,
>
Hi Folks,
For Creating Quick Name Ranges short cut key is
Ctrl+Shift+F3+Enter
Below is the example table, when you hit Ctrl+Shift+F3+Enter it will create
Name ranges for Jan to Aug & Toyota to BMW (Note you should select entire
table and press above short cut key)
Jan Feb Mar Apr May Jun Jul
Hi Shrinivas,
PFA, Let me know if you need any changes required
Regards,
Cartik
On Wed, Nov 20, 2013 at 5:10 PM, Shrinivas Shevde wrote:
> Dear All
> Please find attached query.
> Is it possible to write aformula as per my requirement
>
> --
> Shrini
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:
Hi Abhishek,
Can you please be more clear on your request, so that we can try to solve
your query
Regards,
Kartik
On Wed, Nov 13, 2013 at 10:16 AM, Abhishek Jain wrote:
> Friends,
>
> > I have a file, wherein I have times when employees are scheduled to
> work. These times are in PST.
> > I ha
Ravinder,
PFA,
Regards,
Cartik
On Tue, Nov 12, 2013 at 10:50 AM, Ravinder Kumar <
ravinderbhardwa...@gmail.com> wrote:
> Hi
>
> Please help me, to create a formula with small function and Vlook up
> function.
>
>
> Regards
> Ravindra
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And
For Unhiding the Columns, Select the entire columns(or Ctrl+Space) then
click on right click button using Mouse or right click button then Click U
On Wed, Oct 23, 2013 at 4:40 PM, Radhe Sham wrote:
> Hi Group,
>
> My system got upgraded with Windows 7 Professional.
>
> In terms of Shortkeys , H
Hi Amar,
As Ravinder said your question was not clear. I tried to resolve your
query, plz find attachment. If this is not you are looking for let us be
clear on your question.
Regards,
Kartik
On Mon, Oct 7, 2013 at 4:36 PM, amar takale wrote:
> Dear Experts
>
> Pls anybody guide me on this is
Hi Ravinder,
Thanks for the code, It's working fine.
Regards,
Kartik
On Wed, Sep 25, 2013 at 3:28 PM, Ravinder wrote:
> Pfa….select range of colored cell when it ask.
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On
Thank you Ashish...:)
Regards,
Kartik
On Tue, Sep 24, 2013 at 7:12 PM, ashish koul wrote:
> try attached file
>
>
> On Tue, Sep 24, 2013 at 6:47 PM, Kartik Dale wrote:
>
>> Hi All,
>>
>> In attached workbook I have some cells which are colored in Red,
Hi All,
In attached workbook I have some cells which are colored in Red, Green,
Yellow, Orange. I need a count of these cells. Please find attachment. I'm
looking for VBA Code, Excel formula also works fine.
Thanks in Advance
Regards,
Kartik
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? A
s that if the lookup
> table has ID 121 with Status as “ Ok” but in original table ID 121 status
> is “active” so I should come to know of the mismatch
>
>
> On Fri, Sep 6, 2013 at 1:01 PM, Kartik Dale wrote:
>
>> Hi Ashwani,
>>
>> Please find attachment. Jus
Hi Ashwani,
Please find attachment. Just drag the formula in F column if you need it.
Regards,
Kartik
On Fri, Sep 6, 2013 at 11:03 AM, ashwani agnihotri <
ashwani.agniho...@gmail.com> wrote:
> Hi,
>
> I have a query. I have two table named original and other.
>
> Now I want to look up for ID,s
Hi Pawal,
Please check this code
Private Sub Workbook_Open()
Dim expired As Date
expired = "08/18/2013"
If Now() > expired Then
Call Macro1
'here Macro1 is your another Macro Code which you would like to run-'when
today's date is greater than 08/18/2013'
Else
MsgBox "Today date is not exceeded
Hi Vijay,
Their is no need of formula to solve your request. By using sorting option
in excel we can sort the data from largest to smallest or smallest to
largest.
Here are the few steps to get your desired output
Step1
Go to cell "B1" (i.e Salary Column) press Ctrl+Shift+L
Press Alt+Downarrow
19 matches
Mail list logo
