Hello everybody,
I need your help to write a formula.
In the attached sheet, you may see that there are three blocks, where zero
occurs. My question is how do i formularize it to tell me the same?
Thanks a ton!
Best
Abeer
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
Hi Kenil,
Please follow the below steps.
Select first column, go to conditional formatting. Edit the first rule:
Change the formula as =$A1="Orange"
Click OK
Change applies to as =$A:$A
Apply the same changes to the rest all.
Hope you will get answer.
Thanks and regards,
Shekhar
--
Are y
Hi Saggi,
Please send one attachment. Please tell me How to use formula in pivot table
in excel 2003?
Regards,
Alisha
On Fri, Apr 15, 2011 at 9:43 AM, saggi wrote:
> Count of Divisions PoorAvg GoodV Good
>
> Total Grand Total
> Total A
Count of Divisions PoorAvg GoodV Good
Total
Grand Total
Total Avg Avg Total
Total GoodGood Total Total
Divisi
See attached file if it helps
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/grou
With the help of pivot this can be possible
On Jan 31, 9:45 pm, Jitender kumar wrote:
> Dear Experts ,
>
> Thanks for your response . But look the sheet carefully. I have to use
> code & Rname as heading from raw data.and rest data in next rows.
> There should be blank row between second code & R
Hi Jitendra,
A solution can be found here: http://www.ozgrid.com/Excel/dependent-lists.htm
On 4 jan, 10:15, Jitendra Verma wrote:
> Hi All,
>
> I have a question related to data validation in excel.
> Below is the description..
>
> I want to create two dropdown list using the data validation lis
Do you mean the cell value will have a numeric value preceded by "Rs.
"? If so, something like this should work:
Rs. 5 is in cell A2. Rs. 10 is in cell B2.
Operand1Operand2Sum
formula
Result
Rs. 5 Rs. 10 =RIGHT(A2,LEN(A2)-find(" ",A2))+RIGHT(B2,LEN(B2)-find("
",B2)) = 15
Change this line
Dim ltext As LOng, curRow As Long
AS
Dim ltext As String, curRow As Long
Regards,
Kishan Reddy, K
On Aug 19, 10:24 pm, hemant shah wrote:
> Hi Team,
>
> I need your help in the attched excel.
>
> I have explained everything in attached sheet.
>
> Regards
> Hemant shah
>
> Pr
Thanx
REHAN
On Sat, Jul 31, 2010 at 11:54 AM, Kishan Reddy, K <
kishanreddy.kethire...@gmail.com> wrote:
> Just open the workbook in which you have created the macro.
>
> It will work in generally.
>
> Regards,
> Kishan Reddy, K
>
> On Jul 30, 2:32 pm, Rehan Baig wrote:
> > Kishan
> >
> > Thanx
Just open the workbook in which you have created the macro.
It will work in generally.
Regards,
Kishan Reddy, K
On Jul 30, 2:32 pm, Rehan Baig wrote:
> Kishan
>
> Thanx, for your help.
>
> But kindly tell me if i save macro in This Workbook,
>
> Will it work for other workbooks.
>
> REHAN
>
> O
Kishan
Thanx, for your help.
But kindly tell me if i save macro in This Workbook,
Will it work for other workbooks.
REHAN
On Wed, Jul 28, 2010 at 11:53 AM, Kishan Reddy, K <
kishanreddy.kethire...@gmail.com> wrote:
> Instead of storing the macro in personal macro workbook, select this
> workb
Instead of storing the macro in personal macro workbook, select this
workbook.
There may a problem with the personal work book.
Regards,
Kishan Reddy, K
On Jul 27, 1:10 pm, Rehan Baig wrote:
> Dear Members
>
> I have some problem with macro recording,
>
> after entering macro name, shortkut k
Can't you use the same offset and movement code... i.e. End(xlUp) and
calc two SUMIFs functions?
SUMIF(c10:cN,"COGS",e10:eN)
SUMIF(c10:cN,"Sales",e10:eN)
Dim FirstRow As Long
Dim LastRow As Long
FirstRow = 10
LastRow = Range("A65536").End(xlUp).Offset(0, 0).Row
Range("aa1")
Dear Umesh,
I have re-formulated the attached workbook.I don't think a macro is required
in this revised scenario.
Please check and get back to me in case of any queries.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi -
Dear Umesh,
Try following macro - easy to understand as well.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
I = ActiveCell.Address
If I = "$G$31" Then
Range("H31").Formula = "=F31*10%"
Range("i31").Formula = "=H31*2%"
Range("j31").Formula = "=H31*1%"
ElseIf I = "$G$32" Then
MsgBox
Dear Sir,
Thanks for all type of solution
I need it in access database too . can it be possible ?
Thanks
Jitender
On Sun, Nov 8, 2009 at 10:59 PM, ashish koul wrote:
> chek this are u looking for this
>
> On Sat, Nov 7, 2009 at 9:14 PM, Jitender wrote:
>
>>
>> Dear Sir
>>
>> Pl.see the prob
Dear Sir
Thanks for solution
But i need its vice versa too from some purpose how to do that
Again thanks
Jitender
On Sun, Nov 8, 2009 at 10:59 PM, ashish koul wrote:
> chek this are u looking for this
>
> On Sat, Nov 7, 2009 at 9:14 PM, Jitender wrote:
>
>>
>> Dear Sir
>>
>> Pl.see the probl
just remove the parentesis as follow:
Modul1.Get_Param CInt(TextBox1.Text), CInt(TextBox2.Text)
2009/11/6 laudes
>
> Hi all
>
> I've got a problem and it seems, that I'm not able to solve it without
> your help. Needless to say anything more about my programming-
> skills ;-)
> There is a
I guess when you are passing some values to a sub, You should use "Call"
keyword
Try
Call Modul1.Get_Param(CInt(TextBox1.Text), CInt(TextBox2.Text))
Hemant Hegde
2009/11/6 laudes
>
> Hi all
>
> I've got a problem and it seems, that I'm not able to solve it without
> your help. Needless to s
Hi praveen
to disable an ontime event, you need to know the scheduled time.
So, declare a module level variable to store the schedule time. Use the same
to disable the event
2009/10/27 Praveen Khunte
> Hi Everyone
>
> I have used a macro given in site
> http://www.cpearson.com/excel/OnTime.
thanx a lot..
On Fri, Oct 23, 2009 at 8:56 PM, aju chacko wrote:
> HI mahesh,
> The patch I mentioned is aivilable in following web site
> http://support.microsoft.com/kb/948944 .
> Please download and install this patch,If again problem persits you have to
> install off
HI mahesh,
The patch I mentioned is aivilable in following web site
http://support.microsoft.com/kb/948944 .
Please download and install this patch,If again problem persits you have to
install office service pack 1 & 2
aju v chacko
On Fri, Oct 23, 2009 at 3:09 PM, Mahesh wrote:
Hi Manoj,
Thanx for your suggestion,
But when i m clicking on all commands, its given my error.
Please help..
On Fri, Oct 23, 2009 at 2:13 PM, Manoj S Negi <
manojsnegi.uttranc...@gmail.com> wrote:
> Hi Mahesh,
>
> Please note the solution of your problem as follows..
>
> After appl
Hi Mahesh,
Please note the solution of your problem as follows..
After applying filter just select the desired data, which you want to copy,
& than click the option "Select visible Cells" and than copy and
paste.
*for option "Select visible Cells" go to office button and than c
Hi Aju,
Thanx for ur suggestion, but i m copying the cells not column
And i m w8ing for the patch
Mahender Bisht
On Thu, Oct 22, 2009 at 8:42 PM, aju chacko wrote:
> HI Mahesh Bisht,
> Please try to keep the cursor in data area instead
> of column heading whil
Hi Mahesh,
Please note the solution of your problem as follows..
After applying filter just select the desired data, which you want to copy,
& than click the option "Select visible Cells" and than copy and
paste.
*for option "Select visible Cells" go to office button and than c
HI Mahesh Bisht,
Please try to keep the cursor in data area instead
of column heading while you are copying the data,Also Microsoft has
announced a patch to solve this problem which I will give you shortly.
AJU
On Tue, Oct 20, 2009
Hi Debasis,
Open a blank excel workbook,
Go to Tools > options > Calculation > click on Automatic and save it at any
location.
It will work
On Mon, Jul 27, 2009 at 12:46 PM, DEBASHIS BANERJEE
wrote:
>
> Dear All ,
>
> I have been facing a problem regarding opening Xls file..(2007 format 0
>
]
On Behalf Of Adrian
Sent: Wednesday, July 22, 2009 8:39 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Re: Problem with duplicating a Shape and defining
OnAction property
Instead of trying to fix this problem, could anyone tell me how I
could make multiple images execute the same code but
Well, in this case, the shape object in question is not merely a shape,
instead an OLE Object (Image Control) is contained in it. The OLE Object
(Forms Image Control) exposes its own events. One way (weird one) is to
duplicate the Image1 shape on Click and in the Click Event handler
programmatica
By VBS, i believe you are asking for Visual basic in excel (and not
vbscript) I have listed couple of links below. I hope this helps
http://www.your-save-time-and-improve-quality-technologies-online-resource.com/free-vba-tutorials.html
http://www.businessbookmall.com/Microsoft_Excel_Directio
Hello NandKumar
Please scan through the recent posts and files on this group. You would find
links and reference to books for learning VBA.
Thanks and Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Wed, Jul 22, 2009 at 10:26 AM, Nandkumar
Hello Bro/Sis
Pls How to learn Vbs Macros pls send me link how to learn
Thanks My Big B/S
Nandkumar
On Wed, Jul 22, 2009 at 10:16 AM, vivek agrawal
wrote:
> Hello,
> According to me, the error is because of the mismatch of object type and
> not that you are not able to assign onaction property
Hello,
According to me, the error is because of the mismatch of object type and not
that you are not able to assign onaction property to a shape object.
The new_shape is of "Excel.*Shape*" type where as you are assigning to the
new_shape - the duplicate of an Excel.*Shapes *type. While, SHAPE obje
Instead of trying to fix this problem, could anyone tell me how I
could make multiple images execute the same code but with a different
parameter upon clicking?
--~--~-~--~~~---~--~~
--
Mr. msakibkhanUsually these items will be in the system, just check in "add
or remove program", in case they are not installed.
U can find those two item from www.Microsoft.com, search for those two,
download and install.
I guess we need "Microsoft .NET Framework 3.5 SP1" and "Visual Studio for
Off
Hi Ashish Jain
Thanks for your reply, I have not installed Microsoft .NET Framework
3.5 but not "Visual Studio for Office 3.0 Runtime" could you please
tell me from where i can get it?
Thanks
On Apr 30, 5:43 am, Ashish Jain <26may.1...@gmail.com> wrote:
> Hi Mr.Khan,
>
> OpenXL is a Com Addin, it
Hi Mr.Khan,
OpenXL is a Com Addin, it's not an .XLA, .XLAM or .XLL addin. Hence it
appears in Com-Addins list rather than just Addin list.
Please Check "Add/Remove Programs" and tell us that Microsoft .NET
Framework 3.5 and Visual Studio for Office 3.0 Runtime is installed or
not.
They're pre-req
Hi Mehdi,
Try this code: (Changes highlighted in Red)
[code]
Dim Rng As Range, Dn As Range, oVal, oSp As Long
Dim Ray, c As Long
Set Rng = Range(Range("A2"), Range("A" &
Hi Mehdi,
Use this formula in column c=LEFT(B2,FIND("/",B2,1)-1) then do auto fill.
regards
Mugundan K 9873152622
Office VBA Trainer
http://officevbatrainer.blog.co.in/
From: Mehdi_21
To: MS EXCEL AND VBA MACROS
Sent: Monday, March 2, 2009 7:58:59 PM
Subjec
Format-> Conditional Formatting is your friend
The easiest thing to do is to select the first box (B2 if I'm reading your
cheat sheet right) and do the following
Format-> Conditional Formatting
Choose Cell Value Is from the first drop down
Choose Equal To from the second drop down
Type "=B$1" in
This could be done by a VBA function but I'm curious how this will be
checked. You have the data, is it being continuously changed? Do we need to
check it continually? Do we need to compare all values of familyX and
familyY or just two specific rows at a time? Are familyX and familyY
constantly be
an
>
> Data analyst
>
> _
>
> From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
> On Behalf Of jayendra gaurav
> Sent: Thursday, February 26, 2009 6:45 AM
> To: excel-macros@googlegroups.com
> Subject: $$Excel-Macros$$ Re: problem deleting
ro = ro - 1
End If
ro = ro + 1
Wend
End Sub
Thanks
C.Saravanan
Data analyst
_
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of jayendra gaurav
Sent: Thursday, February 26, 2009 6:45 AM
To: excel-macros@googlegroups.com
Subject: $$Excel
U can also use filter option
rgd
Gaurav
On Wed, Feb 25, 2009 at 11:23 AM, Lavprasad Kori wrote:
> Hi Dear,
>
> Attached herewith the file of solution of your question. In that the
> solution is in column E. You have to copy Column E & paste special it in
> Column D.
>
> Regards,
>
> Lavprasad Ko
Hi Dear,
Attached herewith the file of solution of your question. In that the
solution is in column E. You have to copy Column E & paste special it in
Column D.
Regards,
Lavprasad Kori
MIS Executive
Hindustan Unilever Limited
Mob : 9867931351
On Tue, Feb 24, 2009 at 11:11 PM, Mehdi_21 wrote:
Assuming that your data does not have any empty rows:
Sub DeleteWhereExtra()
Dim I As Integer
For I = 2 To Worksheets("Sheet1").Range("A65535").End(xlUp).Row
If Worksheets("Sheet1").Range("A" & I).Value = "extra" Then
Worksheets("Sheet1").Range("D" & I).ClearContents
Hi Karthick,
Check this file and let me know your ideas.
regards
Officevbatrainer
From: Karthick.A.R
To: excel-macros@googlegroups.com
Sent: Thursday, December 18, 2008 2:33:43 PM
Subject: $$Excel-Macros$$ Problem with date
Hi all
I've created a form with o
49 matches
Mail list logo
