Results 1 to 7 of 7

Row and column labels of ranked data

Threaded View

Ulrich Row and column labels of... 08-31-2010, 05:53 AM
sweep Re: Row and column labels of... 08-31-2010, 06:11 AM
teylyn Re: Row and column labels of... 08-31-2010, 06:13 AM
teylyn Re: Row and column labels of... 08-31-2010, 06:16 AM
Ulrich Re: Row and column labels of... 08-31-2010, 07:04 AM
sweep Re: Row and column labels of... 08-31-2010, 10:25 AM
Ulrich Re: Row and column labels of... 08-31-2010, 10:39 AM
  1. #1
    Registered User
    Join Date
    08-31-2010
    Location
    Bern, Switzerland
    MS-Off Ver
    Excel 2007
    Posts
    5

    Row and column labels of ranked data

    Hi all,

    I have a table with data (A1:C16) of which I have ranked the top 15 (F2:F16). Now, I would like columns H and J to indicate the respective row and column labels for these top values. I guess this should be possible with match/index in an array function, but I cannot get it done. Can somebody help? Many thanks!
    Attached Files Attached Files
    Last edited by Ulrich; 08-31-2010 at 10:41 AM.

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1