I am very much a beginner when it comes to excel so this might not even be the correct way to go but I have a file currently that filters out locations that I do not want to see. So for instance I have a part #, Qty, Location columns and a formula off to the side that says if the location equals and one of these locations to filter it out but I have come across som many locations I am getting an error. Here is the formula below is there a way I can do this without erroring out? I need to add more locations but it won't let me. thank you
=IF(OR(O6="VENDOR",O6="PURGE1",O6="SHPING",O6="SGI1",O6="P2RUBA",O6="WTGRTV",O6="SECRET",O6="01",O6="0000",O6="GPMRB",O6="CXP",O6="CXP1",O6="MEL",O6="P2MAZZ",O6="P2LOVE",O6="P2MELE",O6="00",O6="0",O6="P2JOHA",O6="P2MCMA",O6="P2SHAN",O6="P2VING",O6="TRAN",O6="NOFIND",O6="DI1",O6="WK1",O6="UNKW",H6>"4Z",H6<"4A"),"**","")
=IF(OR(O6="VENDOR",O6="PURGE1",O6="SHPING",O6="SGI1",O6="P2RUBA",O6="WTGRTV",O6="SECRET",O6="01",O6="0000",O6="GPMRB",O6="CXP",O6="CXP1",O6="MEL",O6="P2MAZZ",O6="P2LOVE",O6="P2MELE",O6="00",O6="0",O6="P2JOHA",O6="P2MCMA",O6="P2SHAN",O6="P2VING",O6="TRAN",O6="NOFIND",O6="DI1",O6="WK1",O6="UNKW",H6>"4Z",H6<"4A"),"**","")