hear_no_evil
New Member
- Joined
- Aug 30, 2006
- Messages
- 5
I have a list of data like the following:
#N/A, #N/A, 5, 20, 55, 10, #N/A, #N/A, 17, #N/A, #N/A
I would like to replace all #N/As with the next value to the right that is a valid number. However if the end value is #N/A then I want to use last non-#N/A value on the right hand side.
So my data would become:
5, 5, 5, 20, 55, 10, 10, 10, 17, 17
I'm looking for one cell that would hold the formula, if possible.
Thanks in advance.
#N/A, #N/A, 5, 20, 55, 10, #N/A, #N/A, 17, #N/A, #N/A
I would like to replace all #N/As with the next value to the right that is a valid number. However if the end value is #N/A then I want to use last non-#N/A value on the right hand side.
So my data would become:
5, 5, 5, 20, 55, 10, 10, 10, 17, 17
I'm looking for one cell that would hold the formula, if possible.
Thanks in advance.