• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

kid asking help

sameeh

New Member
sir,

i have highlighted top ten values in a column in red, now i need the the data in the A1,A2,A3 .......A129 whicher ever row the value coming higher in red..i need the data in Row A in respective cell detailz must be displayed in a designated cell please help.

A B c D E

apple 10
orange 0


in respective to the value higher in column E highlighted top 10 value ,i need the data in cell A to be displayed respectively in a designated 10 cells.

Here is the sample file:
 

Attachments

  • TOOL BOX TALK WEEKLY STRENGHT TEST.xlsx
    46.6 KB · Views: 2
Last edited by a moderator:
Hi Sameeh,

Please try this: =SUMPRODUCT(LARGE(($BL$2:$BN$129)+ROW($BL$2:$BN$129)/10^10,ROW(A1)))
 
Back
Top