Timeline for Change text in one cell by removing the parts entered in other cells
Current License: CC BY-SA 3.0
13 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 21, 2016 at 23:02 | comment | added | user79865 |
You can't filter or join a two-dimensional array at once, it has to be one dimension at a time. Add a helper column with =iferror(join("|", filter(E4:H4, len(E4:H4)))), copy it down the rows 4-12, then apply same join-filter logic to the helper column.
|
|
| Jan 21, 2016 at 22:54 | comment | added | David | Is it possible to extend the range from: filter(E4:H4, len(E4:H4 to E:H12? Or is this another question I should ask on the board? I tried just changing the H4 without luck | |
| Jan 21, 2016 at 3:52 | vote | accept | David | ||
| Jan 20, 2016 at 22:21 | comment | added | David | OMG you are the best thing ever! thank you so much!!!!! | |
| Jan 20, 2016 at 22:16 | comment | added | user79865 | That's because the regex was case-sensitive: 2h and 2H are different things. I added case-insensitive flag (?i) to it now. | |
| Jan 20, 2016 at 22:15 | history | edited | user79865 | CC BY-SA 3.0 |
added 96 characters in body
|
| Jan 20, 2016 at 21:58 | comment | added | David | I still can not get the 2H to go away when put into the cell but can get the rest to go away, if I put the room 2 in before the room 2H. if I put 2H before room 2 then both will go away | |
| Jan 20, 2016 at 21:49 | comment | added | user79865 | Right, I did not include word boundaries. Edited the answer now to include them. | |
| Jan 20, 2016 at 21:48 | history | edited | user79865 | CC BY-SA 3.0 |
added 12 characters in body
|
| Jan 20, 2016 at 20:56 | comment | added | David | Thank you so much for taking the time. Below is a link to how this page is set up utilizing your formula (love it). Patients are dropped into boxes e4:G10. The RN is assigned her rooms: Cell B2 (ie rooms 1 2 3 & hall bed 2H). When the nurse has a pt is room 2, the 2 disappears on bothe the room 2 and the hall 2 (2H). If I could make it so if a nurse's count could keep the H number with the H (for hall bed) then I could see what rooms were still open for that nurse. docs.google.com/spreadsheets/d/… | |
| Jan 20, 2016 at 16:41 | comment | added | user79865 | Please clarify what was the input in your situation (the original content of B4), because apparently it's not the same as in the question. | |
| Jan 20, 2016 at 15:25 | comment | added | David | Thank you for your response and I like what this formula. Is there a way to adjust it a bit? If I have both 2 and 2H added to E4:H4 then both “2s” go away leaving just the H ib B4. Is there a way to do this? Thanks once again for the answer you have given thus far. It has helped tremendously | |
| Jan 19, 2016 at 23:16 | history | answered | user79865 | CC BY-SA 3.0 |