Forum Discussion
Looking for a number in a cell of a range and returning other cells values
I am trying to make an schedule for my group. I want to know who is going to be working by knowing the days each member is going to be off Something like this: Formula located on E4 ret...
=TEXTJOIN(",",,FILTER($B$5:$B$9,NOT(ISNUMBER(SEARCH(E3&E2,$C$5:$C$9)))))If i adapt the data in range C5:C9 from e.g. "1 2 3 4 5" to "1F 2Sa 3Su 4M 5Tu" the above formula seems to work in Office365 or 2021.
Thank you! OliverScheurich