Hi all
I have the below formula which works fine with just one minor adjustment required, is it possible to not display the 0 values under R&D results?
=FILTER(C4:D22,ISNUMBER(SEARCH(E4,C4:C22))+ISNUMBER(SEARCH(E4,D4:D22)),"no")
I have the below formula which works fine with just one minor adjustment required, is it possible to not display the 0 values under R&D results?
=FILTER(C4:D22,ISNUMBER(SEARCH(E4,C4:C22))+ISNUMBER(SEARCH(E4,D4:D22)),"no")
| Current | new | |||
| Project 1 | R&D 1 | Project 1 | R&D 1 | |
| Project 2 | R&D 2 | Project 2 | R&D 2 | |
| Project 3 | R&D 3 | Project 3 | R&D 3 | |
| Project 4 | R&D 4 | Project 4 | R&D 4 | |
| Project 5 | R&D 5 | Project 5 | R&D 5 | |
| Project 6 | R&D 6 | Project 6 | R&D 6 | |
| Project 7 | R&D 7 | Project 7 | R&D 7 | |
| Project 8 | R&D 8 | Project 8 | R&D 8 | |
| Project 9 | R&D 9 | Project 9 | R&D 9 | |
| Project 10 | Project 10 | 0 | ||
| Project 11 | Project 11 | 0 | ||
| Project 12 | Project 12 | 0 | ||
| Project 13 | Project 13 | 0 | ||
| Project 14 | Project 14 | 0 | ||
| Project 15 | Project 15 | 0 | ||
| Project 16 | Project 16 | 0 | ||
| Project 17 | Project 17 | 0 | ||
| Project 18 | Project 18 | 0 | ||
| Project 19 | Project 19 | 0 |
