Hello, I am stuck on creating code to find the max in a set of data and outputting the name of the cell. For Example if I have the following data set:
<colgroup><col><col></colgroup><tbody>
</tbody>
The funtion needs evaluate the entire data set and output the name next to the max so in this case USNQX
Thank you for your help.
VIVIX | 0.142966875 |
HLIEX | 0.104074291 |
USNQX | 0.144564163 |
HNASX | 0.072884645 |
SCVIX | 0.068055342 |
MMYLX | 0.056515137 |
JDSCX | 0.080380966 |
WAMCX | 0.03907045 |
<colgroup><col><col></colgroup><tbody>
</tbody>
The funtion needs evaluate the entire data set and output the name next to the max so in this case USNQX
Thank you for your help.