Excellent!! much appreciated.
Regards
Manikanan Raghavan
--- On Fri, 1/13/12, david.smart@ubs.com <david.smart@ubs.com> wrote:
From: david.smart@ubs.com <david.smart@ubs.com>
Subject: RE: [ExcelVBA] Max value in the table for each country
To: ExcelVBA@yahoogroups.com
Date: Friday, January 13, 2012, 5:17 AM
You can use array-entered formulas for this.
Assume
- your country codes are in A1:A10
- the numbers are in B1:B10
- A15:A17 are GB, NL and US, respectively, to drive the lookups
- B15:B17 will have the lookup formulas
Then B15 is =MAX(IF($A$1:$A$10=$A15,$B$1:$B$10,""))
Note that this needs to be array-entered (i.e. Ctrl/Shift/Enter).
You can then copy B15 down to B16 and B17.
Alternatively, a pivot table will presumably do the job, and would
provide flexibility to add extra countries without interaction.
Regards, Dave S
________________________________
From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] On
Behalf Of Raghavan Manikandan
Sent: Thursday, 12 January 2012 21:05
To: ExcelVBA@yahoogroups.com
Cc: Smart, David
Subject: [ExcelVBA] Max value in the table for each country
Dear Friends,
I have a table where I have some values for each country. I want to get
the max value for each country. please help me how to get it in excel
(not in excel vba)
Please refer the table below: -
Country
Value
NL
20
NL
50
GB
90
GB
10
NL
25
US
10
US
15
NL
60
GB
30
GB
20
Thanks & Regards
Manikandan Raghavan
[Non-text portions of this message have been removed]
----------
Visit our website at http://www.ubs.com
This message contains confidential information and is intended only
for the individual named. If you are not the named addressee you
should not disseminate, distribute or copy this e-mail. Please
notify the sender immediately by e-mail if you have received this
e-mail by mistake and delete this e-mail from your system.
E-mails are not encrypted and cannot be guaranteed to be secure or
error-free as information could be intercepted, corrupted, lost,
destroyed, arrive late or incomplete, or contain viruses. The sender
therefore does not accept liability for any errors or omissions in the
contents of this message which arise as a result of e-mail transmission.
If verification is required please request a hard-copy version. This
message is provided for informational purposes and should not be
construed as a solicitation or offer to buy or sell any securities
or related financial instruments.
UBS reserves the right to retain all messages. Messages are protected
and accessed only in legally justified cases.
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar