Hello,
as you can see in the Picture I have cells:
- empty
- only black
- only red
- black and red
Red is a correction, meaning if in a cell there are black in red characters it should delete the black characters, otherwise do nothing.
So I Need something like:
* run through all characters in a cell and check if there is a red one
* Count the number of red characters
* =RIGHT(current cell, number of red characters)
Maybe you have an idea how to realise the first two Points.
Thank you,
Daniel