| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Location of the first greater than cell
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, |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Location of the first greater than cell
T Valko's answer in "locate first value greater than" solves the issue. His
answer is "Another one: =INDEX(B1:F1,MATCH(TRUE,INDEX(B2:F20,0),0)) Format as Date -- Biff Microsoft Excel MVP" "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, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro - save to current location vs excel default location | Excel Discussion (Misc queries) | |||
| Target cell coloured based on whether one cell has a greater value | Excel Worksheet Functions | |||
| If (cell a2 is greater than 1, but less than B2 - C2, "X") how do | Excel Worksheet Functions | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
| Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Linear Mode
