B
Bagia
Hello,
I have a worksheet with several records(rows) and each record contains
several columns (5) with values. What I would like to do is to display the
top 3 values from that record. How would I set that up?
Sample Data:
For Row 1
ColA: 100
ColB: 150
ColC: 250
ColD:115
ColE:250
Top 3 Values would be from the list above would be: 250, 250, and 150. I
don't want to manually do this for 1500 records. Is there a way to write a
function for this?
Thanks in Advance.
I have a worksheet with several records(rows) and each record contains
several columns (5) with values. What I would like to do is to display the
top 3 values from that record. How would I set that up?
Sample Data:
For Row 1
ColA: 100
ColB: 150
ColC: 250
ColD:115
ColE:250
Top 3 Values would be from the list above would be: 250, 250, and 150. I
don't want to manually do this for 1500 records. Is there a way to write a
function for this?
Thanks in Advance.