Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
find cell with value greater than my number
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SMALL function to find X smallest number greater than Y | Excel Worksheet Functions | |||
How can I make a cell red if number is not greater than needed? | Excel Worksheet Functions | |||
Visual Script to find smallest number greater than 0 | Excel Discussion (Misc queries) | |||
countif formula to find the occurances of a number that is greater than one number but less than another | Excel Discussion (Misc queries) | |||
How can I get Excel to find the first number in a list greater tha | Excel Worksheet Functions |