Hello,
I try to make a formula when a text (a code) which exists on a row from a column if match with partial text from other column then in the new column to replace that text found with the value from another column on the same row with that code. So if text on A match partial from C then on D replace that "A text" with "B text" - attached file sample with sheet1.
Also, I will like to get some days grouped - the days marked with a colour (continuos days) to have as a result a cell where those days to be saved as a period (from / till). Attached sample on sheet 2.
Can you please help me with this?
Many thanks in advance!
Bookmarks