I want to find/create a function that will sort through a column and
return the cell that has a value greater than 'my number'


in c. i want
i = 0;
while (columnC[i] < 'my number')
i++;

now i can use i as the index that i need.



Any ideas for excel,???
Thanks a lot!


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements