Dear All,
Find attached query regarding While Using Vlookup Insted of Zero need
Blanks
*Best Regards,*
*Venkat *
*Chennai*
*
*
*
*
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips
Dear Venkat,
Please try.
=IF(VLOOKUP(I11,$B$3:$C$14,2,0)=0,,VLOOKUP(I11,$B$3:$C$14,2,0))
--
Thanks regards,
Noorain Ansari
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On Mon, Aug 8, 2011 at 11:37 AM, Venkat CV venkat1@gmail.com wrote:
Dear
Ctrl + Shift + P is not working in attached file
Regards,Anil Bhange
IP Phone - 512320 | Mobile - 90290 32123
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Rajan_Verma
Sent: Sunday, August 07, 2011 07:00 PM
To: excel-macros@googlegroups.com
Subject:
Dear Noorain,
Thanks for your Try...
The Below Formula is working for Cell is Blank...
But If cell Value is 0 That's the case not working...
If Cell is 0 and also Coming Blank...It should Come has a 0
*Best Regards,*
*Venkat *
*Chennai*
On Mon, Aug 8, 2011 at 11:43 AM, NOORAIN ANSARI
Hi Anil,
for the Below filejust hit the *Create Pivot Table* button Pivot will
be Generated automatically...
*Best Regards,*
*Venkat *
*Chennai*
*
*
On Mon, Aug 8, 2011 at 12:20 PM, Anil Bhange
anil.bha...@tatacommunications.com wrote:
Ctrl + Shift + P is not working in attached
IF(NOT(ISERROR(VLOOKUP(I3,$B$3:$C$14,2,0))),IF(VLOOKUP(I3,$B$3:$C$14,2,0)=,,VLOOKUP(I3,$B$3:$C$14,2,0)),Not
Found)
On Mon, Aug 8, 2011 at 12:22 PM, Venkat CV venkat1@gmail.com wrote:
Dear Noorain,
Thanks for your Try...
The Below Formula is working for Cell is Blank...
But If cell
Dear Venkat try it
=IF(OR(VLOOKUP(F3,$B$3:$C$14,2,0)=0,VLOOKUP(F3,$B$3:$C$14,2,0)=),,VLOOKUP(F3,$B$3:$C$14,2,0))
On Mon, Aug 8, 2011 at 12:22 PM, Venkat CV venkat1@gmail.com wrote:
Dear Noorain,
Thanks for your Try...
The Below Formula is working for Cell is Blank...
But If cell Value
जो मुरझाये ना कभी वो कवल है दोस्ती.
दिल के पवित्र ख्यालों की पहल है दोस्ती.
दोस्ती दोस्तों के दम से निभाई जाती है,
मिले आप जैसे दोस्त तो सफल है दोस्ती.
खुदगर्ज दोस्त हो तो गन्दी नाली है दोस्ती,
सच्चे दोस्त के खातिर गंगाजल है दोस्ती.
रिश्तों में सबसे ऊँचा दर्जा है दोस्ती का,
थोड़ी शोख,थोड़ी नटखट,
Dear Seraj,
Please don't keep in loop of excel-macros group's mail in chain mail.
This group is dedicated for only Excel,Macro and Access.
Thanks regards,
Noorain Ansari
2011/8/7 seraj alam seraj.ala...@gmail.com
जो मुरझाये ना कभी वो कवल है दोस्ती.
दिल के पवित्र ख्यालों की पहल है
Dear Ashish,
WorkingThank you
Dear Noorain,
Ashish's formula WorkingThanks for your try.
*Best Regards,*
*Venkat *
*Chennai*
*
*
On Mon, Aug 8, 2011 at 12:33 PM, ashish koul koul.ash...@gmail.com wrote:
Thank You so much. It is a great start. You are gwonderful!!!. Do i have
to keep the source sheet (data) in the same file as the macro? or can i
seperate them and put them in different files but in a common folder ?
On Sun, Aug 7, 2011 at 10:29 PM, ashish koul koul.ash...@gmail.com wrote:
Hi Friends,
I need one help.
I have 5 to 6 graphs in a sheet. On clicking a combo box respective graph
should pop up. Please help me.
Thanks
N.Sundarvelan
9600160150
--
--
Some important links for excel users:
1.
See if it helps
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Sara Lee
Sent: Monday, August 08, 2011 12:32 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ urgent macro or template r eq
i have a table in excel like below
volume
See if it helps
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Venkat CV
Sent: Monday, August 08, 2011 11:37 AM
To: Google
Subject: $$Excel-Macros$$ While Using Vlookup Insted of Zero need Blanks...
Dear All,
Find attached query regarding While
Hi Sundarvelan ,
Look attached it May help u...
*Best Regards,*
*Venkat *
*Chennai*
On Mon, Aug 8, 2011 at 4:01 PM, Sundarvelan N nsund...@gmail.com wrote:
Hi Friends,
I need one help.
I have 5 to 6 graphs in a sheet. On clicking a combo box respective graph
should pop up. Please help
Read this Small Book
http://devedzic.fon.rs/publications/SEKE-Handbook-2.pdf
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of lucky
Sent: Saturday, August 06, 2011 7:53 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$
Thank you raj for your help
On Sun, Aug 7, 2011 at 8:04 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
*See this Function :*
* *
*if sum of any Two cell in selected Range is Equal to Given Value in
Second Parameter of Function then Function will Return the Address of that
Two Cells,
Hi Lucky,
First you have to determine your requirement...and then you have decide
which software is convinent to perform
the Operation it's if Windows based application you may Try VB,
If web projects try in JAVA ,.NET like that...Same DB Like SQL,ORACLE,OR MS
Access..
*Best Regards,*
*Venkat
Anyone have any ideas on this please?
On Aug 3, 9:50 pm, Kevin gray kevinrobertg...@hotmail.com wrote:
Please see attachments
Date: Wed, 3 Aug 2011 07:48:44 +0530
Subject: Re: $$Excel-Macros$$ Code need to Transfer Excel worksheets labelled
1 to X to Word.
From: venkat1@gmail.com
To:
I think a One point lesson on this add in would be highly welcome.
Thanks
On Aug 8, 10:27 am, Anil Bhange anil.bha...@tatacommunications.com
wrote:
Hi Rajan,
Still I am not able to do with this addin, find below screen preview
[cid:image001@01CC5605.69E40C40]
Regards, Anil Bhange
IP
I have two adjacent columns of consecutive numbers, spaced several
rows apart each. For example:
A B
149 | #149 Story
150 | #150 Story
I know how to create consecutive numbers in column A. Is there a way
to automatically populate the numbers in column B? Is there a way to
Hi friends,
I am not good at excel. I have a requirement now, Can some one please give
the macro to compare two worksheets in diferent workbooks and display the
differences.
Regards,
Rajendra
8147524172
--
--
Some
Q-1 )Can I write VBA code to protect or unprotect my VB Project?
Q-2) Why does Excel have two macro languages?
Q-3) Can I lock cells such that only specific users can modify them?
Q-4) When I enter a value, it appears with two decimal places. For
example, when I enter 123 it shows
Hi how to make project unviewable i.e. when we do Alt+F11 and try to expand the
code it shows below pop up.
i have a file which if i try to open shows pop up saying project is unviewable
i tried to send the file but i cannot attach it. i think this is 1 more
functionality.
that excel file
check this
http://www.rondebruin.nl/notes.htm
On Mon, Aug 8, 2011 at 3:23 PM, Chandra Shekar chandrashekarb@gmail.com
wrote:
Hi,
Please find attached file I have code to send mail to lotus notes id. Here
I need range from A1:E6 pasted as object as in the body of notes as shown in
*
Hi ,
Try Below see if helps else please attach some sample workbook
**=#A1 Story*
*Best Regards,*
*Venkat *
*Chennai*
On Tue, Aug 9, 2011 at 12:07 AM, deej109 erickson...@gmail.com wrote:
I have two adjacent columns of consecutive numbers, spaced several
rows apart each. For example:
*Hi ,*
*
*
*Look below link it may help u*
http://www.excelforum.com/excel-programming/392497-project-is-unviewable.html
http://support.microsoft.com/kb/q229499/
*Best Regards,*
*Venkat *
*Chennai*
On Tue, Aug 9, 2011 at 3:30 AM, hanumant shinde arsfan2...@yahoo.co.inwrote:
Hi how to
Right click sheet tabview codeinsert this. Now when you put 149 in col A
col B will populate
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row 2 Or Target.Column 1 Then Exit Sub
Target.Offset(, 1) = # Target Story
End Sub
-Original Message-
From: deej109
Sent:
You need to post examples, etc.
From: Rajendra prasad yadav
Sent: Monday, August 08, 2011 1:31 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Help needed. compare two wxcel files
Hi friends,
I am not good at excel. I have a requirement now, Can some one please give the
macro
Homework?
-Original Message-
From: XLS S
Sent: Monday, August 08, 2011 3:38 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Question
Q-1 )Can I write VBA code to protect or unprotect my VB Project?
Q-2) Why does Excel have two macro languages?
Q-3) Can I
What do you need to do in Word that you can't do in excel?
-Original Message-
From: skyping1
Sent: Monday, August 08, 2011 12:07 PM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Code need to Transfer Excel worksheets
labelled 1 to X to Word.
Anyone have any ideas on this
31 matches
Mail list logo