Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find the Longest Run.
I have a column of random numbers that are conditionally formatted for the
font to be blue if the number is = 0 and red if <0. How do I find the longest run of numbers that are = than 0 and the longest run that are < 0 within the column. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell/column auto adjusts width to longest text string | Excel Discussion (Misc queries) | |||
return cell address of longest text string in a range | Excel Discussion (Misc queries) | |||
Select longest call duration from 2 cells and place in another cel | Excel Discussion (Misc queries) | |||
Longest string in a column | Excel Worksheet Functions | |||
Longest Entry in Columns | New Users to Excel |