1 of 1 people found this helpful
see the attached
as a formula try this
it returns this
it uses this table calculation as the base
then open the green pill (the calculation will default to previous value)
then pull the pill off the shelf and move to measure - you will see the formu that you can modify to meet your needs
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Thank you very much for the speedy reply Jim. I will give that a go, and then confirm if that does the trick.
Thanks Jim, that has had the desired effect.
Glad to help out