Pivot table or maxif()
Jb
On 12/01/2012, Raghavan Manikandan <geethanjali_mani@yahoo.com> wrote:
> 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]
>
>
>
> ------------------------------------
>
> ----------------------------------
> 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
>
> ----------------------------------Yahoo! Groups Links
>
>
>
>
--
Sent from my mobile device
===========================
http://uk.linkedin.com/in/drjohnbullas
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