Forum Discussion
Excel formula to count and sum when value changes?
As a newbie to VB and excel I am having problem with the following, any and all help greatly received: Cell A1 is being populated by a data feed and is frequently changing (every second) in value, b...
Thank you for your response.
A1 and B1 are continuously changing cells populated by a live data feed.....I gave an example of how the cells might change every second. I am not sure how TEXTSPLIT would work in this case
OK, misunderstood. I though the values in cells A1 and B1 were as you posted them: "10,16,8,12,3". Hence my TEXTSPLIT function example.
Definitely needs some (VBA?) programming.
How does the data end up in cells A1 and B1 precisely?