Hi,
I need help with a formula.
I have a column A with numeric data in it. i want to check column A for last value greater then zero and then I want to copy the entire row.
<tbody>
</tbody>
With the above sample data i want to check in column A the last non zero value which in this case will be cell A3 and then copy A3:D3 to some other sheet.
Thanks!
I need help with a formula.
I have a column A with numeric data in it. i want to check column A for last value greater then zero and then I want to copy the entire row.
A | B | C | D | |
1 | 100 | Apple | Apple | Apple |
2 | 52 | Red | Red | Red |
3 | 46 | Orange | Orange | Orange |
4 | 0 | Yellow | Yellow | Yellow |
5 | 0 | Green | Green | Green |
<tbody>
</tbody>
With the above sample data i want to check in column A the last non zero value which in this case will be cell A3 and then copy A3:D3 to some other sheet.
Thanks!