Hi all,
Hard to explain what I am after.
Sheet named Schedule: starting column V row 24: is has numbers that may appear in any row in that column, some are 1 to 100 others are over 100.
is there a formula to look into this column, return the first number it finds greater than 100
in the next row the formula will do the same thing but if the cell above already has a number over 100 it returns the next number it find over 100
example: row 26, 27, 28
4063222
120
4044735
the cells containing formula will return
4063222
4044735
and so on.
in column V row 1 to 23 there may be text (or nothing at all)
i hope this makes sense. tia.
Hard to explain what I am after.
Sheet named Schedule: starting column V row 24: is has numbers that may appear in any row in that column, some are 1 to 100 others are over 100.
is there a formula to look into this column, return the first number it finds greater than 100
in the next row the formula will do the same thing but if the cell above already has a number over 100 it returns the next number it find over 100
example: row 26, 27, 28
4063222
120
4044735
the cells containing formula will return
4063222
4044735
and so on.
in column V row 1 to 23 there may be text (or nothing at all)
i hope this makes sense. tia.
Last edited:
