Skip to main content

How do I find the row number containing the minimum value in column 0?

The following series of formulas can be used to find the row number containing the minimum value (or the first occurrence of the min. value) in column 0. The row number is stored in memory register m2.

m2=0;
m1=cmin(c0);
m2=(c0==m1 && m2==0) ? index() : m2;

Scroll to Top
Synergy Software
Privacy Overview

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.