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:
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
Last edited by a moderator: