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]

See one answer to your post in microsoft.public.excel

Please don't post the same question to multiple groups. You just
fragment your answers, and potentially waste the time of replyers in
replying to a question that's already been answered.

For tips on using these newsgroups effectively, please see

http://cpearason.com/excel/newposte.htm