I have a set of values like this:
1 | 21 |
2 | 22 |
3 | 23 |
4 |
I want to get the last value in column two, which is 23 on the third row since there's no more value below that row. This data is imported from an Excel worksheet.
Solved! Go to Solution.
Hi @45179902 ,
You can achieve this by filtering out any null values in Column B then using a sample tool to take the last value:
This then gives you:
I hope this helps,
M.
As well as using the Sample tool in @mceleavey's example above, you can use a Summarize tool with action set to Last. This is useful if you need to pull more stats, first, sum, average, etc. from the dataset
Dan