treating a column as an array???????

[heiny06]

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


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

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



Any ideas for excel,???
Thanks a lot

 

[J.E. McGimpsey]

One way:

=MATCH(mynumber,C:C,TRUE)+1