=SUM(OFFSET(A5,0,0,MATCH(MAX(A$5:A$999),A$5:A$999,1),1)), copy this to A2,
and then copy across to other cells
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
Thank you!
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of GoldenLance
Sent: Monday, June 13, 2011 7:14 AM
To: excel-macros@googlegroups.com
Subject: Re: RE: $$Excel-Macros$$ Please help to make my project good.
=SUM(OFFSET(A5,0,0,MATCH(MAX(A$5:A$999
@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of §»VIPER«§
Sent: Wednesday, May 11, 2011 10:36 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Please help to make my project good.
pfa
On Thu, May 12, 2011 at 12:31 AM, Mahesh parab mahes...@gmail.com wrote:
Hi
@googlegroups.com]
On Behalf Of Fabio Lemos
Sent: Saturday, May 14, 2011 7:03 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Please help to make my project good.
You also could simplify the formula by inserting the following in the E2
cell:
=OFFSET(INDIRECT('$A$2'!$A$1;TRUE
-macros@googlegroups.com'
Subject: $$Excel-Macros$$ Please help to make my project good.
Dear Mr. Fabio Lemos,
Thanks for your interest.
I tried to apply your below mentioned formula. I am getting error message.
Can you please send me sample file with formula. Thanks a lot for this
kindness
12, 2011 8:36 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Please help to make my project good.
pfa
On Thu, May 12, 2011 at 12:31 AM, Mahesh parab mahes...@gmail.com wrote:
Hi
check whether attach file helps.
On Wed, May 11, 2011 at 3:51 PM, karan 1237 karan1
Regards,Anil Bhange
IP Phone - 512320 | Mobile - 90290 32123
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of karan 1237
Sent: Wednesday, May 11, 2011 3:51 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Please help to make my project good
pfa
On Thu, May 12, 2011 at 12:31 AM, Mahesh parab mahes...@gmail.com wrote:
Hi
check whether attach file helps.
On Wed, May 11, 2011 at 3:51 PM, karan 1237 karan1...@gmail.com wrote:
Respected Sirs/Mam,
I need your help making my project good. Please find attachment. I will
be very
Respected Sirs/Mam,
I need your help making my project good. Please find attachment. I will be
very obliged if someone can help me as earlier as possible.
--
Basically I have to do that when I click on drop down list select another
career i.e. Building and Construction so In sub career
please check the attachment if it helps..
best regards,
STDEV(i)
note:
we need dynamic* Max Value* of ScrollBar
so we use Scroolbar from ActiveX Control, instead of from FORM.
A little macro wil work each time you change the career
On Wed, May 11, 2011 at 5:21 PM, karan 1237
Hi
check whether attach file helps.
On Wed, May 11, 2011 at 3:51 PM, karan 1237 karan1...@gmail.com wrote:
Respected Sirs/Mam,
I need your help making my project good. Please find attachment. I will be
very obliged if someone can help me as earlier as possible.
--
Basically I
11 matches
Mail list logo