WelshGareth
New Member
- Joined
- Sep 25, 2003
- Messages
- 40
Hi,
There are two relevant columns in a table of thousands. The first has the row count, the cells in the second are zero until a long way down the table when they start containing higher numbers.
At the moment, I have to scroll down until I see a number other than zero to see on which row this happened.
What I'd like is a cell to tell me on which row the value first ceases to be zero. Can anyone think of a way of doing this please?
Gareth
There are two relevant columns in a table of thousands. The first has the row count, the cells in the second are zero until a long way down the table when they start containing higher numbers.
At the moment, I have to scroll down until I see a number other than zero to see on which row this happened.
What I'd like is a cell to tell me on which row the value first ceases to be zero. Can anyone think of a way of doing this please?
Gareth