Hi all,
I have a feeling this problem is not too complicated, but i'm struggling to find a formula to handle it, description below:
Column A contains numbers and #N/A or blank values. If there is a number in cell A1, I would like cell B1 to trigger a formula where it will search down column A to find the next number (skipping blank or #N/A values). Once it has found the next number I would like it to calculate the difference. I would like to implement this down column B. There will be inconsistent gaps between the number values in column A.
Crude example below:
<tbody>
</tbody>
Please let me know what you think is best here, thank you for your time,
Pete
I have a feeling this problem is not too complicated, but i'm struggling to find a formula to handle it, description below:
Column A contains numbers and #N/A or blank values. If there is a number in cell A1, I would like cell B1 to trigger a formula where it will search down column A to find the next number (skipping blank or #N/A values). Once it has found the next number I would like it to calculate the difference. I would like to implement this down column B. There will be inconsistent gaps between the number values in column A.
Crude example below:
Values: | Difference: |
10 | 5 |
5 | -10 |
15 | -5 |
20 |
<tbody>
</tbody>
Please let me know what you think is best here, thank you for your time,
Pete
Last edited: