Hello,
A text cells range is populated with data that looks like this "123456.01:78901". The numbers can be different but there is always a semicolon.
Sometimes there will be only one cell populated in the range with this data (for example D4) and yet in other occasions there could be more cells populated with the same type of data (for example D4:D10).
With the formulas
and
I am copying the numbers before and after the semicolon in two different cells S1 and S2 showing them separately.
But what I need is this:
Scenario 1:
If only D4 is populated with "123456.01:78901" than in S1 I will get "123456.01" and in S2 I will get "78901".
So far so good.
Scenario 2:
Now if in D4:D10 I have the same text "123456.01:78901" it is perfectly fine if in S1 and S2 I have the same result as in scenario 1.
Scenario 3 (the tricky part):
If D4 = 123456.01:78901 but some other cell in the range D4:D10 has different value (for example "654321.01:10987"), than in both S1 and S2 I would like just the text "see below" to be displayed.
I hope I was clear.
Thank you so much.
Bookmarks