Main Profile

At A Glance

Excel Magic Trick 311: Verify ID prefix w OR function 3 Examples

Learn about array syntax with the OR function. See three different ways to check if a Product ID prefix matches our companies three digits prefix. Learn about when Ctrl + Shift + Enter is required for the OR function and when it is not required see that array syntax can be used with the OR function to avoid an array formula that requires Ctrl + Shift = Enter. See OR and LEFT functions.
Length: 05:03

Contact

Questions about Excel Magic Trick 311: Verify ID prefix w OR function 3 Examples

Want more info about Excel Magic Trick 311: Verify ID prefix w OR function 3 Examples? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question