Forum Discussion
Conditional text move row to sheet
Okay. So I formulated this workbook, and of all things I've accomplished with it, this is the one I'm struggling with. I have Information from the Access Database coming in to the "Access Query" tab....
Maybe, the new FILTER-function can be of help:
=FILTER(RoomingList[NAME];IFERROR(SEARCH("Walk";RoomingList[NOTES];1);"")<>"")
If you place this function in cell A5 of the 728 Walk On-sheet it spills the names from the Rooming List-sheet where the NOTES-cell contains "Walk" as supplied by the Access Query-sheet. The outcome looks somethings like this:
Note that you have to unmerge the cells A5 till B29, otherwise the FILTER-function can't spill the result. You can use the same formula-structure for Branch and Room number.
I hope this puts you in the right direction. And for your convenience I attached a modified version of your workbook.
So, how would I go about pulling this information from the Power Query? Something that I'm struggling with at the moment is the Rooming List tab Concatenates some information while the tab I'm putting this formula into needs it individually. ie...m/f...Military Service...and that sort. The name pulling needs to be concatenated, Last, First, Middle Initial, but of course, I can worry about all of that.