Format as Date
Microsoft Excel MVP"
In my case I have cells A2:ZY2 full of data, and I am looking to find the first cell that has a greater value than the value in cell B6.
So far I have entered:
but like I said this is returning a value when what I am looking for is a cell location.
Any help would be appreciated!
> On Monday, January 18, 2010 1:22 AM crazyquasar wrote:
> I have a huge unsorted list of numbers (more than 100,000). I want to locate
> the first instance of a number greater than the first number in this list.
> any help will be greatly appreciated.
> thank you,
>> On Monday, January 18, 2010 2:24 AM crazyquasar wrote:
>> T Valko's answer in "locate first value greater than" solves the issue. His
>> answer is
>> "Another one:
>> Format as Date
>> Microsoft Excel MVP"
>> "crazyquasar" wrote:
>> Submitted via EggHeadCafe - Software Developer Portal of Choice
>> MongoDb vs SQL Server Basic Speed Tests
it will return the (relative) column number, but as your range begins
with column A then it is also the absolute column number. Try wrapping
an ADDRESS function around this (check it out in Excel Help).
Hope this helps.
> >>http://www.eggheadcafe.com/tutorials/aspnet/6f573869-c8eb-40c3-9946-2...- Hide quoted text -
> - Show quoted text -