Treating A Column As An Array

  • Thread starter Thread starter heiny06
  • Start date Start date
H

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
 
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
 
Back
Top