•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Power Query - how to remove rows where column A begins with a certain string AND column B contains certain text?
How do i cleanse the following data to filter out anything where column A starts ABC and column B is “dog”?
This would be lines 4, 5 and 8 only in the table below:
COLUMN A | COLUMN B
:--|:--
DEF123 | HORSE
BCA3211 | MOUSE
ABC3111 | DOG
ABC4599 | DOG
ZXY7765 | HAMSTER
ABC 7711 | SQUIRREL
ABC6631 | DOG
ABC6669 | CAT
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com