RobbieC
Active Member
- Joined
- Dec 14, 2016
- Messages
- 376
- Office Version
- 2010
- Platform
- Windows
Hi there, I have a column with data (O1:O21) with data which could look like this:
I'm looking to return the row number which contains the last non-zero value, which in this case would be row 18.
I'm having to bear in mind that there could be zero values in amongst the data, so I can't use COUNTIF to count cells >0
If you can point me in the right direction, I'd be very grateful. Thanks very much
I'm looking to return the row number which contains the last non-zero value, which in this case would be row 18.
I'm having to bear in mind that there could be zero values in amongst the data, so I can't use COUNTIF to count cells >0
If you can point me in the right direction, I'd be very grateful. Thanks very much