Results 1 to 2 of 2

Displaying Maximum Values along with the name

Threaded View

  1. 06-12-2014, 05:30 AM #1
    Zaid
    Zaid is offline
    Registered User
    Join Date
    07-23-2012
    Location
    India
    MS-Off Ver
    Excel 2013
    Posts
    60

    Displaying Maximum Values along with the name

    Dear All,

    See attached the Excel. I have Category in "Column A" and Amount in "Column B".

    Now in Top 3 table i want the top 3 values from the table and same as i want in bottom 3 table. Please suggest a formula for the same.

    Regards
    Mohammad
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] sorting by maximum value and displaying a corresponding text with the maximum value
    By ScottBeatty in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 06-20-2013, 03:11 PM
  2. Counting specific values from maximum values of specified columns
    By Arkotan in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 05-06-2013, 05:16 AM
  3. [SOLVED] Displaying Maximum Valvue from a Set of Data with Same Common Entries but different Values
    By Zaid in forum Excel General
    Replies: 3
    Last Post: 07-23-2012, 11:02 AM
  4. This won't delete
    By hnidan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-17-2012, 04:11 PM
  5. Displaying larger values with smaller values in a Column Chart
    By Max9 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 06-20-2010, 11:59 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1