) = Right(ms, Len(ms) - 1)
Next r
End Sub
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Sourabh Salgotra
Sent: Sunday, February 26, 2012 10:23 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ help needed??
thanks for help sir
i am already done with if statement
I do not disagree.
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Asa Rossoff
Sent: Wednesday, February 22, 2012 7:36 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Help with code please.
Hey Don,
I wasn't saying my modification would be faster. Find starts
it.??
Don Guillett
SalesAid Software
dguille...@gmail.com
*From:* Asa Rossoff a...@lovetour.info
*Sent:* Tuesday, February 21, 2012 2:10 PM
*To:* excel-macros@googlegroups.com
*Subject:* RE: $$Excel-Macros$$ Help with code please.
Too true Don//
.Find finds
21, 2012 7:14 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help with code please.
Don, your code works fine for the selection. I would gladly accept any
correction if somebody did that to me. My only point is that
1. Find doesn't stop the loop
in other words, the loop
Glad to help
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Jorge Marques
Sent: Wednesday, February 22, 2012 10:00 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help on gathering duplicate summing and counting
Hi, Aamir Shahzad was option was good
=IF(AND(A1=3000,A1=4500),B1*0.5,)
On Wed, Feb 22, 2012 at 11:14 PM, Seraj Alam seraj.ala...@gmail.com wrote:
Please try this in C1
=IF(A1=3000,IF(A1=4500,B1*0.5,),)
seraj alam
On Tue, Feb 21, 2012 at 12:31 AM, m7md.gmail mo7md.m7m...@gmail.comwrote:
Please check attached
I need this
-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of dguillett1
Sent: Tuesday, February 21, 2012 1:34 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help with code please.
Asa, Agree about the undue attention. My experience tells me that just
leaving
thanks :)
On Tue, Feb 21, 2012 at 8:41 PM, Sam Mathai Chacko samde...@gmail.comwrote:
=IF(AND(A1=3000,A1=4500),B1*0.5,B1)
Sam Mathai Chacko
On Tue, Feb 21, 2012 at 2:01 PM, m7md.gmail mo7md.m7m...@gmail.comwrote:
Please check attached
I need this function necessary now .
thanks,
*
thanks :)
On Wed, Feb 22, 2012 at 2:47 PM, m7md.gmail mo7md.m7m...@gmail.com wrote:
thanks :)
On Tue, Feb 21, 2012 at 8:41 PM, Sam Mathai Chacko samde...@gmail.comwrote:
=IF(AND(A1=3000,A1=4500),B1*0.5,B1)
Sam Mathai Chacko
On Tue, Feb 21, 2012 at 2:01 PM, m7md.gmail
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help with code please.
You'd want to exit the routine if the cell is found. Also, you can use
application.goto to select the cell. I would also be weary about hidden sheets
if any.
Sub lookinallsheets()
Dim wks As Worksheet
]
On Behalf Of dguillett1
Sent: Tuesday, February 21, 2012 11:42 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help with code please.
Sam, The code I provided does stop the macro with the selection. Yes, goto
could be used but OP said
select sheet
select cell
so I did that. 6
...@lovetour.info]
Sent: Tuesday, February 21, 2012 12:11 PM
To: 'excel-macros@googlegroups.com'
Subject: RE: $$Excel-Macros$$ Help with code please.
Too true Don//
.Find finds the first match. and stops.
However, with all the undue attention to this code, I will offer a suggested
update. The Set
Subject: RE: $$Excel-Macros$$ Help with code please.
Too true Don//
.Find finds the first match… and stops.
However, with all the undue attention to this code, I will offer a suggested
update. The Set mg = .Cells.Find lines can be changed to the following to
prevent an oft-overlooked issue
...@gmail.com
*From:* Asa Rossoff a...@lovetour.info
*Sent:* Tuesday, February 21, 2012 2:10 PM
*To:* excel-macros@googlegroups.com
*Subject:* RE: $$Excel-Macros$$ Help with code please.
Too true Don//
.Find finds the first match… and stops.
However, with all the undue
dguille...@gmail.com
From: Sam Mathai Chacko
Sent: Tuesday, February 21, 2012 6:56 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help with code please.
Haha, I like the way you put that Don. I agree 6 of 1 is half a dozen of
another. On the other point however, I am afraid
*From:* Sam Mathai Chacko samde...@gmail.com
*Sent:* Tuesday, February 21, 2012 6:56 PM
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Help with code please.
Haha, I like the way you put that Don. I agree 6 of 1 is half a dozen of
another. On the other point however, I
:=xlNext)
If Not mf Is Nothing Then
.Select
mf.Select
End If
End With
Next ws
End Sub
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Bob
Sent: Monday, February 20, 2012 2:28 PM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Help with code please
MACROS
Subject: Re: $$Excel-Macros$$ Help with code please.
There will never be more than 1 of the same number. I just need it to
select the sheet that it's on and then select the cell where it's
located. Thanks in Advance
On Feb 19, 8:58 am, dguillett1 dguille...@gmail.com wrote:
If you
=IF(AND(A1=3000,A1=4500),B1*0.5,B1)
Sam Mathai Chacko
On Tue, Feb 21, 2012 at 2:01 PM, m7md.gmail mo7md.m7m...@gmail.com wrote:
Please check attached
I need this function necessary now .
thanks,
*
--
*
Regards,
Mohamed Mahmoud
--
FORUM RULES
Try it in C1,
=IF(AND(A13000,A14500),B1*0.5,)
If A1 is not in between 3000 and 4500, nothing will show.
On Tue, Feb 21, 2012 at 12:31 PM, m7md.gmail mo7md.m7m...@gmail.com wrote:
Please check attached
I need this function necessary now .
thanks,
*
--
*
Dear Jorge,
See the third table in attached sheet.
Aamir Shahzad
On Mon, Feb 20, 2012 at 9:30 PM, Jorge Marques leote.w...@gmail.com wrote:
Hi friends, i have a problem,
1. i trying to use a report and i have to sum the column H, G, F, if the
orders numbers are equal and
2. leave the
(Cells(i + 1, g)) + Val(Cells(i, g))
Rows(i + 1).Delete
End If
Next i
End Sub
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Aamir Shahzad
Sent: Monday, February 20, 2012 11:11 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help on gathering duplicate summing
There will never be more than 1 of the same number. I just need it to
select the sheet that it's on and then select the cell where it's
located. Thanks in Advance
On Feb 19, 8:58 am, dguillett1 dguille...@gmail.com wrote:
If you are saying you want to look for it on all sheets you can wrap in a
If you are saying you want to look for it on all sheets you can wrap in a
loop
for each ws in worksheets
ws.Select
Cells.Find(What:=IndividualSearch,
LookIn:=xlValues,LookAt:=xlWhole).Activate
next ws
Or, are you saying there could be more than ONE hit?? BTW you don't need to
select to work
http://www.4shared.com/file/3WYWaW-Y/Indian.html
On Mon, Feb 13, 2012 at 1:26 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Vikram,
Please find attached Converter.
On Sun, Feb 12, 2012 at 8:00 PM, Vic Kumar vikramahuj...@gmail.comwrote:
Hi,
Please find enclosed macro to
Dear Vikram,
Please find attached Converter.
On Sun, Feb 12, 2012 at 8:00 PM, Vic Kumar vikramahuj...@gmail.com wrote:
Hi,
Please find enclosed macro to convert numeric value to words in excel
(Rupees).
I have enclosed macro related to Dollar value but i need the same for
Rupees.
Hi,
Use this formula with CSE.
*=IF(INDIRECT(EMP.DATA)=,,INDIRECT(EMP.DATA))*
Regards,
MARIES.
On Thu, Feb 9, 2012 at 3:42 PM, Shaik Waheed waheedb...@gmail.com wrote:
Hi Experts,
I have an excel sheet with defined named ranges. When I am using Indirect
array formula to capture the named
Thank you Maris for ur reply.its working fine.
On Thu, Feb 9, 2012 at 5:18 PM, Maries talk2mar...@gmail.com wrote:
Hi,
Use this formula with CSE.
*=IF(INDIRECT(EMP.DATA)=,,INDIRECT(EMP.DATA))*
Regards,
MARIES.
On Thu, Feb 9, 2012 at 3:42 PM, Shaik Waheed
Dear waheed,
It is also possible without Indirect function..
=IF(ISBLANK(EMP.DATA),,EMP.DATA)
With ctrl+shift+Enter
On Thu, Feb 9, 2012 at 6:00 PM, Shaik Waheed waheedb...@gmail.com wrote:
Thank you Maris for ur reply.its working fine.
On Thu, Feb 9, 2012 at 5:18 PM, Maries
Thanks noorain
thats wonderful,
On Thu, Feb 9, 2012 at 6:12 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear waheed,
It is also possible without Indirect function..
=IF(ISBLANK(EMP.DATA),,EMP.DATA)
With ctrl+shift+Enter
On Thu, Feb 9, 2012 at 6:00 PM, Shaik Waheed
The easiest way is to uncheck the show zeroes in the Excel option.
Regards,
Sam Mathai Chacko
On Thu, Feb 9, 2012 at 6:31 PM, Shaik Waheed waheedb...@gmail.com wrote:
Thanks noorain
thats wonderful,
On Thu, Feb 9, 2012 at 6:12 PM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Dear
Hi Noorain ansari,
Data will be floo see r eree s seer(A23),seruo serereserrser seeess kke(A89 )
=I need ans answer as A23,A89
but if i use your formula i am getting A23 only .i need both A23,A89
On Thu, Dec 29, 2011 at 11:33 AM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Dear Vijay,
Hi Noorain,
Please find the attached sheet.
Thanks
On Fri, Feb 3, 2012 at 10:30 PM, vijayajith VA vijayajith...@gmail.comwrote:
Hi Noorain ansari,
Data will be floo see r eree s seer(A23),seruo serereserrser seeess
kke(A89 ) =I need ans answer as A23,A89
but if i use your formula i am
Thanks noorain;
On Fri, Feb 3, 2012 at 11:00 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Vijay,
Please try through this UDF..
Function Extract_number(rng As String)
For i = 1 To Len(rng)
If Mid(rng, i, 1) = ( Then
Extract_number = Extract_number Mid(rng, i + 1, 3)
attachment Missing
On Tue, Jan 31, 2012 at 9:26 AM, PRAVESH KUMAR praveshkash...@gmail.comwrote:
Hi Group,
I want to extract my data horizently according to my header from vertical
row data.
See attached sheet for more clearity.
Thanks in advance
With Regards,
Pravesh
--
FORUM
Hi Vijay,
Look Below about relative refrence..
*What are the types of references?*1. Absolute Column/Absolute Rowe.g.
$A$1means
Whether you use auto-fill across column or across row, the reference won't
be changed.
2. Absolute Column/Relative Rowe.g. $A1means When you use auto-fill across
Venkat,
You are digressing from the question, although explaining what absolute and
relative reference is good for common understanding. The question in
particular, however, is regarding relative reference in vb developer tab.
Vijay, the Relative Reference button is just a way to tell the VBA
Dear Vijay,
You can use..
*=SUM(INDEX((MONTH($A$2:$A$28)=1)*($C$2:$C$28=Passed),0,0))*
See attached sheet..
On Sat, Jan 14, 2012 at 12:30 PM, vijayajith VA vijayajith...@gmail.comwrote:
Hi Gurus,
Please find the attached querY
Thanks in adv.
--
FORUM RULES (986+ members already
*Find the attached file...*
On Sat, Jan 14, 2012 at 11:08 AM, Sam Mathai Chacko samde...@gmail.comwrote:
You can use COUNTIFS, but SUMPRODUCT, should be an easy option since it
will work in Excel 2003 or 2007+
Regards,
Sam Mathai Chacko
On Sat, Jan 14, 2012 at 12:30 PM, vijayajith VA
Sumproduct should work as well withOUT array entering
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Maries
Sent: Saturday, January 14, 2012 5:15 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ help
Find the attached file...
On Sat, Jan 14, 2012 at 11:08 AM
Hi Friend,
as per my observation, please find the attachment
Team
XLS
On Fri, Jan 13, 2012 at 8:37 PM, Jorge Marques leote.w...@gmail.com wrote:
Hi guys, i´m doing a excel file for comparatives of the year 2010, 2011,
2012, the problem is that i need to compare days, like if i choose to see
I’m looking at your file and trying to determine what you want.??? Do you want
to know the sum for 11 Jan of each year? What___
A better explanation and example showing comes from what cell or cells
__to where__and why_?
Don Guillett
SalesAid Software
You can use COUNTIFS, but SUMPRODUCT, should be an easy option since it
will work in Excel 2003 or 2007+
Regards,
Sam Mathai Chacko
On Sat, Jan 14, 2012 at 12:30 PM, vijayajith VA vijayajith...@gmail.comwrote:
Hi Gurus,
Please find the attached querY
Thanks in adv.
--
FORUM RULES
Hi raghav,
Do you want to make short cut key to Navigate worksheets??
Rajan.
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Raghav
Sent: Dec/Sat/2011 12:51
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Help..
Yes i want this.
Sent from my Nokia phone
-Original Message-
From: Rajan_Verma
Sent: 31/12/2011 5:15:04 pm
Subject: RE: $$Excel-Macros$$ Help..
Hi raghav,
Do you want to make short cut key to Navigate worksheets??
Rajan.
-Original Message-
From: excel-macros
05:21
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Help..
Yes i want this.
Sent from my Nokia phone
-Original Message-
From: Rajan_Verma
Sent: 31/12/2011 5:15:04 pm
Subject: RE: $$Excel-Macros$$ Help..
Hi raghav,
Do you want to make short cut key to Navigate
Hi,
With the help of a helper column, a Pivot table would do the trick.
PFA.
Kris
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
Hi Kris,
you right..it is very complex with formula..I have to use Pivot
table.itwill very easy..
Thanks
Nikhil Shah
On Fri, Dec 30, 2011 at 1:18 PM, Kris krishnak...@gmail.com wrote:
Hi,
With the help of a helper column, a Pivot table would do the trick.
PFA.
Kris
--
FORUM RULES
-macros@googlegroups.com] *On Behalf Of *Maries
*Sent:* Dec/Thu/2011 12:14
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Help
** **
Find the attachment
On Wed, Dec 28, 2011 at 9:23 PM, Nikhil Shah nikhil201...@gmail.com
wrote:
Dear Friend
] *On Behalf Of *Nikhil Shah
*Sent:* Dec/Fri/2011 12:37
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Help
** **
Dear Rajan
** **
Opps..Sorry..Answer is wrong..
** **
Again I am sending fresh excel sheet..
** **
Pl help
** **
Nikhil
Try this
=SUMPRODUCT(--(B2:B320),--(B3:B330))
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Nikhil Shah
Sent: Dec/Wed/2011 10:14
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Help
Dear Friend,
I want to find out Consecutive
What if three Consecutive year have negative % then what output you want..?
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Nikhil Shah
Sent: Dec/Wed/2011 10:14
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Help
Dear Friend,
I want
Dear Friend,
it is not three ..it is Only TWO Year :
Ex.( 1 ).1986 To 1987 ( 2 ). 2000 To 2001..This Years
So Consecutive Negative Year should be 2 Years..This answer i want ..I want
Excel Formula
Regards
Nikhil
On Wed, Dec 28, 2011 at 10:44 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
Is this the way you want
On Tue, Dec 27, 2011 at 1:39 PM, lucky singh lucky60...@gmail.com wrote:
Hi Team,
Request you to kindly help
I want is a grid on the right the red line to be highlighted properly
with the blue lines
Regards,
Lucky S
--
FORUM RULES (934+ members already
See the attached sheet
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Shaik Waheed
Sent: 27 December 2011 02:03
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help on chart
Is this the way you want
On Tue, Dec 27, 2011 at 1:39
What will be your output?
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of vijayajith VA
Sent: 25 December 2011 03:02
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ help
Hi ,
i have some data like 1) floo see r eree s seer(A23),seruo
HI Rajan,
I need only A23,A89 --for 1st one
S89 for second one
Thanks
On Sun, Dec 25, 2011 at 3:08 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
What will be your output?
** **
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf
HI Rajan,
Data will be floo see r eree s seer(A23),seruo serereserrser seeess kke(A89 )
=I need A23, A89
seruo serereserrser seeess kke(A89) = A89
seruo serereserrser seeess kke(A81) ==i need A81
seruo serereserrser seeess kke(A89),seruo serereserrser
-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of vijayajith VA
Sent: 25 December 2011 04:23
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ help
HI Rajan,
Data will be floo see r eree s seer(A23),seruo serereserrser seeess kke(A89
) =I need A23
Hi,
Can you please clear one thing-- Data will be in a cell or in different
cells ?, if its in different cells then you can simply use find() and mid
function.
On 25 December 2011 16:23, vijayajith VA vijayajith...@gmail.com wrote:
HI Rajan,
Data will be floo see r eree s seer(A23),seruo
This will extract any Letter and number such as B2004 from your string. Place
in a REGULAR module and use
=xtract(a1)
and copy down to get A89, etc
Function Xtract(ByVal ref As String) As String
Dim rx As Object, arr As Object, i As Integer
Set rx = CreateObject(VBscript.Regexp)
With rx
Thanks Don Guillett and Aamir Shahzad for your support.
The solutions was very good and very quick.
Regards,
Vijayendra
2011/12/18 dguillett1 dguille...@gmail.com
=IF(A3=,,IFERROR(VLOOKUP(A3,Sheet1!$A:$A,1,0),not recieved))
Don Guillett
SalesAid Software
dguille...@gmail.com
*From:*
Glad to help
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Vijayendra Rao
Sent: Sunday, December 18, 2011 11:52 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help on isblank iferror
Thanks Don Guillett and Aamir Shahzad for your support.
The solutions
Dear Vijay,
Please find solution with Isblank+Iferror Combination..
=IF(*ISBLANK(A2)*=TRUE,,*IFERROR*(VLOOKUP(A2,Sheet1!$A:$A,1,0),not
recieved))
-
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/*
http://www.contextures.com/xlpivot01.html
http://www.contextures.com/xlpivot04.html
http://www.contextures.com/tiptech.html
On Sat, Dec 17, 2011 at 9:46 AM, Ruchi Sharma simpliru...@gmail.com wrote:
plzz tell me how to make a pivot table
--
FORUM RULES (934+ members already BANNED for
=IF(A3=,,IFERROR(VLOOKUP(A3,Sheet1!$A:$A,1,0),not recieved))
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Vijayendra Rao
Sent: Friday, December 16, 2011 6:44 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Help on isblank iferror
Hi All,
I want to put isblank and
as desired
=IF(ISBLANK(A2),,IF(ISNA(VLOOKUP(A2,Sheet1!$A$2:$A$3,1,0)),Not
Received,SUMIF(Sheet1!$A$2:$A$3,A2,Sheet1!$B$2:$B$3)))
See the attached sheet.
Aamir Shahzad
On Fri, Dec 16, 2011 at 5:44 PM, Vijayendra Rao vijayendrar...@gmail.comwrote:
Hi All,
I want to put isblank and iferror
, b).Select
Application.ScreenUpdating = False
End If
End Sub
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message- From: Ankit Agrawal
Sent: Saturday, December 10, 2011 9:54 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help in preparing
: Saturday, December 10, 2011 9:54 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help in preparing the column automatically
Dear Sir,
I had some confusion regarding my sheet now it has been clear.Please
find my new attachment.plz solve my below metion query
* I shell start
Dear Yogi,
You can also try through UDF Nested_If
*Function Nested_if(rng As Range)
counter = 1
For Each cell In rng
If cell.Value 5 Then
counter = counter + 1
End If
Next
If counter 2 Then
Nested_if = Good
Else
Nested_if = Poor
End If**
End Function
*
On Sat, Dec 10, 2011 at 4:29
Hi yogi,
Can use this formula too...
=IF(SUM(--(A1:D15))=2,Good,Poor)
(apply with Ctrl + Shift + Enter)
Regards,
MARIES.
On Mon, Dec 12, 2011 at 7:00 PM, rajan verma rajanverma1...@gmail.comwrote:
See the attached File..
On Wed, Nov 30, 2011 at 8:39 PM, Sam Mathai Chacko
Software
dguille...@gmail.com
From: Ankit Agrawal
Sent: Saturday, December 10, 2011 1:13 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help in preparing the column automatically
Deal All,
PFA as per your query.
Regards,
Ankit
On Fri, Dec 9, 2011 at 8
HAI ALL .I HAVE SMALL DOUBT IN CONDITIONAL (and) function
Q1) i have four months
jan feb marapr
61 5 0
if any two month get ' 5' then the result is GOOD other wise POOR . KINDLY
RECTIFY THIS PROBLEM.
THANK Q
--
FORUM RULES (934+ members already BANNED for
Hi,
Can you explain more or send us the sample.
Regards,
MARIES.
On Sat, Dec 10, 2011 at 2:59 PM, yogiyogi123 yogiyogi...@gmail.com wrote:
HAI ALL .I HAVE SMALL DOUBT IN CONDITIONAL (and) function
Q1) i have four months
jan feb marapr
61 5 0
if any
=IF(COUNTIF(A3:D3,5)1,good,bad)
Don Guillett
SalesAid Software
dguille...@gmail.com
From: yogiyogi123
Sent: Saturday, December 10, 2011 4:59 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help for If nesting formula
HAI ALL .I HAVE SMALL DOUBT IN CONDITIONAL
@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Help for If nesting formula
HAI ALL .I HAVE SMALL DOUBT IN CONDITIONAL (and) function
Q1) i have four months
jan feb marapr
61 5 0
if any two month get ' 5' then the result is GOOD other wise POOR .
KINDLY
Glad to help
Don Guillett
SalesAid Software
dguille...@gmail.com
From: yogiyogi123
Sent: Saturday, December 10, 2011 8:50 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help for If nesting formula
thankq very much
On Sat, Dec 10, 2011 at 8:06 PM, dguillett1 dguille
You need to give examples
col b. could/should be from data validation list
col a. incremented automatically when you enter col B. Example of next number
col c. same as col B using DV
col I. “agreement sheet” ?
col J. populated on what__occurring.
Don Guillett
SalesAid Software
Deal All,
PFA as per your query.
Regards,
Ankit
On Fri, Dec 9, 2011 at 8:19 PM, dguillett1 dguille...@gmail.com wrote:
You need to give examples
col b. could/should be from data validation list
col a. incremented automatically when you enter col B. Example of next
number
col c. same as
Hello Mr Sam,
Thank you very much of your help.
Regards
Son
2011/11/28 Sam Mathai Chacko samde...@gmail.com
Great, so no modifications required for Excel 2010
The code below works for both 2003 and 2010
Sub Consolidator()
Dim rngStart As Range
Dim varArray As Range
You need to explain a bit more with examples
Don Guillett
SalesAid Software
dguille...@gmail.com
From: manhar prajapati
Sent: Tuesday, November 29, 2011 4:14 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Help for stock file
Dear All HI
Please Find attach file for my quary.
Dear Sir
I require a formula which can deducted raw material and packing material
when i enter the procution.
Example:
If i enter production of protozyme II of 5000 kg and use blank granule
4950kg and seaweed 50ltr so when i enter Protozyme II 5000kg it is deducted
form raw material and and
Dear Lucky,
Please paste below formula in B2 Cell.
=IF(AND(A2=$F$2,A2=$G$2),0-3 Month,IF(AND(A2=$F$3,A2=$G$3),3-6
Month,IF(AND(A2=$F$4,A2=$G$4),6-9
Month,IF(AND(A2=$F$5,A2=$G$5),9-12
Month,IF(AND(A2=$F$6,A2=$G$6),12 Month,Prospect)
On Wed, Nov 30, 2011 at 12:09 PM, lucky singh
Hi Singh,
Would you explain the logic for the file? If 1 value is bigger than another
1, you would like the cell to return something, am i right??
Darwin
2011/11/30 lucky singh lucky60...@gmail.com
Hello Team,
Require your help for If nesting formula please see the attachment.
Regards,
Thanx to all my team member and Noorain.
On Wed, Nov 30, 2011 at 12:24 PM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Dear Lucky,
Please paste below formula in B2 Cell.
=IF(AND(A2=$F$2,A2=$G$2),0-3 Month,IF(AND(A2=$F$3,A2=$G$3),3-6
Month,IF(AND(A2=$F$4,A2=$G$4),6-9
Hi Rajan,
Thank you very much but i like macro better because it is really fast.As
you known my sheet is large with lots of rows.
Hope that your experience'll help everyone .
Regards
Son
2011/11/27 rajan verma rajanverma1...@gmail.com
Hi
Please see the attached file.. Pivot table can be
Hi Mr Sam.
I wonder this code used for which office as 2003,2007,2010.Because my
office is 2003 and result is not to like my desirement.
Hope that you can feed back more to me
Regards
son
2011/11/27 Sam Mathai Chacko samde...@gmail.com
Here's a macro to get this done
Sub Consolidator()
Son, the macro is written for 2007-10. Will send a modified version,
but before that, can you confirm the result is correct in 2007-10? If
not, what is the issue?
Sam
On 28/11/2011, son nguyen sonnguye...@gmail.com wrote:
Hi Mr Sam.
I wonder this code used for which office as
Hi Sam
I tried on office 2010 ,result is ok.Could you send me a modified version
2003 and explain for me a bit of this code as i am a beginer of VB.
Thanks a lot
Son
2011/11/28 Sam Mathai Chacko samde...@gmail.com
Son, the macro is written for 2007-10. Will send a modified version,
but
Great, so no modifications required for Excel 2010
The code below works for both 2003 and 2010
Sub Consolidator()
Dim rngStart As Range
Dim varArray As Range
Application.ScreenUpdating = 0
Range(F1).CurrentRegion.Clear
With Cells.Find(What:=Machine, Lookat:=xlWhole,
Chacko
Sent: Monday, November 28, 2011 8:32 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help me with a macro
Great, so no modifications required for Excel 2010
The code below works for both 2003 and 2010
Sub Consolidator()
Dim rngStart As Range
Dim varArray As Range
Dear son
Here with i attached excel file using sumif command.
Mothilal
On Sat, Nov 26, 2011 at 8:23 PM, son nguyen sonnguye...@gmail.com wrote:
Dear all,
I have problem of calculating sheet.Detail as sheet attached.
I want to have a macro to sum value within qty, and downtime column
Hi
Please see the attached file.. Pivot table can be used for this ..
Regards
Rajan
On Sat, Nov 26, 2011 at 8:23 PM, son nguyen sonnguye...@gmail.com wrote:
Dear all,
I have problem of calculating sheet.Detail as sheet attached.
I want to have a macro to sum value within qty, and downtime
Here's a macro to get this done
Sub Consolidator()
Dim rngStart As Range
Application.ScreenUpdating = 0
Range(F1).CurrentRegion.Clear
With Cells.Find(What:=Machine, Lookat:=xlWhole,
searchDirection:=xlNext, After:=Cells(1))
Set rngStart = Range(.Offset(1), .Offset(,
Hi,
PFA. Query Solved.
Regards,
Seema
On Fri, Nov 25, 2011 at 7:02 PM, Kenil Gala keni...@yahoo.com wrote:
Hi group,
I have a small doubt for writing a formula and require for help for it.
i have mentioned my doubt as a comment in the attached file.
Thanks Regards
--
FORUM RULES
if you are saying that g3 should be between d3 and e3 then this formula does it
for the CLOSE.
=IF(AND(G3=D3,G3E3),Low True,False)
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Kenil Gala
Sent: Friday, November 25, 2011 7:32 AM
To: excel macros ; excel yahoo groups
Subject:
Thank you seema.
Regards.
--- On Fri, 11/25/11, seema mba seema.mba2...@gmail.com wrote:
From: seema mba seema.mba2...@gmail.com
Subject: Re: $$Excel-Macros$$ Help required for a formula
To: excel-macros@googlegroups.com
Date: Friday, November 25, 2011, 4:25 PM
Hi,
PFA. Query Solved
I don't see any remaining doubts! What doubts do you have?
Sam
On Mon, Nov 21, 2011 at 10:57 AM, Shankar Bheema shankar.n...@gmail.comwrote:
thank you so much sir, if possible pls clarify my remaining doubts.
On Sun, Nov 20, 2011 at 1:06 AM, Sam Mathai Chacko samde...@gmail.comwrote:
You
Dear Sam
How to restrict max length of characters in a text box for MS ACCESS 2003 ?
On Mon, Nov 21, 2011 at 9:57 PM, Sam Mathai Chacko samde...@gmail.comwrote:
I don't see any remaining doubts! What doubts do you have?
Sam
On Mon, Nov 21, 2011 at 10:57 AM, Shankar Bheema
thank you so much sir, if possible pls clarify my remaining doubts.
On Sun, Nov 20, 2011 at 1:06 AM, Sam Mathai Chacko samde...@gmail.comwrote:
You have to create a recordset by using the OpenRecordSet command in the
CurrentDB
Use
Private Sub cmdsave_Click()
Dim rst As Recordset
501 - 600 of 1211 matches
Mail list logo