Forum Discussion
Deleted
Jul 29, 2025Excel 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...
Wishing_Well
Jul 30, 2025Copper Contributor
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
JKPieterse
Aug 01, 2025Silver Contributor
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?