filter
5 TopicsHow do I Find/Replace or Filter with exact words/characters?
Requirement 1: I want to be able to filter the cells to the letter "a" or "is" Requirement 2: I want to be able to Find and Replace the word "is" with should be Issue 2: When I search for "is", the words "list" and "display" show up and so the output is lshouldt and dshouldplay Is this possible without VBA? ThanksSolved44KViews0likes10CommentsFiltered data in Excel online are visible for all users
Hi all! Is it possible to see only my own filtered data in Excel Online? I mean when other users are working with the same book at that moment. At the moment, when someone filtered data - every one who edit the same document will see the same filters. I would like to know is it possible to avoid this. Thanks a lot for yours answers! Have a nice day!156KViews0likes14CommentsFilterfunktion
Hallo Wenn man auf Teams eine Tabelle anlegt und diese aufgrund der Tabellenlänge anschließend filtert und nach excel exportiert, ist nicht das gefilterte sondern die ganze Tabelle wieder zusehen. Sprich man muss in Excel von neu Filtern. Woran liegt das? Mach ich etwas Falsch?899Views1like0CommentsFilter complex table to simple table
Hi, I have very big and complex table with loads of headers and information . Sadly I don't know what steps do I need to take ? But these are requirements Basically table consist of serial numbers with failed and pass and which stage failed and what it done to pass test . what I want do to create another table to summaries only failed ones and show only test failed for each test and why failed and what they did . thanks1.2KViews0likes1CommentFilter a list in place
I want to filter the following list in place where any of the 4 quartely columns contain the number 3. Name Q1 Q2 Q3 Q4 Peter 1 4 2 1 Lynn 2 1 3 4 Kevin 3 4 1 1 Paul 4 2 2 4 The answer I should receive is the row with Lynn and the row with Kevin. Any help you can provide would be greatly appreciated.Solved1.9KViews0likes2Comments