Return an address range?

[S. Anders]

I would like a formula/function that will return the address of the first and last values(not equal to FALSE) in a column.

Any advise would be appreciated.

[funkymonkUK]

I would like a formula/function that will return the address of the first and last values(not equal to FALSE) in a column.

Any advise would be appreciated.

please could you explain your problem abit more.

[S. Anders]

I have a colum with a conditional formula...

=IF(AND(A27>=ght1,A27<=ght2),A_1*(POWER((A27-offset)+D27,slope)),IF(AND(A27>ght2,A27<=ght3),A_2*(POWER((A27-offset)+D27,slope2))))

but once the conditions are not met, it puts FALSE in the cell.

4.88 1334.73
4.89 1342.35
4.90 1350.00
4.91 FALSE
4.92 FALSE
4.93 FALSE
4.94 FALSE

Since I am charting the data, I want the address for range of values, in this case the second column, that are not equal to FALSE.

Is this a better explanation?