Thanks for the reply.
But i have multiple no. of cells which needs to be updated from
separate cells of source file (file to which links are made).
So I have to click 100 times for browsing to the file. It takes hail
lot of time. (same result even I use Ctrl+H).
I need a solution by which I dont h
Congratulations Sam... Keep impetus on...!!!
On Mon, Dec 5, 2011 at 4:35 AM, Haseeb Avarakkan wrote:
>
> Congratulations Sam... Keep up the excellency!
>
> Hello Lali,
>
> FYI: Please read the forum rules. Rule# 2 says, "*Don't post a question
> in the thread of another member -- start your own.
Large returns the number of a given ranking in the sequence, without
eliminating duplicates (dupes get a ranking too).
I thought this was your interest when I commented in this thread.
Several posters gave formulas for the 2nd largest unique number, and then a
couple more gave formulas to r
Thanks Haseeb, Sam, Don for the follow-ups.
Mainly I was just commenting on the post that didn't do what I thought it
stated it did, for me.. so others could benefit from my misunderstanding :)
Nice solutions all.. These formulas can be adapted by anyone needing the
third largest/smallest, or
Hi Sam,
I had a specific question. We can use the =LARGE(,2) to retrieve the
2nd highest number in most of the cases.
However when I tried the same with a specific list 1,2,2,3,3 the result was
3 instead of 2 which shd be the correct answer.
Can you pease check, why is this exception happening.
C
Hello Asa R,
Assume your numbers are in A:A, in B1 enter *Unique_Numbers*, B2 copy
down...
=SMALL(A:A,1+COUNTIF(A:A,"<="&MAX(B1,*-*9E300)))
The above will give the unique numbers in Ascending Order,
=LARGE(A:A,1+COUNTIF(A:A,">="&MIN(B1,9E300)))
This above will give the numbers in Descending O
Hi Rekha,
If you create a "*shortcut*" of your excel file in startup folder, then it
will open automatically on window startup.
Find the startup folder in below path:
*Windows7 ==> "**C:\Users\(User-Name)\AppData\Roaming\Microsoft\Windows\Start
Menu\Programs\Startup*"
*Windows Xp ==> "C:\Document
*Workbook.ExportAsFixedFormat Method:*
http://msdn.microsoft.com/en-us/library/bb238907%28v=office.12%29.aspx
Regards,
MARIES.
+971559828492
On Sun, Dec 4, 2011 at 5:20 PM, Sam Mathai Chacko wrote:
> You will either need excel 2010 or install the pdf addin in excel 2007
>
> here's the link http
sorry for confusion . it is done thanks alot
On Sun, Dec 4, 2011 at 10:04 PM, rekha siri wrote:
> i did it by bringing line up it ran well ... but it did not delete the
> records passed step.
>
>
>
> On Sun, Dec 4, 2011 at 9:45 PM, dguillett1 wrote:
>
>> From the ss it appears that you did no
i did it by bringing line up it ran well ... but it did not delete the
records passed step.
On Sun, Dec 4, 2011 at 9:45 PM, dguillett1 wrote:
> From the ss it appears that you did not bring up the next line. Bring
> it up or insert a continuation character _
>
> Don Guillett
> SalesAid Soft
>From the ss it appears that you did not bring up the next line. Bring it up or
>insert a continuation character _
Don Guillett
SalesAid Software
dguille...@gmail.com
From: rekha siri
Sent: Sunday, December 04, 2011 9:51 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: im
hi Rajan /sam,
thanks for the reply please advise will it execute without opening the
macro or we need to open the macro sheet and then fix the reminder.
Thanks,
Rekha
On Sun, Dec 4, 2011 at 7:00 PM, rajan verma wrote:
> Sub Test()
> Application.onTime now+timevalue("00:30:00"),"ProcedureName"
Hi Sam,
Meanwhile, request you to please share the files which you have for the
same.
I hope u must have the best..
Kiran
Sent on my BlackBerry® from Vodafone
Thanks & Regards.
Kiran
-Original Message-
From: Sam Mathai Chacko
Sender: excel-macros@googlegroups.com
Date: Su
Dear All,
Hope you all are doing good.
Requesting a favor. Does anyone of you have some study material on Solver,
Goal Seek and Subtotals? I already have some from the net, but in case you
have something customized, with examples, would be great.
Regards,
Sam Mathai Chacko
--
FORUM RULES (934+
1. You give NO examplePerhaps a list and then “for each item in range(“a2:a11”)
2. Adaptable to a worksheet_change event
3. Can be done
Who are you_,Where are you___Who do you work
forWhat is this for??_
Don Guillett
SalesAid Software
dguille...@gmail
Sub Test()
Application.onTime now+timevalue("00:30:00"),"ProcedureName"
end sub
it means after 30 minute from now procedure "ProcedureName" will Execute.
On Sun, Dec 4, 2011 at 5:39 PM, Sam Mathai Chacko wrote:
> Search the net for Application.OnTime
>
> Regards,
>
> Sam Mathai Chacko
>
>
> On Sun
You will either need excel 2010 or install the pdf addin in excel 2007
here's the link http://www.microsoft.com/download/en/details.aspx?id=9943
Sam Mathai Chacko
On Sun, Dec 4, 2011 at 6:18 PM, Abdulgani Shaikh wrote:
> Dear Noorain,
>
> I have gone through your code of Excel to PDF, but it is
Dear Noorain,
I have gone through your code of Excel to PDF, but it is not working.
Please guide where I am wrong.
Sub exltopdf_converter()
Dim wrknm As String
wrknm = ActiveWorkbook.Name
wrknm = Left(wrknm, InStr(1, wrknm, ".") - 1)
ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:
Gr8, thanks a lot, its working, this saves my lot of time to hide each row
one by one.
Thanks once again.
Regards
On Sun, Dec 4, 2011 at 5:38 PM, Sam Mathai Chacko wrote:
> 1. change
>
> Cells(Rows.Count, "b").End(xlUp).Row - 1 To *4* Step -1
>
> 2. Change
>
> If Cells(i, "I") >= 0 And Cells(i, "
IT administrators mostly disable this option in the office environment to
ensure that no unwanted risk lies open by taking off outlook security. If
you are not able to change the option, then I am afraid I do not have a
solution. Maybe someone from the forum can share some advice?
Regards
Sam Mat
A simple search can give you many good results on gantt chart. I personally
like this one from chandoo
http://chandoo.org/img/pm/gantt-chart-project-management-template.zip
Regards,
Sam Mathai Chacko
On Sun, Dec 4, 2011 at 2:33 PM, Amit Desai (MERU)
wrote:
> Dear Masters,
>
> Do you have macr
working fine at my side. Cannot comment unless you send the excel file and
the text file.
Sam
On Sun, Dec 4, 2011 at 3:20 PM, rekha siri wrote:
> Sam thanks for your help in this concern however the below code when i
> try it , i am getting bug in records passed. please assist in this concern.
Search the net for Application.OnTime
Regards,
Sam Mathai Chacko
On Sun, Dec 4, 2011 at 3:25 PM, rekha siri wrote:
> hi Experts,
>
> Please advise is there any option to schedule for particular time to macro
> for execution on its on own without manual intervention.
>
> if so please advise in
1. change
Cells(Rows.Count, "b").End(xlUp).Row - 1 To *4* Step -1
2. Change
If Cells(i, "I") >= 0 And Cells(i, "L") >= 0 Then
Rows(i).Hidden = True
else
Rows(i).Hidden = False
End if
Regards,
Sam Mathai Chacko
On Sun, Dec 4, 2011 at 3:27 PM, AbdulGani Shaikh wrote:
> Thanks Sir,
> I
oh very nice Thanks buddy.
Regards,
Aamir Shahzad
On Sun, Dec 4, 2011 at 5:03 PM, Sam Mathai Chacko wrote:
> =SUMPRODUCT(($H$3:$H$14=B9)*($I$3:$I$14>9)*($J$3:$J$14="NPL"))
>
> Sam Mathai Chacko
>
>
> On Sun, Dec 4, 2011 at 4:16 PM, Aamir Shahzad wrote:
>
>> Thanks all of you. Noorain sb thanks
Nice & Thanks.
Regards,
Aamir Shahzad
On Sun, Dec 4, 2011 at 4:55 PM, Sam Mathai Chacko wrote:
> This is one way to do it
>
> =OR(AND($C2="UpCountry",$D2>15),AND($C2="Khi",$D2>3))
>
> Regards,
> Sam
>
>
> On Sun, Dec 4, 2011 at 4:32 PM, Aamir Shahzad wrote:
>
>> my query was if "upcountry > 15
=SUMPRODUCT(($H$3:$H$14=B9)*($I$3:$I$14>9)*($J$3:$J$14="NPL"))
Sam Mathai Chacko
On Sun, Dec 4, 2011 at 4:16 PM, Aamir Shahzad wrote:
> Thanks all of you. Noorain sb thanks for the sumproduct solution but can
> you tell me if I want to use the third criteria by sumproduct function how
> can I? i
This is one way to do it
=OR(AND($C2="UpCountry",$D2>15),AND($C2="Khi",$D2>3))
Regards,
Sam
On Sun, Dec 4, 2011 at 4:32 PM, Aamir Shahzad wrote:
> my query was if "upcountry > 15 and "Khi >3 you can see my attached file
> only one upcountry is not highlighted because it's less then 15.
>
> I ha
my query was if "upcountry > 15 and "Khi >3 you can see my attached file
only one upcountry is not highlighted because it's less then 15.
I have already done by
=AND(C2="Khi",D2>3)
=AND(C2="Upcountry",D2>15)
I only want to do this by One formula. And if grater then two scenarios
which function s
Thanks all of you. Noorain sb thanks for the sumproduct solution but can
you tell me if I want to use the third criteria by sumproduct function how
can I? in countifs we easily can use the third criteria. See the attached
file please.
Regards,
Aamir Shahzad
On Sat, Dec 3, 2011 at 10:24 PM, NOORA
Rohan - when I only use >9 it's shows error.
Regards,
Aamir Shahzad
On Sat, Dec 3, 2011 at 3:02 AM, Rohan wrote:
> Just use >9 as ">9"
>
>
> =COUNTIFS($G$3:$G$14,B4,$H$3:$H$14,">9")
>
> Thanks,
> Rohan.
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accura
Thanks Sir,
Its working, but it also hide its heading, is there any solution for not to
hide Column heading. (First three rows are heading)
This code hides all row having positive value in *both* column i.e. *"I"* &
*"L"*.
If value in any one column may be in *"I"* OR *"L"* is positive,* *then how
hi Experts,
Please advise is there any option to schedule for particular time to macro
for execution on its on own without manual intervention.
if so please advise in this concern.
Thanks,
Rekha
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles.
Sam thanks for your help in this concern however the below code when i try
it , i am getting bug in records passed. please assist in this concern.
On Wed, Nov 30, 2011 at 4:55 PM, Sam Mathai Chacko wrote:
> How about this
>
> Sub T()
>
>Dim rng As Range
>Dim lngRow As Long
>With Act
Thanks Sir,
Its working, but it also hide its heading, is there any solution for not to
hide Column heading. (First three rows are heading)
Regards
On Fri, Dec 2, 2011 at 8:13 PM, dguillett1 wrote:
> Option Explicit
> Sub ShowNegativesInColumnsI_L_SAS()
> Dim i As Long
> Application.ScreenUpda
Dear Masters,
Do you have macro for Gant's Chart? It would be very easy if we have a macro
for this. We can just update the data in excel & have a Gant's chart ready from
Excel.
Best Regards,
Amit
Disclaimer: This message and its attachments contain confidentia
Hi Group.
Currently i am working in Vendor management team & i want some vendor
management replated Excel file or tools or Templates.
Request you all if any one using any kindly of useful stuff related that
kindly forword me on group id or on my personal Email id
Thanks in advance.
--
Thanks &
37 matches
Mail list logo